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: