I've developed a SSRS report that summarises a whole range of info about a perf; eg price types detail, hold codes, unsolds by price zone etc.
This has been done using a number of tablixes each referencing different stored procedure datasets, and works fine for one performance. But if i pass multiple perfs then I lose the logical grouping and instead get each tablix repeat first for each perf.
ie: tablix 1 for perf1, tablix 1 for perf 2, then tablix 2 for perf 1, tablix 2 for perf 2 etc..., when what i want is tablix 1, 2, 3 and 4 for perf 1, then tablix 1, 2, 3 and 4 for perf2.
I'm a bit of an SSRS novice so thought i'd ask: is there some means of grouping all these elements into a single report entity that would repeat in its entirety for each performance?
Thanks, Peter