Member Avatar for Victoryy
Victoryy 11 Newbie Poster

Hi All,
I have a crystal report with DrAmt, CrAmt, DrBankAmt, CrBankAmt fields.
While displaying the report i want to display.. the records whose following condition satisfied...

((sum(DrAmt)+sum(CrAmt)) - (sum(DrBankAmt)+sum(CrBankAmt))) <> 0

how can i check for this condition in selection formula....

I have used following line of code... but its not working showing error
"Functions can not be used in selection formula"

CrptReport.SelectionFormula = "(Sum ({accounts.DrAmt})+ Sum ({accounts.CrAmt}))-(Sum ({accounts.DrBankAmt})+Sum ({accounts.CrBankAmt}))<> 0 ";

Thanks in advance,
Regards,
Victoryy

Edited by Victoryy because: n/a
  • 1 Contributor
  • 0 Replies
  • 64 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.