SSRS 2008 data refresh issue

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Business Intelligence » SSRS 2008 data refresh issue

SSRS 2008 data refresh issue

Rate Topic

Display Mode

Topic Options

Author

Message

kalyav21

Posted Wednesday, October 10, 2012 7:11 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

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

Post #1370908

vyas

Posted Wednesday, October 10, 2012 7:54 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 4:02 AM
Points: 3,131, Visits: 1,056

Need more information.

Post #1370931

kalyav21

Posted Wednesday, October 10, 2012 8:14 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

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

Post #1370947

vyas

Posted Thursday, October 11, 2012 5:15 AM

Hall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 4:02 AM
Points: 3,131, Visits: 1,056

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

Post #1371364

kalyav21

Posted Monday, October 15, 2012 1:30 AM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, November 21, 2012 5:24 AM
Points: 13, Visits: 26

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

Post #1372578

namratha.anumula

Posted Monday, October 15, 2012 8:09 AM

Forum Newbie

Group: General Forum Members
Last Login: Monday, October 15, 2012 12:03 PM
Points: 1, Visits: 24

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.

Post #1372750

mdsharif532

Posted Monday, October 15, 2012 8:44 AM

Grasshopper

Group: General Forum Members
Last Login: Thursday, April 11, 2013 2:09 PM
Points: 14, Visits: 97

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

Post #1372762

« Prev Topic | Next Topic »

Permissions