Data Problem - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Analysis Server and Reporting Services (2005)

Data Problem

Author

Topic

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2008-12-09 : 08:43:12

Hi Guys

I have a parameter driven report. When I first run the report with the required parameters I get no data back, when I then run the same report straight after with the same parameters I do get data but this time it has been duplicated.

Does anyone know why this could be happening? Is it to do with the cache?

Thanking you in advance!!!

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-09 : 11:58:17

nope. dont think its the problem with cache. are you using query or procedure as source?Either case, try executing it directly in query analyser and see what it returns.

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2008-12-09 : 12:03:36

Its using a stored procedure. I've tried runnning it in management studios and the it seems to run through fine. Its just when its run in Reporting Services.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-09 : 12:16:07

quote:
Originally posted by rcr69er

Its using a stored procedure. I've tried runnning it in management studios and the it seems to run through fine. Its just when its run in Reporting Services.

what heppened when you tried executing this in datatab of report to populate dataset grid? did it give desired results? also are you using temporary table and retrieving resultset from it in procedure?

rcr69er
Constraint Violating Yak Guru

327 Posts

Posted - 2008-12-09 : 14:46:28

Hi

Yes I get the desired result when run in the database. And yes there are temp tables involved.

Thanks

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-10 : 02:37:40