Date ranges for a Newbe 1

[sclark415]

Hi, I am new to Crystal Reports. I need to create reports with a claim date range between 10/15/2002 and 12/31/2002. If the claim date is between this range, then I am to print the record. I am using V9. I'm not sure what other info you need. We run on SQL Server. Please help!
Thanks in advance!

 

[Katy44]

You need to choose the Select Expert (the hand with the blue balls underneath) or from the Report menu, and then select your date field. You then use the box to select "is between" and then type in your two dates - you may need to look at the format of the dates though.

Hope this helps

 

[sclark415]

Katy44 - Thank you so much. There is SO much that I don't know about Crystal. This helps alot!

 

[Katy44]

No problem! Good luck with it all.

 

[Jacque]

Hi sclark415,
If this is a report you'll use over and over again, instead of the select expert, you might want to try creating start and end parameters so that whenever you want to run the report, you just need to enter the start and stop date.

You would use the parameters to select the dates in the main report record selection formula:

{table.date} in {?start} to {?end}

Jacque

 

[emoongq]

What if instead of using 2 parameters ({?start} and {?end}) I just use one parameter with a range of dates, I already know how to do that but I'm not able to show the selected parameters in the header report. I'm using crystal reports 7

Tks

Eddie

 

[Jacque]

One parameter using a range of dates works too. You can place the {?Date Range} on your report using something like:

"Report Date Range between "+ totext(minimum({?Date Range}),"M/d/yyyy") + " and "+ totext(maximum({?Date Range}),"M/d/yyyy")

Jacque