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]

Hi,

In your syntax above, what is "Appointment Type Detail Description"

As far as displaying header from the prompt answers(even with selection of multiple values with prompt) should be no problem. But I see the problem is with "Appointment Type Detail Description". Is this another Attrbute, try taking it out.

Here is a sample syntax that works.

="Report for States - " + UserResponse("Enter value(s) for State Name:")

Here is the output how it displays:

Report for States - CA;CO;MO;NV;OK;TX

Thanks