Morning Tessitura Community,
I've got an SP which returns lots of lovely data and calculations for my SSRS report. I can run the SP in Management Studio and get exactly what I want. I've created a dataset in VS and when I do a query on it, I get exactly the same data. No surprise.
Then I run my report in Preview and get some different results. Odd.
Datasource is attached to the correct database instance. I'm running the correct SP.
I've experimented by adding some spirious characters to one of the fields I'm passing to the rdl and the new character will turn up when I run a query, just not when I run a Preview.
I also notice that running a preview will produce the report immediately, which is not what I expect. It should take a few seconds to pull out all the data. So this makes me think that the preview might be being cached in some way but I don't understand how that could be and how I could clear the cache.
Has anyone seen this in the past? Or has an idea of what could be causing it?
Thanks all. Debbie
So, I've found a thread which tells me how to clear the report cache. Done that, no change.
Link is: http://jasonfaulkner.com/ClearDataCacheBIS.aspx If anyone is interested.
Debbie
Hi Debbie!
Do you have default values set for your paramters?
Hi Debbie,
Have you ever set any Default Values in VS for this? Or has the report been created by copying another report that might have had Defaults? I've had it before (about 2 weeks ago) where although I'd deleted the Defaults from the parameters, they still existed within the code. I think I ended up deleting it and starting again, though I copied the matrix across to another report first so I didn't lose too much of my work!
Thanks,Sarah
Thanks for the suggestions. This report has no parameters. In the end I deleted it and started again. It was something that I just couldn't find, so that seemed the easiest solution. I did take a look through the code, but couldn't see what it might have been.
It's returning the correct data now, so I guess whatever was causing it got flushed out somewhere. Sadly, I don't have a definitive answer.