User Manual

Reports
ConfigurationSheet
The configuration sheet is a repository where configurations on the Microsoft
Excel report template can be made. This sheet is not visible in the generated
report.
1.
Create a new worksheet in the report template. Name the sheet <#Config>.
2.
Row 10, and all rows below, in column A and B can be used to configure the
SQL queries. Enter the SQL query in column B. Use the corresponding cell
in column A to enter a name for the query. The name is used to refer to the
query in the report template.
Enter the SQL queries in the following format:
SQL(DatabaseName; SQL query)
Example: SQL(General; SELECT * FROM DataLogger1)
There are two available databases: General and AuditTrail.
PresenttheDatabase DataintheReport
ThedataretrievedfromtheSQLdatabase,usingthequeriesintheconfiguration
sheet, can be presented in the report using “named ranges” in Microsoft Excel.
A named range is created in Microsoft Excel by following these steps:
1.
Select the cells to be included in a named ran ge.
2.
Click the Define name command from the Insert menu. (In Excel 2007, go
to the Formulas tab and choose Name Manager).
3.
Enter a name for the range. The name must be entered in the following
format:
“__QueryName__”.
Replace “QueryName” with the name that you have chosen for your SQL
query.
To present the data in the report, enter the following syntax into the cells included
in the named range:
<#QueryName.DatabaseColumnName>
Replace the “DatabaseColumnName” entry with the actual name of the table in
the SQL database that you wish to present in the report.
Note:
Itispossible tousethenamed rangecellsinM icrosoftExcelcharts and functions.
Tobeabletousethenamedrangeinfunctions,anemptyrowmustbeinsertedunder
thenamedrangecells. Thisemptyrowmustalsobe includedinthe function.
Relatedinformation
Addinga Report
12.2 ReportsSetUp
The reports configuration page are available from the Insert ribbon tab.
Relatedinformation
InsertRibbonTab
282
BeijerElectronics, M AEN831P