Post reply

SSRS 2008 data refresh issue

  • October 10, 2012 at 7:11 am

    #282988

    Hi,

    I'm facing a problem in SSRS 2008, I'm getting data from a stored procedure. Now I alter the sp and deployed the report again. But the new changed data are not getting refreshed in results. When I try to check the results in Preview of the report and in Debug, I'm getting some different results populated than from the sp.

    Please help me on how to get the data available in db.

    Regards

    Kalyani

  • October 10, 2012 at 7:54 am

    #1547660

    Need more information.

  • October 10, 2012 at 8:14 am

    #1547672

    IN SSRS report, I'm calling an Stored proc to display my results with ReportRundate as parameter

    I have an sp - DisplayProc, in which I'm displaying a data from table - QueryResult, with a parameter as ReportRunDate.

    Now,I updated the sp and I did an update in the last 2 columns of the table, which is an percent calculation like (Selected/Total)*100.

    When I exec this sp in SSMS, the table is getting populated with the correct percent value.

    But, when I tries to preview my report in SSRS I'm getting the old values populating in the percent column, this value is available just before I'm updating the sp. I'm not getting the values in that column after I did that update.

    I tried deploying the report also, In my report server I'm getting the same old values populating from that column.

    Hope it is clear now, I tried deleting the rdl.data file and executed the sp in SSRS query designer also, here I'm getting correct values but not in preview or after deployed.

    Regards

    Kalyani

  • October 11, 2012 at 5:15 am

    #1548012

    Delete the two columns in Report file and recreate the same and check

  • October 15, 2012 at 1:30 am

    #1549003

    Yes, I did the same still it's not working. Then I delete the whole tablix and recreated new one. In report preview I'm getting the refreshed data, but still the old data is reflected when I debug the report. It is also working fine, when I deploy the report.

    Thank you

  • October 15, 2012 at 8:09 am

    #1549149

    Some times preview does not show refreshed data, try to deploy it and see if it is displaying the correct data. I had same issue before when deployed and ran the report correct data was shown. I guess it is a bug with SSRS.

  • October 15, 2012 at 8:44 am

    #1549159

    Try to [Refresh Fields] icon from Design a Query.

Viewing 7 posts - 1 through 6 (of 6 total)

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