ACM ships with pre-made reports covering many different data topics. Custom reports can be created that are specific to your organizational needs. This page will show how to create a new custom report and where to locate it for users to access.
...
- Create a new file with the .XML extension. Assign a unique name.
- Paste in the sample File Format shown on this page.
- Enter a Name and Description for the report. Assign a unique name. This is the display name that will appear in report listings. The description is supporting text to explain what the report provides.
- Enter the SQL for the report:
SQL Query method.
Info Example: <!-- SELECT * FROM TblObjects ORDER BY ObjectId -->
Stored Procedure method.
Info Example: <!–EXECUTE dbo.asi_spProcedureName '@Parameter' -->
- Create one or more parameters as needed. If no parameters are needed, leave the parameters node empty. See Parameters section for details and examples.
- Save the file to the File Location shown below. The Report Service will include the new report the next time the listing is loaded or refreshed. There is no need to restart the Report Service.
...
<?xml version="1.0" encoding="utf-8" ?>
<report>
<name> NameName</name>
<description>Description</description>
<sql>
<!-- SQL -->
</sql>
<parameters>
<parameter type="Type" name="Name" description="Description" default="DefaultValue" />
</parameters>
</report>
...
| Type | Description | ||
|---|---|---|---|
| DateTime | A value representing a custom date and time modifier to start as a default. Uses the default attribute of the parameter node. See Supported Custom Defaults below. | ||
| Date | A value representing a Date. The UI will display a Date Picker control. | ||
| Boolean | A value representing a choice of True or False. The UI will display a toggle or checkbox control. | Value | A value representing a generic number such as a number of days or hours. The UI will display a number entrycontrol. |
| Integer | A value representing a generic number such as a number of days or hours. The UI will display a number entry control. | ||
| Device | A value representing a device object number. The UI will display a listing of protocol devices to choose from. | ||
| Object | A value representing an object number. The UI will display a listing of objects to choose from. | ||
| Meter | A value representing a meter object number. The UI will display a listing of meters to choose from. | ||
| Archive | A value representing a archive object number. The UI will display a listing of archives to choose from. | ||
| Publisher | A value representing a publisher object number. The UI will display a listing of publishers to choose from. | ||
| Filter | A value representing a archive filter object number. The UI will display a listing of archive filters to choose from. |
...