Running a report multiple times

Question

Running a report multiple times

s_osborne2

SSCertifiable

Points: 6726
More actions
May 23, 2013 at 8:17 am

#274112

Hi,
So... I have a report that has a dataset that looks something like this:
AccountManager, Product, Value
The report has a variable called @AccountManager and what i want to do is call the report multiple times with a different @AccountManager each time, collate the reports into one Excel workbook and then mail that off to a list of recipients.
Can that be achieved with SSRS?
Thanks in advance for any help.
Simon

MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

s_osborne2 SSCertifiable Points: 6726 More actions · Answer 1

Hi,

Turns out I've answered my own question thanks to this thread: http://stackoverflow.com/questions/12526795/print-an-ssrs-report-multiple-times-based-on-a-value-entered

I've used a matrix with a dataset called AccountManager then used a sub report within the matrix to run the original report i wrote....

Hope this helps someone else.

Thanks,

Simon

MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne

Jeff Moden SSC Guru Points: 1004356 More actions · Answer 2

Wouldn't a query with a GROUP BY/ROLLUP have been easier?

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)

s_osborne2 SSCertifiable Points: 6726 More actions · Answer 3

Hi Jeff,

I do actually make use of a GROUP BY and a ROLLUP in the query behind the report but it's a full A4 page chart, not a table of data.

Thanks for the suggestion tho.

Thanks,

Simon

MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne