Friday, 30 November 2012

check box in SSRS


based on the two optional set or optional set values we need to show
check boxes in the SSRS.

for this Refer :

First create a  report.
in that select the two optional set

Ex : Stock Available or Stock Not Available.

change the Font to "wingdings".
then go to the expression:

=iif(First(Fields!new_stockavilability.Value, "DataSet1")= false,chr(0254),chr(0168))

if it is the Optional set:

=iif(First(Fields!new_regionof.Value, "DataSet1")=100000002,chr(0254),chr(0168))

then you will get the check boxes in report.

1 comment: