Passing Date Range to Crystal Reports

[ts2be]

How do you pass a date range to Crystal reports to filter the period of data to report? We have a Visual Basic Program that needs to run a Crystal report based on the input date range provided by the user of the program.<br>
<br>
Thanks

 

[databarn]

ts2be,<br>
<br>
You can use the Formula() collection of Crystal to supply such data. Have the user supply DateStart and DateEnd via a couple of text boxes, calendar controls, etc., then pass the values to @DateStart and @DateEnd as <br>
Formula(0)=start-date-from-text-box<br>
Formula(1)-end-date-from-text-box.<br>
<br>
I used the Fomula() syntax in a VB3 app with Crystal3 to populate up to five variables, and that app has been running for several years now, providing input criteria to a couple dozen reports or so.<br>
<br>
If you need, I can supply some specific code, I think.<br>
<br>
Make a good day . . .<br>
. . . barn<br>
<br>