Need help with select within select - daterange

25 Views

I use Crystal Reports v12.3.0.601 - I am a beginner.

Problem:

TABLE: ACCOUNTBILLFEE

Columns are

FOLDERRSN

STAMPDATE

BILLNUMBER

PAYMENTAMOUNT

There are over 500,000 rows/ records...

And I need to report the FOLDERRSN which has at least one {ACCOUNTBILLFEE.STAMPDATE} in DateTime
(2014, 05, 01, 00, 00, 01) to DateTime (2014, 05, 31, 23, 59, 59)

Out-put required is:

FOLDERSN | STAMPDATE | BILLNUMBER | PAYMENTAMOUNT

Group by FOLDERRSN

1010234 May01,2014 1111 25000

May25, 2014 1112 5000

Jan 05, 2013 998 500

1034567 May5, 2014 11325 5000

1033999 May15, 2014 6752 15000

Dec5 , 2011 1132 25000

Please help -

The critical part for me, is to display payments not within the date range in 'select expert' statement.

Currenlty my report reflects only payments for FOLDERRSN, where {ACCOUNTBILLFEE.STAMPDATE} in DateTime

(2014, 05, 01, 00, 00, 01) to DateTime (2014, 05, 31, 23, 59, 59) and not other payments outside the date range specified.

Thank you for your time.