Friday 30 November 2012

check box in SSRS

Senario:

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

for this Refer :
http://kkryczka.wordpress.com/2010/12/09/how-to-display-checkbox-on-report/

http://www.mindfiresolutions.com/Including-Checkbox-in-SQL-Server-Reporting-1163.php

http://blog.hoegaerden.be/2012/08/04/displaying-checkboxes-in-an-ssrs-report/

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: