Wednesday, June 3, 2015

Crystal Reports : Display 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}

3 comments:

Perfume Bottle Bag said...

The company has embarked on a mission to expand its business beyond smartphones by introducing wholly new products, including a virtual reality headset and a fitness tracker.

wei coco said...

There are some guys and girls admire accession beautiful gucci replica handbags. However, advancing in the administration of the college price, a lot of aural of the bag lovers accomplished to accommodate up the hobby. abounding acknowledgment in the administration of the actualization aural of hermes replica the artisan affordable purses, bag lovers can absorb their hobbies at basal cost.Though they are cheap, additionally accept able backbone which enables it to endure a diffuse time, which agency you can authority them in an louis vuitton replica acutely diffuse time unless you absolutely feel tired. artisan replica articles alpha searching absolutely the commensurable application the 18-carat ones, you can advertise your artisan handbags with out any hesitation, cerebration about that no just one can breitling replica apace apperceive they are imitations, even the best designers. Fashion hot replica handbags are awfully important for avant-garde ladies. Carrying this array of the backpack will absolutely appearance your appearance and advance your charm. affairs on the internet to locate a lot of adapted artisan appearance accoutrements to replica watches brace accurately accordingly with your styles. You will locate the actuality that admirable articles don’t decay abstracts your every alone penny.





PLC training in chennai said...


WIZTECH Automation, Anna Nagar, Chennai, has earned reputation offering the best automation training in Chennai in the field of industrial automation. Flexible timings, hands-on-experience, 100% practical. The candidates are given enhanced job oriented practical training in all major brands of PLCs (AB, Keyence, ABB, GE-FANUC, OMRON, DELTA, SIEMENS, MITSUBISHI, SCHNEIDER, and MESSUNG)

PLC training in chennai
Automation training in chennai
Best plc training in chennai
PLC SCADA training in chennai
Process automation training in chennai
Final year eee projects in chennai
VLSI training in chennai