Creating a Dynamic Title with Multiple Values

[Former Member]

I currently have a title formula editor set up like this: =If(UserResponse("Enter value(s) for Appointment Type ID:") <> "") Then ("Appt. Type: "+[Appointment Type Detail Description]) Else ("")

This works fine if only one value is selected from the prompt.

But I also have the "Appointment Type ID" field in my query filter (prompt) as in list...so if a user were to select multiple Appointment Type IDs the title would read #MULTIVALUE.

How can I change my formula above to handle listing of the multiple IDs in my report title when a user selects multiple IDs from the prompt?

[Former Member]

I would like it to return this for example when multiple values are chosen from the prompt "Appt. Type: 21 - New Ob, 1 - Off Visit, 3 - Compl Phy, 5 - Pre Op"

The above example is if a user selects Appointment Type IDs: 21;1;3;5. The New Ob, Off Visit, Compl Phy, and Pre Op descriptions are held in the Appointment Type Detail Description field. These descriptions correspond with the Appointment Type IDs. I would like to be able to bring them together like in my example above by using both dimensions.