Hi, Any one pls tell me deployed reports in report manager showing wrong values. but in solution preview it is showing zero values. I have checked datasource also connecting to datamart is fine. also deleted cache. Pls guide me. Thanks, Abdul2010

Hi Abdul, Can you check your report's data source in Report Manager, that your reports are pointing to proper data source which inturn pointing to proper DB?Suresh My Scribbling

ya checked it is same database only pointing.

Then the other option I would like you to try is trace the sql query using profiler. Here is how I will proceed Start the profiler and trace the said database Run the report from BIDS Run the report from Report Manager Compare the trace and see what is the difference.Suresh My Scribbling

Hi, There is no chance to displaying wrong values in Devlopment to Production. Do this Steps. 1. Go to Report Manager and check DataSource Credentials for Checking wich DB is Accessing. 2. Otherwise change the Input Parameters. Regards, RAZ..