Tuesday, March 29, 2016

Crystal Reports : Providing a Checkbox

Let us assume we want to display a checkbox on a report. In our example, we are looking to visually identify if a Crystal Formula is returning TRUE or FALSE.

The way this works is by selecting the "wing-dings" font for a formula and then programmatically changing what character is displayed.

1. Right-click on your formula and select "Format Field"
2. Click on the Font tab
3. Select "Wing-Dings" from the Font dropdown list
4. Click on the Common tab
5. Click on the "X-2" button to the right of "Display String"
6. Paste in the following formula, substituting your {@FUNCTION}

IF {@FUNCTION} = TRUE THEN CHR(254) ELSE CHR(111)

This will automatically produce an unchecked box or a checked box, depending on the value of {@FORMULA}

2 comments:

Anonymous said...

The actual strong caseback is really a encouraged replica watches sale about the Rolex, also it has the nautical replica watches sale within relationship using the general replica watches sale. Exactly why is a good caseback the encouraged cheap replica watches? Right now, do not misunderstand me, show home panerai replica sale tend to be excellent. I simply do not really should begin to see the rolex replica uk 8245 that is within.

chenlina said...

coach handbags
ralph lauren uk
ralph lauren polo
ralph lauren
cheap ray ban sunglasses
nike air max
mont blanc mountain pen
gucci uk
pandora charms
chanel outlet
chenlina20170228