Get help troubleshooting common issues when building custom reports
Due to the highly customize-able nature of the Clear Impact Scorecard Custom Reporting Module our standard support desk does not directly troubleshoot issues related to report configuration such as incorrect data displaying on reports.
The documentation provided here covers some of the common problems and solutions to help you build better reports. The custom reporting module is designed for tech savvy users to take advantage of advanced functionality and often some experimentation and these steps can help you get the report you want.
If you are still unable to get your report working properly please contact your account manager and our professional services team can help you with your custom reporting needs.
No Data Displays
This issue can be caused by several factors.
Fix #1: Try checking the "Allow Nulls" checkbox at the top of the Data Sources tab. This effectively changes your report to a full outer join.
Fix #2: On the data sources tab click the advanced button at the bottom (note this cannot be undone so you may want to save a copy of your report first). This will show you the join parameters between your tables and let you better customize your joins to select the proper data.
Fix #3: Using the normal interface navigate through the software and confirm the data you are expecting does exist.
Many duplicated records displaying
This often happens when many records are referencing the same object in your report.
Fix #1: Try checking the "Distinct" checkbox on the top of the Data Sources tab
Fix #2: If your report has many items related to a single item the best way to deal with this may be to use the visual grouping configuration. On the Fields tab select the VG checkbox next to the field with duplicate values.
Partial or Incorrect Data Displaying
Fix #1: Check your filters tab to make sure your filters are configured correctly.
Fix #2: Try checking the "Allow Nulls" checkbox at the top of the Data Sources tab. This effectively changes your report to a full outer join.