CODEWITHSUNDEEP
reporting-servicesssrs-2008-r2ssrs-2012
SJaka
SJaka

Reputation: 840

SSRS - Why the sub-report is printed multiple times?

I'm new to SSRS and know little about groupings in SSRS.

I've an order confirmation report. The report has two groups (orderHead and orderLines). I've added a table row at the bottom of the report to contain a sub-report (that must run for some clients). This sub-report is not part of the grouping, but just sit at the bottom of the table.

Sub-report image

The problem I'm facing is that if the order has multiple lines, this sub-report is printed as many times as the order lines. How can I restrict it to print exactly once? Report Groups

Upvotes: 0

Views: 474

Answers (1)

Lynn Crumbling
Lynn Crumbling

Reputation: 13367

If you don't want the subreport to print for each detail item, move it out of the detail group. I'd think you'd want it as a report footer, or possibly on the footer for group 1.

Upvotes: 0

Related Questions