I have a Main report that has a sub report. The dataset has 5 rows returned when I execute the query. In the data return I have a field (we'll call Field1) and I set the parameter for the sub-report as field1, but the sub-report only executes for one row. I then created a list and added the subreport to that list and set the list grouping on the field. However, I am not getting the sub-report to execute for the other data rows. Any suggestions or point me to the correct way of doing so would be greatly appreciated.
-
-
I don't know what you mean by you set the parameter field in the sub report. You need to use a ripe source that returns all routes that you need and then set up the master/child relationship and the sub report filtering will happen automatically. -
Needed to put the main dataset in a list control that would then go through each row. For each row, then the sub report would execute with the parameter field from that row being passed.Comment
-
Thank you for your comment.Comment
-
Hi Brian,
You can do it by creating a Tablix ( that is mapped on the specific dataset that store your parameter)
You can then Create a group based on your parameter, In the row of your Tablix you can put inside a subreport that will contain as parameter your grouping already setted parameter for the row.
You'll then Get the report on each page for each row from the parameter.Comment
Comment