Menu
I struggled with this issue for too long before finally tracking down how to avoid/fix it. It seems like something that should be on StackOverflow for the benefit of others.
I had an SSRS report where the query worked fine and displayed the string results I expected. However, when I tried to add that field to the report, it kept showing "ERROR#". I was eventually able to find a little bit more info:
The Value expression used in [textbox] returned a data type that is not valid.
But, I knew my data was valid.
408
This log is on by default and can be found in: C:\Program Files\Microsoft SQL Server\MSRSXX. SQL2012\Reporting Services\LogFiles or some variation depending on your SQL Server installation.
View the Report Server Logs The default directory for log files for a default installation is <drive>\Program Files\Microsoft SQL Server\MSRS130. MSSQLSERVER\Reporting Services\LogFiles .
Using IIF Function in SSRS We are going to add a new field to the report data set to determine if the Order Year is the Max or Current Year. As shown below, the dataset properties window is opened, and the Fields tab is selected. After clicking Add, at the bottom of the list a new field is added.
Found the answer here.
Basically, it's a problem with caching and you need to delete the ".data" file that is created in the same directory as your report. Some also suggested copying the query/report to a new report, but that appears to be the hard way to achieve the same thing. I deleted the .data file for the report I was having trouble with and it immediately started working as-expected.
193
After you preview the report, click the refresh button on the report and it will pull the data again creating an updated rdl.data file.
25
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
