report range..

[jobb01]

Hi guys,
Can anyone please help me how to filter a report by date range with OR statement? Coz everytime I use the OR statement the date range filter was affected. The generated report was no longer the date range I wanted since I encoded already the range. I'm using clarion5. Thanks a lot..

thanks,
jobb01

 

[ShankarJ]

If you are setting the Filter directly and the FromDate & the ToDate can be ZERO, then the filter statement should be
FILate => FromDate AND (ToDate = 0 or FILate <= ToDate).

If you are using the range prompts in the template and setting the FromDate & ToDate fields as the Low & High ranges then it is better you check whether ToDate is ZERO after you accept ToDate i.e.

IF ToDate = 0 THEN CLEAR(ToDate,1).

This sets the ToDate to High Values so that all dates are retrieved.

P.S. Make sure that FromDate & ToDate are BINDed i.e. set up as hot fields or explicitly with the BIND() statement

 

[jobb01]

Thanks a lot shankaj, i'll let you know for the outcome..thanks again..

jobb01