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
sum ({table1.field1},{table1.field2})

  • Sums two fields in the bellow example
({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.

-Cool USB gadget


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