Click here to Skip to main content
15,921,169 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
I have a report that I need to generate from Crystal Reports version 11.5. I need to show the records between January 1st 2015 through January 1st 2016 for all records that the sale price is under $50

I am very new to Crystal Reports, but know it good enough to know where to add the formula. I'm just not sure about the formula that I need to sue for this. Any help would be greatly appreciated.

Thank you!

What I have tried:

I have not tried anything yet, I've done some queries in the past, but I'm not that experienced.
Posted
Updated 22-Jun-17 4:36am

1 solution

1. For this You need to place the fields in the details section of the reports where required field value will be shown in the report.

2. Now Click on Detail section and right click and go to properties.

3. In the property window click on Suppress Checkbox Button and then click on the Formula button beside suppress check box and provide the formula within the formula window like

if ((date >='01-01-2001' and date <='31-01-2000') and amount<50) then 
  return false
else
  return true
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900