Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Fields not appearing in Report Data tab Expand / Collapse
Posted Thursday, May 29, 2014 7:21 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, August 17, 2016 5:21 AM
Points: 58, Visits: 279
I'm fairly certain that this is an environment issue but I don't know where to look...

The problem is I have a specific stored procedure that I am calling from SSRS 2008R2. It is nothing out of the ordinary, just over 1000 lines and for a given parameter it returns 33 records of 43 fields.

I have reduced the problem to its component parts by creating a new report, creating a new dataset to run the SP, I add the solitary parameter to be passed and click 'Refresh Fields'. Nothing happens.

When I click the 'Query Designer' button and execute the query I am asked for the value of the parameter and it returns the data correctly.

How can I get the field list to appear in the Report Data tab?

(I should add that other sps work just fine!)
Post #1575566
Posted Thursday, May 29, 2014 9:25 AM



Group: General Forum Members
Last Login: Yesterday @ 5:21 PM
Points: 2,193, Visits: 7,775
Does this SP have SET NOCOUNT ON; at the start? If not, try adding it.

does the SP use temporary tables? If yes, try adding a dummy 0 row select to the start that returns the exact same structure as your final select.


select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

  • 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 #1575637
    Posted Friday, July 25, 2014 6:45 PM

    SSC Eights!

    SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

    Group: General Forum Members
    Last Login: 2 days ago @ 4:16 PM
    Points: 988, Visits: 1,923
    I know this is not a current post but one thing to check is that in your desing environment you are pointing to the same data source as in the "published to" environment. Just one of those things in front of your nose you want to check off.

    How to post forum questions to get the best help
    Post #1596442
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse