How to Define a Report Layout for a Looping Layout

Question

User-1078520054 posted

I created the following question:  http://forums.asp.net/p/1983368/5683654.aspx?Re+Report+Viewer+Control+How+to+Define+a+Report+Layout+for+a+Looping+Layout

but I realize that isn't really what I needed as I need to group the totals columns by multiple columns, not just state, and need a "totals" column under as well.  Let me try again to explain a little better. 

<div>

The report will have the following data:

"Part  State  Fund MDP  ACO  Quantity   Unit Cost   Total Cost"

I want to create a report, that on each page, it prints a table of the first state. 

I have it working that it prints correctly with the group.  However:  after the each state, I need a section that prints the totals for the state based on ACO - MDP - FUND - TOTAL COST.  Then once that table is done, just a text box with the total cost for the state.  So there are three sections for each state: 

So the report viewer will get a recordset of data.  The report viewer will output to the user a report broken down by state that will

1).  Display all records in the recordset for that state (thanks to your help, I have been able to successfully do this)

2).  Once Step #1 has been completed, output another table that lists the records for the given state grouped:  ACM, MDP, FUND.  But the table will display the unique rows of ACM, MDP and Fund in a column with a fourth column of TOTAL Cost for the total cost of all items that fall into each group. 

3).  A textbox with the total cost of items for the state

Once all three sections have been displayed to the end user, a page break is added so the report can break.  This works for just step #1, but not sure how to incorporate step #2 and step #3. 

 

 

</div>