I ran across this error when I tried passing a hexadecimal value (0x1) from one report to another report.
Conversion failed when converting the varchar value ‘0x1’ to data type int. (Microsoft SQL Server, Error: 245)
It turns out that SQL Server Reporting Services (SSRS) will treat the hex value as a string and not an integer! It also didn’t help that I was mixing both hex and integers in the same query.
What did I do to fix this problem? Fortunately there was an easy solution. I simply converted my hex values over to integers. It took me a few minutes to resolve, but now everything is good.
If you have any questions about hexadecimal values in SSRS reports, please leave a note in the comment section below. Or, you can contact me on Twitter @GarthMJ or use the Techtalk address found on this page to send me an email.