adding 4 stored procedures with same parameters but different constant in one report of SSRS on 4 datasets
Sunday, January 20, 2013 10:13 AM
I make 4 stored procedures .
All have a same query and taking same parameters.
But the difference is the one value which we input in the stored procedures as a constant.
Now I am using these stored procedures in the SSRS.
One stored procedure is using for one PIE Chart.
What I want to use 4 stored procedures and make 4 DataSet in the SSRS Report.
and will put 4 PIE Charts . and will put columns from these DataSets to PIE Charts.
I make one dataset is OK.
But try to make 2nd dataset with the new stored procedure and try to refresh fields by pressing button.
the error is generated .
Sunday, January 20, 2013 1:14 PM
>>>>What I want to use 4 stored procedures and make 4 DataSet in the SSRS Report.
Is it better to have ONE stored procedure with the parameter that differentiate the data to be output? You can add there -four chart controls and based on the parameter to make it visible.....
Best Regards,Uri Dimant SQL Server MVP, http://sqlblog.com/blogs/uri_dimant/
MS SQL optimization: MS SQL Development and Optimization
MS SQL Blog: Large scale of database and data cleansing
Remote DBA Services: Improves MS SQL Database Performance
- Proposed As Answer by Fanny LiuMicrosoft Contingent Staff, Moderator Monday, January 21, 2013 11:10 AM
Monday, January 21, 2013 12:19 PMresolved
Friday, January 25, 2013 10:03 AMModerator
Glad to hear the issue had been resolved.
If you find out the root cause finally and the solutions, you can share the solution and experience and mark it as answer. It will be very beneficial for other community members who have similar questions.
TechNet Community Support