Reputation: 457
I have a situation in which I have developed a visual chart in SSRS 2012. The chart title is fixed -
Schools Performance in MyCity (County, State, Country)
(Remember, the above title is NOT dynamic, so the situation is easy to handle.)
(1) I need to keep the first part :
Schools Performance in MyCity (left 30 characters) at a font size of 12, Bold
(2) I need to keep the second part starting from the bracket "(" and ending in the other bracket ")" :
(County, State, Country) (all characters after the left 30 characters) at a font size of 8, non-Bold and italic.
I am not able to use multiple title boxes due to space constraint in the chart
I need to get the equivalent of some T-SQL string functions such as CHARINDEX, PATINDEX, etc. in SSRS. I am not too familiar with string functions inside SSRS.
Can anyone provide me a solution on how to achieve my goal?
Any suggestion will be greatly appreciated.
Upvotes: 1
Views: 947
Reputation: 3389
I think the best way here is you delete your chart title and add a textbox above your chart. In this textbox you can write your text with the desired formating (Home Tab > Font). If SSRS rearanges the position of the textbox and the chart, put the chart and the textbox in a rectangle, so they stay where you place them. As far as I know rich text or formating in the title is not possible.
Upvotes: 1