How can I create like this in SSRS? The color will change from red to green based on a value in a row (Underwriter). And all that in a group: Answer You can do this by right clicking on the individual cells and setting the fill colour based on an expression: In the Image below I’ve mistakingly put ̶…
Tag: reporting-services
SQL Server Reporting Studio report showing “ERROR#” or invalid data type error
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…
Insert decimal with comma is interpreted as two values
I’m creating an ssrs report and creating a mockdata sql script. In the script I want to insert a decimal value like so: The values after “someString” are actually one decimal value with a comma as decimal separator. SQL interprets this as separate values though and hence throws an error abou…
Passing multiple values for a single parameter in Reporting Services
I have several Multi-Select parameters in my report. I am trying to find a way to pass in multiple values for a single parameter in the web query string? If I pass in a single value, it works fine. The report runs fine selecting multiple choices for a single param. My trouble lies in the web query string. Ans…