Formatting columns at once.

Question

Formatting columns at once.

Bulelani M

Ten Centuries

Points: 1102
More actions
August 13, 2013 at 5:38 am

#281845

Hello Sql Gurus
Is there a way in ssrs to format column headers
basically changing font color, size , type , border-color and so on at once?
I've been trying to find a solution but nothing.
Regards
🙂

Viewing 10 posts - 1 through 9 (of 9 total)

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

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 1

You can select multiple cells by holding ctrl or shift while selecting them.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Bulelani M Ten Centuries Points: 1102 More actions · Answer 2

Hello

But with that you can not change the font at all, all you can do is to change the background color not the font size and type.

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 3

I can. What version of SSRS are you using?

Can you change it using the properties?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Bulelani M Ten Centuries Points: 1102 More actions · Answer 4

One work around would be creating a template that I'll use to create new reports but the problem I have, I'm formatting existing reports so going to one field at a time takes so much time and there is a lot of reports to change.

Please help if there is any solution to this.

🙁

Bulelani M Ten Centuries Points: 1102 More actions · Answer 5

Bulelani M

Ten Centuries

Points: 1102

August 13, 2013 at 6:08 am

#1640888

I'm using ssrs 2012

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 6

Bulelani M (8/13/2013)
I'm using ssrs 2012

It works in SSRS 2008R2, so I would be suprised if they killed that "feature".

Did you try using the properties?

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Bulelani M Ten Centuries Points: 1102 More actions · Answer 7

yes they killed the feature

now our lives are very difficult..

we are trying to find a very standard thing that can be used by anyone working on the reports on different machines.

I really need something that works.

one can use some custom code and use a background property to call that code but it would be great if it can be just a standard thing every time I update or create a report.

🙁 🙁 🙁

Koen Verbeeck SSC Guru Points: 259085 More actions · Answer 8

I checked on my laptop at home which has SQL Server 2012 SSRS.

I can still select multiple cells at once and change the formatting.

Screenshot in attachment.

Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP

Bulelani M Ten Centuries Points: 1102 More actions · Answer 9

Thanks Koen

This property is disabled on my side I'll have to check tomorrow the reasons why. also I'm connecting to the server to do the development.

thanks again for you help .