I have a set of 4 parameters . ?StartDate, ?EndDate, ?Medical Record Number, ?Accession Number. I want to be able to be able to enter in any parameter and the others left blank or maybe two parameters are entered or whatever the input maybe. It does work if i enter all parameters. I am novice at crystal reports and any help would be fantastic. Here is the code i have:
(not HasValue({?Medical Record Number}) OR {PAUDIT.MR_NUM} = {?Medical Record Number}) and {PAUDIT.DATE} in {?Start Date(yyyyMMdd)} to {?End Date(yyyyMMdd)} and (not HasValue({?Accession Number}) OR {PAUDIT.ACC_NUM} = {?Accession Number})
IP Logged
