A dashboard report places several reports, using separate datasets, on a single page. The example below is one report that calls 4 separate reports, once each:
NOTE: The report shown on this page called 'Example - Dashboard' and its component reports, can be downloaded as part of the Example Reports package.
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 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’s query can use the same parameters as the main report and produces its own output.
