Dynamic Chart Titles based on prompt value
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.