As far as your second question, do you have a decimal in front of -99? If so, -12 would be greater than -.99, hence the error message. What happens if...

Below are instructions for handling your concern in SSRS, the case expression should handle it in SQL.

I set up a simple data set to make this work, containing the following:

select

'c'...

I've attached screenshots that go along with the directions, naming convention of images follows steps.

1) Your two subreport RDLs need to be in the same project.

2) Right click in the...

You could use two subreport boxes, one for Engineers and the other for Helpdesk. Then you could set the visibility property of the subreports based on the parameter selected.

Using SSRS 2008 I was able to build a county "heat map" of sales for one of our suppliers by following the instructions on https://www.simple-talk.com/sql/reporting-services/report-building-3.0-adding-maps-to-your-reports/ In the map layers property...