Select Expert - Record

[Former Member]

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.

Thanks

Michael

[Former Member · Accepted solution]

Hi Michael,

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>Region>city

Regards,

Raghavendra

[Former Member]

Thanks...That's exactlly what I was looking for.

Michael