Post reply

Available fields disappear when changing stored procedure in dataset properties

  • May 3, 2012 at 9:14 am

    #260969

    I'm copying a report, and want to change the stored procedure in the dataset properties. But when I do that all fields disappear. Now I found the following solution. Change the property to a text and change the text into this :

    DECLARE@return_value int

    set dateformat dmy

    EXEC@return_value = [dbo].[Name stored procedure]

    @dtStart = N'01/04/2012',

    @dtEnd = N'30/04/2012'

    SELECT'Return Value' = @return_value

    When I do this in fact I get a return of the fields. But as such my parameter values are fixed. so when I'm changing the dataset properties again to the correct stored procedure my data fields dissapear again.

    Anyone got any clue ?


    JV

  • May 3, 2012 at 2:06 pm

    #1483335

    If I change the stored procedure, I test it by clicking the Query Designer button, and then the red ! button to run it. It will bring up a box to enter in the parameters and return the data.

    Usually the Refresh fields button will do that too.

  • May 4, 2012 at 12:44 am

    #1483408

    Sarah

    Unfortunately they disappear.

    Kind regards


    JV

  • May 9, 2012 at 2:40 am

    #1484930

    jvElecenter (5/4/2012)

    Sarah

    Unfortunately they disappear.

    Kind regards

    I have also seen this behaviour in BIDS (2008 R2) - I use BIDS helper[/url] from codeplex to delete the cached datasets to ensure im getting a clean slate.

    gsc_dba

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply