Refer below for the report layout that I need to create in a report definition file using Microsoft Reporting Services 2008 in Visual Studio 2008. Note:There are two different PlanID's in this SQL Server 2008 R2 dataset.
FundName Amt1 Amt2 Amt3 Amt4 Amt5 Amt6 Amt 7 Amt8 Amt 9 Amt10
FundName1 100 150 75 400 50 350 800 600 780 100
FundName2 100 150 75 400 50 350 800 600 780 100
FundName3 100 150 75 400 50 350 800 600 780 100
Totals xxx xxx xxx xxx xxx xxx xxx xxx xxx xxx
Same layout but DivisonName2 would be on a separate page for the same PlanID.
How would I do the following to achieve the layout mentioned above: What fields would be in the row group? Do I need to have another group under the main row group? Page break for each instance of a DivisionName for that PlanID? Summary totals for each Amt field for each DivisionName for that PlanID? A page break on the second PlanID? Finally, a Grand total of the Amt fields for both planid's?
If you have any questions just let me know.
Thanks for your help,