October 16, 2009 at 4:40 am
I have a report based on a SQL query, the parameter for this is a year value to extract data from a particular year. When I run the query in any TSQL editor or the Report data designer it works as expected. In the report designer I added a couple of calculated fields that depend on the value of another parameter.
Whenever I run the report the data is the same no matter what I put in as the year parameter, the calculation parameter changes the calculated fields but the original data is always the same.
Is there a cache I am unaware of? any one else had similar problem?
October 16, 2009 at 8:28 am
Sometimes you need to go through the XML line by line until you find that somewhere in the past you have edited it so that the parameter has now got a fixed value no matter what you put in the parameter input box. I am going to blame my boss as he has a tendancy to fiddle with things and not tell me and I swear it wasn't me 😀
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply