Monday, February 13, 2012

Add a checkbox report item

Hi there,

I am using SQL Server 2005 Reporting Services. Right now, I have a textbox with 0 or 1 values in my report and I want to show a checkbox: checked for value 1 and uncheck for 0. Is there anyway to add a checkbox in the report?

Thanks in advance.

semaj

A bit of a hack, but I think the only way to do this is to create 2 images of a checkbox (checked and unchecked), place that on your report and set the source to be an expression based on your field value.

=Iif(Fileds!check.Value = 0, "unchecked.gif", "checked.gif")

No comments:

Post a Comment