pensiongenius
asked on
Page Break on Division Name and Grand Totals for a MS Reporting Services 2008 report
Hello experts,
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.
PlanID 1
FundName Amt1 Amt2 Amt3 Amt4 Amt5 Amt6 Amt 7 Amt8 Amt 9 Amt10
DivisionName 1
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
etc
DivisionName1
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,
Ting
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.
PlanID 1
FundName Amt1 Amt2 Amt3 Amt4 Amt5 Amt6 Amt 7 Amt8 Amt 9 Amt10
DivisionName 1
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
etc
DivisionName1
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,
Ting
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
His recommendation worked and he explained it in way that I understand.
Glad to hear I could help you out!
ASKER
Sorry for the delay in responding back to your comment. I tried your recommendation and it worked.
Thanks for all your help,
Ting