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]

Tyler - You can do this.

Bo by default brings up semi colon between various the prompt values.

But you can use "Replace" function to actually replace that semi colon with commas.

here is the syntax.

=Replace(UserResponse("Enter value(s) for State:");";";", ")

I have replaced semi colon with comma and a space.

Hope this helps.