A dashboard report places several reports, using separate datasets, on a single page. The example below is one report that calls 5 separate reports, once each:
NOTE: The example report shown on this page, and its component reports, are part of the Example Reports package download. This report is called "Example - Dashboard".
To create dashboard report, the set of subreports should only be run once, so the main SQL query in the parent report should use a simply SQL statement that only returns one row e.g. Select -1 as @ProjectId or even just Select 1
The Layout Details can then include each subreport as required. Each subreport will only be displayed once, because the main query only returned a single row. Each subreport query can use the same parameters as the main report and produces its own output.
To create the layout for the report, add the report name on the desired row and select the width of that subreport. Available widths are; Quarter, Third, Half, Two thirds, Three quarters and Full:
