user3812887
user3812887

Reputation: 457

SSRS Chart Title - change font size for a part of the title

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

Answers (1)

Strawberryshrub
Strawberryshrub

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

Related Questions