I am on SQLServer 2005
I have a sp with lot of params. I checked my sp. It works fine for every param.
My dataset is using the sp. It seems to pick the field list and params, but it will not return any result. I passed the same param to the ds as I did to sp. But, the report preview seems to alternate between displaying all data irrespective of the rpt criteria or nothing.
I do not have permission to run trace on the server
Any idea how to resolve this?
If you are using the report preview through Visual Studio, then you should know that reporting services tries to cache data from the data source so that formatting changes on long running reports do not take ages to develop by having to wait for the query to rerun. This has often cause reports to display with inconsistent data in the preview pane.
Check the location where the RDL file sits in the file system (the project folder) and you should see files with the same name as your RDL with a .data extension. This is where the designer caches the data and they safe to delete.
I have not found a way to stop this behaviour (and I don't think I would want to as it speeds up development) but I think it would be useful to be able to set this as an option in Visual Sudio.
It could of course be a bug in your code so I also suggest you deploy the report to the report server and run your report from the browser. If this still has issues then it's a bug in your code.
|||I did clear the .data file. Still the same result. Rpt preview fetches no records.
Thx
|||And is it fine when you deploy the report and test it from the browser?
No comments:
Post a Comment