Select Expert - Record
I'm trying to limit the values presented in the Select Expert - Record tab based upon it's relationship to a selected value from another field.
We have several hospitals. Each hospital has several floors or unit/wards usually identified as 6 East, 2 West, 4 North, etc. Not all of the hospitals have the same named unit/wards.
I select use select expert - table_name.Facility_Name = "Hospital A" when I select table_name.Unit_Name I only want those units/wards from the "Hospital_A" to be displayed in the list and not all of the units/wards that are listed in the table. This way I do not have to wade through all of the unit/wards that a facility does not have. The report is for unit/ward.
If you are using Crystal XI or newer version then try creating a cascading prompt to get filtered with parent level field value.
For more information check the sample report prompting.rpt that shows the cascading prompt of Country