Imported reports show duplicate named entries with a - Query suffix

Article Id: 170489
Status: Published
Updated On: 24-01-2018 03:51
Legacy Id: TECH248182
Products:
Management Platform (Formerly known as Notification Server)
Cause:

Reports that are based on raw SQL queries normally have a hidden item in the console containing just the SQL query with an association to the report proper. In some instances this hidden atttribute is switched to 'normal', causing both the main report and the query portion of the report to be visible.

Resolution:

  1. Export the report with the -Query name
  2. Edit the xml of the report using Notepad or suitable xml editor
  3. Locate the <ItemAttributes> element and change the Normal value to Hidden
  4. Save and reimport the report

You'll see that the orginial report still runs, but the -Query report is no longer visible in the console