Thursday 19 June 2014

How to implement True Or False Image in Reports

 Suppose we have a form that should appear automatically filled out based on information pulled from a database. We have several datatype fields. Printing out “True” or “False” , “Yes” or “No” on the required field as per the information wuldn't look nice, as this is supposed to look like a form that has been auto-filled out, so we want to have a checkbox or a series of checkboxes that are either checked or unchecked.  We can add checkbox control through following ways1.by Images2.by Textboxes
Through Images:
1.First to create 2 Images of checkbox.Then add embedded Images to the report(named as “Checked” and “Unchecked”).
2.Insert an Image object and display 1 of the 2 images as per the field value or as per your conditional expression like as follows
IIF(First(Fields!Field.Value,”DataSetName”)=true,”Checked”,”Unchecked”)
                    or
IIF(Conditional_Expression=true,”Checked”,”Unchecked”)

Through Texboxes:
1.Create a Texbox that must look like checkbox.
2.Change font to Webdings.
3.Display value  “tick” or “cross” mark as per the field value or conditional expression like as follows

IIF(First(Fields!Field.Value,”DataSetName”)=true,”a”,”r”)
                    or
IIF(Conditional_Expression=true,”a”,”r”)

No comments:

Post a Comment