Link to home
Start Free TrialLog in
Avatar of dragon_au
dragon_auFlag for Australia

asked on

crystal reports date parameter - how do I get a report to ask for a date range, then select records based on that date range

Crystal Reports version 12
How do I get the report to promp for a FROM DATE and TO DATE at run time, then select transaction records that fall between these dates?
Avatar of habibb
habibb
Flag of Pakistan image

if you have created 2 parameters i.e. fromdate and todate then crystal report will ask you to provide values for fromdate and todate parameters but my recomendation is you should get values by having your own parameter input page. if you have succeded to get parameter values from user  then by using record selection formula editor you can write as

{yourtable.datefield} in {?fromdate} to {?Todate}

it wil only print those records which will fall in user provided date range.
Avatar of dragon_au

ASKER

How do I  "get values by having your own parameter input page"?
ASKER CERTIFIED SOLUTION
Avatar of analliah
analliah
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Thank you so much for your detailed response. I'm just a beginner at this, and now I understand how to apply this. Thanks !!!!