• View
• Edit
• History
• Print
• Backlinks

Example of Internal XLS report

We want to create report that basing on internal ProReports database will generate file *.xls containing several columns with user data. Example uses plugin xlsrep.php which will greatly help in creating files for MS Excel.

At first we have to register report using prepared earlier form named LOGIN. When registering from plugin list (Other files) we choose plugin xlsrep.php:

Next we need to register elements of a report:

• element A

$V[xls]=f_InitHeadRepXLS("users");
$V[xls].=f_AddColumnRepXLS(array("80","100","100","100","60","80"));
$V[xls].=f_AddHeadRepXLS(array(
"Login"=>"String",
"Name"=>"String",
"Surname"=>"String",
"City"=>"String",
"Number"=>"String",
"Amount"=>"String"
));

$V[xls]

When registering elements is good practice to use enlarged edit window (icon ), where available are following tools snippets/helpers that make it easier to fill every section of element:

Clicking on selected element will input linked with elements text fragment in edit window in place pointed by cursor. Thanks to that we speed up process of creating a report, because there no need to memorize functions available in plugin and parameters linked with it.

• element B

$V[xls]=f_AddRowRepXLS(array(
array("$F[B_login]","String"),
array("$F[B_name]","String"),
array("$F[B_surname]","String"),
array("$F[B_city]","String"),
array("$F[B_number]","Number"),
array("$F[B_amount]","Currency"))
);

$V[xls]

• element C

$V[xls]=f_FootRepXLS();

$V[xls]

After compiling report we can run it by selecting from menu option Execute:

Before generating report the form linked with it will be shown:

Using button Generate begins report generation process which end in creating *.xls file.