Grouping by specific date range

[richardm]

I'm trying to group by year, my formula reads

If {date.field} > Date (1998,01,01)
and {date.field} < Date (1998,12,31)
then {date.field}

The report returns everything in the range, however when adding other fields like {customer.name} and {invoice.amount} it suppresses, does not print {date.field} but includes values for {customer.name} and {invoice.amount}

Please tell me the correct way to set the date range so that nothing other than what falls in the date range prints and is included in the report.

Thanx in advance for your help

 

[kenhamady]

Put the following formula in the Record Selection Formula
(Report - Edit Selection Formula - Record):

{date.field} in Date (1998,01,01) to Date (1998,12,31)

If that doesn't help, then your table links are probably incorrect.
Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

http://www.kenhamady.com/

 

[richardm]

Thank you for your help, that worked.