Monday, July 27, 2015

Crystal Reports : Converting Text and Numbers

When using the Format options in Crystal, it can only be as smart as the underlying field. That is, a number must be a "Number" and text must be "Text". If you aren't seeing the expected formatting options, you may need to convert the data type of the underlying database column.

There are many functions available in Crystal to make this happen, but for now we'll keep it simple.

1. To convert from Text to Numeric, simply use the ToNumber() function within a formula, like this;

ToNumber(Table.Column)

The resulting formula will "behave" like a number.

2. To convert from Numeric to Text, use the ToText() function;

ToText(Table.Column)

Try it. Every Crystal Reporter should be comfortable with type conversion; it's our bread and butter!

2 comments:

beliuy trey said...



running watches include every versions, designs. tag heuer replica sale provides fellas, adult females and even infants. Traditional sit back and watch includes add the hand mirror in up-to-date precious time and even meeting. Hand product chanel replica sale implement sit back and watch band commonly built from wash rag, aluminum, materials and nylon linked with our hand. Huge hand wrist band hublot replica uk are frequently portrayed simply because high-quality, rolex replica sale intended to agree with our diet and lifestyle. Designed for activated, travelling many people and designed for non-active varieties truth be told there is likely to end up you watch which will works ones own must have. A large wide range in recognized hand wrist band chanel replica sale you can find at present. Opting for a single would most likely interact with ones own conditions and even perform your preferences might be somewhat an incredible challenge.

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