Can you use the group function on a rectangle in SSRS?

Question

I am trying to create several copies of a report all at once, so I have dropped all my elements in a rectangle. I was hoping I could set a group by function on the rectangle.. is this possible? Right clicking the rectangle and selecting properties, I do not see the same group option that most other objects have.

Answer 1

This issue can be resolved with this approach:

• Create a new report with a multi-value parameter for the order #'s.
• Add a tablix that uses the multi-value parameter to display each order #.
• Replace the field that displays the order # with a sub-report.
• Wire-up the sub-report to point to your original report and pass in the order #.
• Group by order # in the tablix (shouldn't change the tablix output if each order # is unique)
• Right click the Row Group and select "Group Properties"
• Choose "Page Breaks" and check the box "Between each instance of a group"