Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

cannot update fields when using Stored Procedure in SSRS Expand / Collapse
Author
Message
Posted Thursday, October 10, 2013 8:06 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, November 5, 2013 6:12 AM
Points: 30, Visits: 76
Hi folks,

I was wondering if anyone can help me out please.
I was using Stored Procedure in SSRS but when I use SP and click on Refresh fields the fields are not getting updated in SSRS.
I have around 6 parameters to pass to stored proc.
I tried in the follwing ways.

1)change the Querytype to Text
Execute sptest @param1,@param2,@param3,@param4,@param5,@param6

2)change the Querytype to StoredProcedure and selected my SP
Gave Refresh fields

But its not working for me.I would be very greatful if you could help me out.
Post #1503595
Posted Thursday, October 10, 2013 8:09 AM


SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Today @ 7:33 AM
Points: 1,780, Visits: 5,658
What is not refreshing?

Is it the output column names OR the parameter names?


MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1503599
    Posted Thursday, October 10, 2013 8:14 AM
    SSC Rookie

    SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

    Group: General Forum Members
    Last Login: Tuesday, November 5, 2013 6:12 AM
    Points: 30, Visits: 76
    The output column names are not getting refreshing.
    Post #1503606
    Posted Thursday, October 10, 2013 8:23 AM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Today @ 7:33 AM
    Points: 1,780, Visits: 5,658
    Are you using a temporary table in the stored procedure?

    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1503615
    Posted Thursday, October 10, 2013 8:31 AM
    SSC Rookie

    SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

    Group: General Forum Members
    Last Login: Tuesday, November 5, 2013 6:12 AM
    Points: 30, Visits: 76
    yes I have three temp tables in my stored procedure.
    Won't it work if I have temp tables in SP?
    Post #1503621
    Posted Thursday, October 10, 2013 9:33 AM


    SSCommitted

    SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

    Group: General Forum Members
    Last Login: Today @ 7:33 AM
    Points: 1,780, Visits: 5,658
    What version of Reporting Services are you on? If it is 2012, you can use WITH RESULTSETS, if not, you might be able to use a dummy statement in the SP:

    IF 1=0
    SELECT TOP 0 col1, col2, col3 etc
    FROM YourTable

    (where the column names and datatype match exactly to the actual output of the SP.)

    ... at the top of the SP sometimes works to provide enough column information.


    MM


  • MMGrid Addin
  • MMNose Addin


  • Forum Etiquette: How to post Reporting Services problems
  • Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
  • How to Post Performance Problems - by Gail Shaw

  • Post #1503659
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse