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.
MCSE: Data Platform
MCSE: Business Intelligence
Follow me on Twitter: @WazzTheBadger
LinkedIn Profile: Simon Osborne