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

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: Thursday, November 26, 2015 3:48 AM
Points: 51, Visits: 258
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 @ 4:39 PM
Points: 2,074, Visits: 7,086
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

    SSChasing Mays

    SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

    Group: General Forum Members
    Last Login: Yesterday @ 4:45 PM
    Points: 610, Visits: 1,271
    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.
    Post #1596442
    « Prev Topic | Next Topic »

    Add to briefcase

    Permissions Expand / Collapse