More on Crystal Reports SQL Expressions and WhilePrintingRecords

I decided to talk about more on Crystal Reports and about SQL expressions fields that can be tricky I have made some screenshoots that can help YOU. See below

Let's see Closer the intruction remenber on

Convert text to varchar

  • The formula bellow sums field1 group by field2
Whileprintingrecords;
sum ({table1.field1},{table1.field2})

  • Sums two fields in the bellow example
WhilePrintingRecords;
({file.Qty1} + {file.Qty2})

more on these useful  Link


Related Posts:



3 Responses to “More on Crystal Reports SQL Expressions and WhilePrintingRecords”

My + You said...

Great blog, I will come again, see my hope that you will find something interesting


-New program this week look great thanks

Shape Collage 2.1 -Photographic collages,
Excellent program for download, try.

http://luckyintoeracomputers.blogspot.com/2009/03/shape-collage-21-photographic-collages.html



-Cool USB gadget

USB FRIDGE ,USB STRIPPER ,USB HEATED GLOVES ,USB ASHTRAY

http://luckyintoeracomputers.blogspot.com/2009/03/cool-usb-gadgeta.html

Heated-Gloves said...

Thanks for sharing your journey with us. Its really interesting to read your page. Every morning after coming office first thing I do is read your blog. Welcome back. Take care. Have fun!!!

Jorge Cunha said...

Thanks for your kind comment.

All the Best

Post a Comment