SSRS - group a sub-report?

It’s certainly possible, but keep in mind that if you use a sub-report in a grouped area, the sub-report is called once for each group, which can be very slow.  If you can, try to consolidate the data into a single dataset.  Sometimes it’s better to use a separate set of columns and do a union, so your report dataset may look something like this:

order     tickets   ticket amount    fee         fee amount

1000       2              100.00                   0              0

1000       0              0                              1              3.00

Because you’re grouping by order number, you’ll see the data in aggregate.

+Ryan Creps

+Tessitura Network

From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Brian Graham
Sent: Friday, November 25, 2011 2:22 PM
To: Ryan Creps
Subject: [Tessitura Technical Forum] SSRS - group a sub-report?

I've got a new sales report that breaks out items sold in an order and fees. I want to use a sub report for the fees, but is it possible to group a sub report under another grouping in SSRS? So it would look something like this:

order_no

              li_no(grouped on order_no)

              sub_report_fees(grouped on the order_no from the above report)

Does this all make sense? And is what I'm trying to do possible?

thanks,

Brian

This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!