Dynamic Chart Titles based on prompt value

[Former Member]

Hi Experts,

I have BOXI R2 SP3 FIx Pack 3.5 Setup.

I have a couple requirement both related to chart title.

1. I have a Report that contains chart and i want to display the the value selected by user in the prompt in the chart title.

Ex: user selects "US" then Chart title should display "US" when suer Select "UK" title should change to "UK" , i know this can be done using the blank cell but i don't want that way is there any property or any other way to achieve this?

2. I want to display the section name in the chart title. I have many sections in my report , left side i have Table data and on right hand side I have a chart, on top of table data i can see section name but I want to display section name in the chart title?

In both cases i don't want to use blank cell.

Any workaround other than blank cell is much appreciated.

Regards,

Pratik

[Former Member]

Hi Pratik,

Yo have the formula UserResponse, you can create a variable and then use it in Secctions or columns is like a commun dimension.

Syntax: string UserResponse(object data_provider; string prompt_text; Index), Ex: =UserResponse("Enter City:")

I hope this help you.

Best regards,

Fede