October 9, 2006 at 8:58 am
In 2005 Reporting Services, I am creating reports that ultimately will have many different underlying data sources (changing around the parameters of the sql statement and some of the table joins). Right now, some of these have up to 10 different underlying queries, but ultimately could have even many more.
I've created a stored procedure for each report that looks at the passed in parameters and then renders the proper SQL statement (actually, it calls another stored procedure that is just the appropriate SQL statement). As I add more potential data sources, the stored procedure gets more complex to manage. I do not want to make and store copies of the report (as they are extremely complex and change format quite often). Is there a better way to dynamically associate the proper data source with the report.
PS - if my terminology is not correct, please excuse me. Just entering the reporting services realm.
October 10, 2006 at 9:34 pm
Hi,
As far as i understood your issue. you wants to connect one report with different different data source. that is dynamic data source.
I am really not sure why u need this functionality. but if that is the case. the u can call ABC() Stored procedure and which will internally call another procedure for the same output parameter.
so what u r doing is correct as far as the report has the same output. I do not think why u r stored procedure is going complex.
Let me know if you still have some queries
Happy Reporting..
Labhesh S
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply