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]

My formula didn't copy over correctly, it is:

=If(UserResponse("Enter value(s) for Appointment Type ID:") <> "") Then ("Appt. Type: "[Appointment Type ID]" - "+[Appointment Type Detail Description]) Else ("")

Which for example could return "Appt. Type: 21 - New Ob"

21 being the value for the Appointment Type ID field and 'New Ob' being the value for the Appointment Type Detail Description field.

The issue is with how this formula is arranged if I choose multiple Appointment Type IDs from the prompt I get the #MULTIVALUE result.

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"

[Former Member]

Sorry. This is right. Troubles with plain text.

=If(UserResponse("Enter value(s) for Appointment Type ID:") != "") Then ("Appt. Type: "+[Appointment Type ID]+" - "+[Appointment Type Detail Description]) Else ("")

[Former Member]

Can you tell me how do you want the title to display when there are multiple Appointment Types.

It is not a table & I don't think you can display it in single cell.

[Former Member]

I would rather create a concatenated filed in Universe for your Account Type ID and Description. Then prompt on that, and then use it in header.

The way you are doing, you could just display multiple ID's in the header, but it might not be possible to display corresponding descriptions.

Thanks.

[Former Member]

So I created a concatenated field at the universe level and am able to get the information I need in my title.

Now, how can I format the result in order to have spaces between each value?

Like this, using your state example above: Report for States - CA; CO; MO; NV; OK; TX