May 26, 2009 at 3:37 pm
up to this point most of my reports have only needed one dataset to support the report with the exception of a few used to support parameters. I am going down the path of creating a lot of executive summary reports where most will have several subreports.
All of my reports are supported by Stored Procedures with the exception of those parameter queries. I'd like to avoid having to generate a new stored procedure for each sub-report. It would be ideal if a report had a one to one relationship with a stored procedure.
I'm not sure how I could accomplish this. Any advice, or tips?
I'm on SQL 2005
Thanks - Rudy
May 27, 2009 at 7:57 am
Rudy,
I'm not sure what you are looking for here. Do you want to have ALL the data (parameter lists included) for a main report and subreports to come from the same stored procedure. I don't think this is possible because I don't think SSRS works with MARS (Multiple Active Resultsets).
Can you give a more specific example like this (using a manufacturing company as an example):
I need a dashboard report that accepts these parameters:
Facility - multi-value dropdown list of all facilities in the company
Start Date
End Date
And returns:
Production by Product
Production by Production Line
Sales by Product
Sales by Sales Region
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply