News:

ARExcelReport. Quick start.

Let`s look how to start using ARExcelReport with simple example.

Task: you have to generate simple Excel report with customers list (we`ll use 'customers' table from 'DBDEMOS' Delphi sample database).

1) Since 'customers' dataset structure are known you may create the report template using MS Excel:

<#date1> tag will be replaced with current date.
Row with <#table:customer> tag and the next row is future table template.
COUNT(<#customers.*) tag will be replaced with 'customers' dataset records count.

See ARExcelMarkup.doc from component package for full list of template markup abilities.

Save this template (simple Excel document) as 'template-customers.xls'.

2) Drop Button1 component, Table1 component on form (DatabaseName='DBDEMOS', TableName='Customers.db', Active=True)

3) Drop ARExcelReport component on form, set Filename='template-customers.xls'.

4) Add DataSetList Item linked to Table1 and assign 'Customers' name to it:

This DSName 'CUSTOMERS' you`ll be able to use in report template as Table1 alias.

5) Add Button OnClick handler:

procedure TForm1.Button1Click(Sender: TObject); begin   //Addind <#data1> tag value   ARExcelReport1.CustTagValues.Clear;   ARExcelReport1.CustTagValues.Add('date1='+DateTimeToStr(now));   //Preview report   ARExcelReport1.Preview; end;

6) Run application and press 'Preview' button. Report is complete!