A customer had a requirement to see which reports had charts associated with them so they could consider them as Chart Gadgets in their Interactive Dashboard. It is not immediately clear from the standard report screen which reports might have a Pie chart or HBar associated with them:
To allow me to see which reports had charts I created a new Administrator report based on a new view that brought together the information from the various tables that are used to define a report.
This is a screen shot of the report.
Members of the Developer Program can download the a component which will install the report here- Component: Sage CRM v7.1, Create Admin Report showing Reports & Charts
The underlying view was called "vReportCharts" and was defined under the System secondary entity
Administration -> Customization -> System
and used the following SQL
SELECT dbo.Custom_Reports.Repo_ReportId, dbo.Custom_Reports.Repo_Name, dbo.Custom_Reports.Repo_Category, dbo.Custom_Reports.Repo_Title,
dbo.Custom_Reports.Repo_Description, dbo.Custom_ReportBands.ReBa_ViewName, dbo.Custom_ReportCharts.ReCh_Options,
dbo.Custom_ReportCharts.ReCh_LeftCaption, dbo.Custom_ReportCharts.ReCh_LeftFieldName, dbo.Custom_ReportCharts.ReCh_LeftFunction,
dbo.Custom_ReportCharts.ReCh_LegendAlignment, dbo.Custom_ReportCharts.ReCh_Style, dbo.Custom_ReportCharts.ReCh_GroupByField
FROM dbo.Custom_ReportBands INNER JOIN
dbo.Custom_Reports ON dbo.Custom_ReportBands.ReBa_ReportId = dbo.Custom_Reports.Repo_ReportId INNER JOIN
dbo.Custom_ReportCharts ON dbo.Custom_ReportBands.ReBa_ReportBandId = dbo.Custom_ReportCharts.ReCh_ReportBandID
For background reading about the structure of the Reports section please refer to
Once the view was created, the report was easy to define: