SSRS 2008 Report toggling between images for various field values

reportingssrs-2008

What is the best way for toggling between images on a SSRS report?

On the report I'm creating, there are lots of questions with Yes Or No answers and based on the value I've got for the question, I'd like to show the correct image.

For example we have gender:

Famale
Male

This report is for output only and is not going to be used for performing data entry.

For each record I have the value in the column 'Gender' whether the person is male or female. I want to show a square with a tick mark in it next to the correct gender, while keeping the other option box empty (an empty square image). This should function like a radio button.

So if the record has gender = 'Female', I should show a tick image next to Female text box and an empty square next to Male text box and, vice-versa, if gender = 'Male' on the record.

Any suggestions?

Best Answer

You can use expressions for this type of conditional work. To do this click on the image and select the properties tab in BIDS. Find the expression button (fx) and click it. Enter something like the below to get what you want:

=Iif(Fields!Gender.Value = "Female", "Female.jpg", "Male.jpg")

This is assuming that you have have set up the images to be available as global resources to your report. If not, replace the image names with the paths to the images etc...

A good reference for expressions is below:

http://msdn.microsoft.com/en-us/library/ms157328.aspx

I hope this helps you.

Related Solutions

Page setup and print layout in SSRS Report

The page setup in the print options does not control your report parameters. You will need to use the Height/Width property of the report inside BIDS. Orientation in SSRS is controlled by setting these values. We have a report at our office that is similar to what you describe and there are two ways of (semi) achieving what you want to get done.

The first is to use a separate report for each page that you want. This gives you complete control over all elements of each page such as height/width etc but may be more work for you to do and possibly more maintenance in the long run. It does however mean that should you change elements of the report later you only have to retest the bits you have changed, not the entire report.

The second one is to you expressions to force page breaks. This will work for reports that need the same orientation (as they inherit the properties set on the report container) but will not work for a report that has a different orientation. A link to an example of page breaks is below:

http://msdn.microsoft.com/en-us/library/ms157328.aspx#AppearanceofReportData

I hope this makes sense and that it helps you in what you want to achieve.

SSRS 2008 – How to Total values from an expression

You actually just put a SUM around the outside:

=Sum(IIF(Fields!Role.Value = "Contractor", Fields!actualwork.Value * 100,
Fields!actualwork.Value * 77))

It will evaluate that row by row and will provide the correct sum.

Best Answer

Related Solutions

Page setup and print layout in SSRS Report

SSRS 2008 – How to Total values from an expression

Related Question