Create Custom Report

Creating the Custom Report involves the following steps:

1. Add new Data Source RecMngrPlusHistoryDataSource to Report

   • Configure Shared Data Source properties with a Connection string (Connection string to RecMngrPlusHistoryDB database).

   • Use this Data Source when you create a Dataset.

2. Add new Parameter StartDateTime to Report

   • Update DefaultValue to a day before.

3. Add new Parameter EndDateTime to Report

   • Update DefaultValue to the current date and time.

4. Add new Dataset ReportingTimeZones to Report

5. Add new Parameter ReportingTimeZones to Report

   • Add ReportingTimeZone parameter to Report below the StartDateTime and EndDateTime parameters.

   • Use ReportingTimeZones Dataset to get data.

6. Add new Dataset LayoutColorCodes to Report

7. Add new Parameter LayoutColorCodes to Report

8. Update main Dataset

   • Add Report parameters to the main Dataset parameter to filter Report data.

   • Use Dataset parameters in Expression to filter the data.

9. Update Report Code

   • Add Report Code GetServerTimeZoneSuffix to fetch the time zone in which the data is filtered.