How do you change the Text Legend to BOLD just for the total in the SRSS report?

Question

Post reply

How do you change the Text Legend to BOLD just for the total in the SRSS report?

rkelly58

SSCrazy

Points: 2151
More actions
November 12, 2018 at 8:17 am

#376371

In my Series Group, I have the Label with the following expression:
=(Fields!School.Value) & (COUNT(Fields!School.Value, "Chart3_SeriesGroup"))
want to make the COUNT part appear in BOLD, any ideas how I can do this?
have tried using format (count...…., "BOLD") and all sorts like "<b>" but nothing works?
it is for the legend, I want to display the text (school) as regular font, then the Count in BOLD
any way to do this?
Thanks

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

rodjkidd SSCoach Points: 15915 More actions · Answer 1

Hi,

I've had the same issue and used the following method to get the formatting I needed;

HTML Formatting SSRS

rkelly58 SSCrazy Points: 2151 More actions · Answer 2

rodjkidd - Monday, November 12, 2018 8:29 AM
Hi,
I've had the same issue and used the following method to get the formatting I needed;
HTML Formatting SSRS

Already had a look at that before posting.

i am formatting a LEGEND, not a textbox, so there are no placeholder properties.

The legend displays: School A 34, School B 22 for example
I need the display to be School A 34, School B 22

rodjkidd SSCoach Points: 15915 More actions · Answer 3

Ah, I hadn't realised the legend was different to any other text box, in that respect.
None of the reports here have any legends on them, otherwise I'd have a play with one to see what I can do.

Rodders...

rkelly58 SSCrazy Points: 2151 More actions · Answer 4

Anyone else got any ideas on this?

Surely i ain''t the only one?

meichmann SSCommitted Points: 1900 More actions · Answer 5

rkelly58 - Monday, November 12, 2018 8:17 AM
In my Series Group, I have the Label with the following expression:
=(Fields!School.Value) & (COUNT(Fields!School.Value, "Chart3_SeriesGroup"))
want to make the COUNT part appear in BOLD, any ideas how I can do this?
have tried using format (count...â€¦., "BOLD") and all sorts like "<b>" but nothing works?
it is for the legend, I want to display the text (school) as regular font, then the Count in BOLD
any way to do this?
Thanks

What you could do is spilt your expression into a table with two columns
The first column could have the value =(Fields!School.Value) and the second column could have the value =(COUNT(Fields!School.Value, "Chart3_SeriesGroup")). Then, all you would have to do is set the font weight of the second column to heavy.

Conficker SSCommitted Points: 1567 More actions · Answer 6

One work around I can think is FontWeight properties of legeng and can do expression.
eg.

=IIF(Right(Fields!Graph_Year.Value,2)=18,"Bold","Normal")

You can change Right function according to your formula, I have used current year for testing. May be take last three digits and check it they are number or do they exists eg. IsNothg () !!!!

hope this makes sense.

Conficker SSCommitted Points: 1567 More actions · Answer 7

rkelly58 - Tuesday, November 13, 2018 2:44 AM
Anyone else got any ideas on this?
Surely i ain''t the only one?

One work around I can think is FontWeight properties of legeng and can do expression.
eg.

=IIF(Right(Fields!Graph_Year.Value,2)=18,"Bold","Normal")

You can change Right function according to your formula, I have used current year for testing. May be take last three digits and check it they are number or do they exists eg. IsNothg () !!!!

hope this makes sense.