Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
adding 4 stored procedures with same parameters but different constant in one report of SSRS on 4 datasets

Resposta Proposta 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
     
     
    Sign In to Vote
    0

    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 .

     

All Replies

  • Sunday, January 20, 2013 1:14 PM
     
     Proposed
    Sign In to Vote
    0

    >>>>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

     
  • Monday, January 21, 2013 12:19 PM
     
     
    Sign In to Vote
    0
    resolved
     
  • Friday, January 25, 2013 10:03 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi John,

    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.

    Regards,
    Fanny Liu 

    Fanny Liu
    TechNet Community Support