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,

The report title can be dynamically changed according to the parameters send ate report level. Just copy the below code at title function,

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

Even if you want to edit the format of the ;, u can replace it with '-' , ',' ... using below,

="Report for the States "+ Replace( UserResponse("Enter value(s) for State:");";";", ")

This can be helpful for you. Please let me know if you need more information.

Regards,

Chitha.