SSRS report

Question

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

David Burrows SSC Guru Points: 65142 More actions · Answer 1

You could add two images to the report (one a ticked box the other unticked) and use IIF in an expression to decide which image to show.

Are you using 2008 or 2008R2?

Far away is close at hand in the images of elsewhere.
Anon.

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 2

I am using 2008 R2 version.

Please add some more information on solution so that I can proceed further.

David Burrows SSC Guru Points: 65142 More actions · Answer 3

In 2008R2 the Indicator was added to the toolbox

Add this to your report

Select symbols with the tick for the Indicator type

Set the value to NULL for no display, 0 for X, 1 for ! and 2 for tick

The value can be either a field in the dataset or an expression

You will need to navigate around to find all the properties but you can set size, color etc.

Far away is close at hand in the images of elsewhere.
Anon.

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 4

Thanks for your reply.

Any web articles where I can get more detailed help having snapshots?

Umer Akram SSC-Insane Points: 22209 More actions · Answer 5

try this one

higgim SSCarpal Tunnel Points: 4090 More actions · Answer 6

You could also use the Wingdings font

=iif(somefield = somevalue,þ,¨)

[font="Wingdings"]þ[/font]

[font="Wingdings"]¨[/font]

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 7

I used the Windings font for the two text boxes in the report and used the following expressions for my requirement:

=iif(count(Fields!Results.Value)=0 OR Fields!FindingsDeleted.Value = 1,chr(0120),"o")

AND

=iif(count(Fields!Results.Value)>=1 AND Fields!FindingsDeleted.Value = 0,chr(0120),"o")