My SSRS 2005 Dataset refreshes fine but my report, even though I refresh isn't really picking it up 100%...it's missing an account but I know that account shows in my dataset in VS. I only am using one filter and that is fine...has no affect.
Is there a specific way to refresh my report after my dataset besides the refresh button for the report itself?
If you run the report in report designer, it will cache the data to a local file on disk (e.g. report1.rdl.data). The .rdl.data file should be refreshed if you click the green refresh icon in preview. If this doesn't work, you can always close report designer/VS, delete the .rdl.data file from disk and it will recreate that file the next you run the report by reexecuting queries.
-- Robert
|||thanks a bunch.|||Thanks for the info on the .rdl.data, but I don't have such a file.
Two (out of three) datasets (ds) on my report are not refreshing, and if you try to run them, they err. The third dataset works fine. And, another report with 3 other datasets, works fine.
I have verified all the way back to the stored procs (SP) for the name, and a syntax check. And, in query analyzer they run.
When you look at a good dataset window, you have the SP dropdown on the upper right, which if the dataset result is displayed, the drop down is not available.
Then there's a light yellow sql section that just says that the ds 'uses' the SP name.
On one of the non working ds's, the sql section is white, has my SP name in it as tho it was sql code, and the drop down says it's an SP and shows the correct name.
I also tried a brand new project with just one of the offending ds's, and it didn't refresh or run there either.
Halp.
sql