I am creating a report to pull the Patient Name, Procedure Scheduled, etc of patients who have an appointment scheduled for certain procedures.
In the report we should be able to
1. Either all patients scheduled for today or
2. Select a particular date and select an individual patient scheduled for that date (the parameter should list only patients scheduled for that date)
I did this in two separate reports right now. But I would like to know if I can do this within a single report using only crystal reports.
I would like to have a parameter to select a date in such a way that when a date is selected, all patients who have appointments scheduled for that date populates in the patient name parameter. From there either one patient or all patients scheduled for that day has to be selected. I could pull the report for one patient. I added a cascading parameter but how can I get an 'all' option included to this dynamic parameter.
Or is there a way I can add the first parameter to select all patients scheduled for today (Yes/No) so that it's output will be yes or no. and if it is yes,create the report on all patients and if it is no it should bring another cascading parameter as explained in the above paragraph. (or any other way to achieve this functionality).
Thankyou for any help in advance.
BAJ