Crystal Reports In Crystal Reports a Boolean Field type is simply represented by the words True or False when you include such a field in your report. Right-click the field. Choose Format Field . Choose the tab Boolean . Nice, but not as nice as when you would change the True and False into checked or unchecked check boxes. Right-click the field. Choose Format Field . Choose the tab Font . Pick the font Wingdings . Choose the tab Common . Click the X+2 after Display string . Fill in the Formula: if {Products.Discontinued}= true then chr(254) //checked checkbox else chr(111) //unchecked checkbox Click OK . Then we will get: Report Builder / Reporting Services Report Builder will normally also represent a Boolean Field type as either True or False . In order to change it here, add a column to the tablix. Right click it. Choose Expression . ...
Blog over software als Access, Excel, SQL, Crystal Reports, Report Builder, Word, VBA, elfstedentochten en andere regionale zaken.