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.
Hi Sarah,
I've had this happen as well. Another option for getting rid of saved default parameters is to manage the report from Report Manager, found in the Miscellaneous reports folder within the reports module of Tessitura. From there you can delete any defaults that have carried over.
Dorothy
I've always been a bit nervous of just deleting the file there. Didn't know what other links might be dependant on it exisiting.
I replied this earlier by email, but it looks it didn't made it or it's taking longer than usual. This is what I wrote
I have this problem frequently. I found that Visual Studio caches report data in a file in the same folder where the report is stored. This file is called ReportName.rdl.data. Deleting this data fixes my issue.
Thanks to everyone for replying. It's sorted now, but I've taken on board all the comments about caching and will remember to to the clear thing in future.