Custom reports are shown  on Centero Carillon portal reporting page. Custom reports to be shown are configured to Reports\CustomReports.xml file located on the Centero Carillon portal web site.

XML file contains Reports element where you can specify following elements:

• Node
• Report

Node elements

Node element is used to create folders in custom report tree view on Centero Carillon portal. Node is shown as a folder on tree view and each node can contain sub nodes and reports. You can specify following settings to node elements:

• Name: Name of the folder on tree view control (required)
• Description: Description of the report that will be shown as a tooltip when mouse pointer is placed over the folder ontree view (optional)
• Visible: Setting value to 'false' hides the folder from all users in tree view. Also all sub items are hidden. Value can be 'true' (default if nothing specified) or 'false' (optional)
• AllowedTo: Specify Windows groups or users who can see the folder in tree view. If value is not specified all users can see the folder. You can specify several groups and users using comma as separator. Use pre-Windows 2000 names for users and groups. User or group names cannot contain commas! (optional)

Report elements

Report element is used to show report on custom report tree view on Centero Carillon portal. You can specify report elements to Reports root element or inside any node element. You can specify following settings to report elements:

• ReportType: Type of the SQL command to be executed. Value can be 'Text' (default is nothing specified) or 'StoredProcedure' (optional)
• ReportCommand: SQL command to be executed. Value can be SELECT clause when report type is 'Text' otherwise name of the stored procedure to be executed (required)
• Visible: Setting value to 'false' hides the report from all users in tree view. Value can be 'true' (default if nothing specified) or 'false' (optional)
• AllowedTo: Specify Windows groups or users who can see the report in tree view. If value is not specified all users can see the report. You can specify several groups and users using comma as separator. Use pre-Windows 2000 names for users and groups. User or group names cannot contain commas! (optional)
• Text inside the item element: Name of the report on tree view control (required)

Example CustomReports.xml file:

<?xml version="1.0" encoding="utf-8" ?>
<Reports>    
   <Node Name="Activation codes" Description="" Visible="true" AllowedTo="">        
       <Report ReportType="Text" ReportCommand="SELECT * FROM [viewPortalReport_ActivationCodes]"AllowedTo="" Visible="true">All created activation codes</Report>      
       <Report Description="Recent means activation codes created during last 3 months"ReportType="Text" ReportCommand="SELECT * FROM [viewPortalReport_RecentActivationCodes]" AllowedTo=""Visible="true">Recent activation codes</Report>    
   </Node>    
   <Node Name="Computer group rules" Description="" Visible="true" AllowedTo=""> 
       <Report Description="All group rules created to single computers which are active.Computers that have not contacted Carillon system within 3 months are excluded from the report"ReportType="Text" ReportCommand="SELECT * FROM [viewPortalReport_ActiveComputerGroupRules]"AllowedTo="" Visible="true">Active computer rules</Report> 
       <Report Description="Shows individual computers from 'Active computer rules' andamount of rules created for specific computer" ReportType="Text" ReportCommand="SELECT * FROM[viewPortalReport_ActiveComputerGroupRulesMemberCount]" AllowedTo="" Visible="true">Computers withcomputer specific rules</Report>    
   </Node>
</Reports>