
Once you have created your report, you can add it to the list of reports in the adTempus Console. When you do this, your report will have its own node under the Reports node, similar to the view for the Job Accounting report.
This view will allow the user to select the jobs to report on and, optionally, specify start and end dates for the report. You can also include HTML-formatted text providing help or additional information for the user.
First, copy your report file into the "Reports" directory under the adTempus program directory.
Then use a text editor to edit the file "userreports.xml", found in the "reports" directory under the adTempus program directory. (You may want to refer to the "reports.xml" file, which defines some of the reports included with adTempus, for an example.)
This report is an XML document, so some knowledge of XML is helpful but not essential.
If no other reports have been added, the file will look like this:
<?xml version="1.0" standalone="yes"?> <Reportlist> </Reportlist>
Between the "<Reportlist>" and "</Reportlist>" insert a new block of text for each report you want to add. This block must look like this:
<Report> <ConnectionType>External</ConnectionType> <DisplayName>Display Name</DisplayName> <ReportNameMSAccess>Report File Name</ReportNameMSAccess> <ReportNameSQLServer>Report File Name</ReportNameSQLServer> <ReportNameIntegratedSecurity>Report File Name</ReportNameIntegratedSecurity> <UseStartDate>True or False</UseStartDate> <UseEndDate>True or False</UseEndDate> <HelpInfo><![CDATA[ Help Text ]]></HelpInfo> </Report>
Replace the hyperlinked (blue) strings above as follows:
|
Value |
Description |
|
Replace "Display Name" with the display name for the report (the name that will be listed in the Console). | |
|
Replace "Report File Name" with the name of the report file to be used with a Microsoft Access database. E.g., "myreportaccess.rpt". This name cannot include path information: your report file must be in the "Reports" subdirectory under the adTempus program directory. | |
|
ReportNameSQLServer |
Replace "Report File Name" with the name of the report file to be used with a SQL Server database using SQL Server security. E.g., "myreportsql.rpt". This name cannot include path information: your report file must be in the "Reports" subdirectory under the adTempus program directory. |
|
Replace "Report File Name" with the name of the report file to be used with a SQL Server database that uses integrated (Windows) security. E.g., "myreportis.rpt". This name cannot include path information: your report file must be in the "Reports" subdirectory under the adTempus program directory. | |
|
Replace "True or False" with "True" if you want adTempus to display a date/time selector that allows the user to select a starting date/time for your report. Set the value to "False" if you do not need this parameter. | |
|
Replace "True or False" with "True" if you want adTempus to display a date/time selector that allows the user to select an ending date/time for your report. Set the value to "False" if you do not need this parameter. | |
|
Replace "Help Text" with any help text you want to display for the user. This text is shown in an HTML viewer in the upper-right corner of the report view (see the Job Accounting report for an example). The text you specify should be a properly-formatted HTML document. |