Wednesday, September 30, 2015

Crystal Reports : NULL vs Zero

Depending on your usage, the returning of NULL (from a formula or running total) can be more stubborn at times.

First, check what NULL conversion options the report is using:

1. Select from the top level menu File | Report Options.
2. Look for the "Convert NULL field value to default" checkbox.

If this box is checked, NULL is returned as a special "automagical" DEFAULT value.
This typically will convert NULL to zero in formulas and running totals.

Folks who are using newer versions of Crystal will notice an additional checkbox in Report Options called "Convert Other NULL Values to Default".

This checkbox refers to the NULLs being returned by objects other than database rows (i.e. formulas and running totals). Typically a combination of both of these checkboxes is required to properly fix a zero totaling problem. (Depending on back-end database and usage)

As always, try it out.

3 comments:

Viora care said...

Generally putting a wonderful accessorizing hint, Christina had this chanel replica sale Case. The woman performance would be the healthy canvas in addition to what exactly appears to be for being black suede toned. This Fendi M Carriers is usually almost nothing fresh to this world. In truth, that case seemed to be an enormous attack as soon as the item turned up, and from now on is usually produced with many colorings, sizing's, chanel replica sale products. Perfect for people that find it irresistible, this case typically obtains discounted down the line from the year should the combo hasn't been some sort of striking attack. Italian language pattern household Fendi into your world-famous to its lavish chanel replica sale excellent in addition to manufactured everywhere by means of Trendsetters incorporates a name. Fendi custom made clutches custom made commonly a compact although chanel replica sale with overall appeal. The outfits gadgets along with custom made models commonly some sort of herd to discover in addition to lead to entry "logo to one another, inch P oker element.

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

Zheng junxai5 said...

zhengjx20160623
adidas factory outlet
adidas outlet store
rolex watches
hollister clothing
cheap jordans
hollister jeans
toms shoes
michael kors outlet online
coach factory outlet
beats by dr dre
nike roshe run
true religion outlet online
air jordan shoes
jordan 3s
montblanc pen
ralph lauren
cheap oakleys
ed hardy outlet
louis vuitton outlet online
copy watches
jordan retro 4
longchamp outlet
louis vuitton purses
adidas yeezy
coach factory outlet
louis vuitton outlet stores
louis vuitton outlet
louis vuitton outlet
tory burch outlet
giuseppe zanotti outlet
louis vuitton purses
oakley outlet
burberry outlet online
cheap ray ban sunglasses
coach outlet
louis vuitton
cheap ray ban sunglasses
louis vuitton
michael kors outlet clearance
nike outlet