I am building an SSRS sub-report that displays a table of grouped records. At the end of the report there is another table that summarizes the records of the entire table above. What I need is for the summary table to appear after every grouping of records. The information inside the summary table is generated using SSRS expressions such as the one below.
=FormatNumber(AVG(Fields!Value1.Value, "Information") - Parameters!Value2.Value, 2)
How can I make multiple summary tables for each group of records within the first table, instead of one summary report for all of the records from every group. Currently I am trying to make a sub-report. There is two tables for one grouping of records per sub-report, but it isn't working.
Add a row into your table underneath the details row for your group. This one row will then be repeated after all your data for each group. You can then put your sub-report into this row and it will appear at the end of each group.