Hi,

I created two date parameters on my report:

StartDate
EndDate

I have another parameter for choosing file status (Open, Closed, All).

Based on the file status that users select, the date field pulls either Open files or Closed files within the selected date range. Is it possible for the report to pull both Open and Closed files when the file status is 'ALL'.

Can someone please help me with this. Thanks so much!

This is what I have on my report now. Current logic just pulls Open files when file status is 'ALL'.


(
({FileStatus} = 'Open' and {FileHdr.DateOpen} >={?__StartDt} and {FileHdr.DateOpen} <={?__EndDt})
or
({FileStatus} = 'Closed' and {FileHdr.DateClose} >={?__StartDt} and {FileHdr.DateClose} <={?__EndDt})
or
({FileStatus} = 'All' and ({FileHdr.DateOpen} >={?__StartDt} and {FileHdr.DateOpen} <={?__EndDt}) )

That worked. Thanks for your help DBlank