Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Formatting columns at once. Expand / Collapse
Author
Message
Posted Tuesday, August 13, 2013 5:38 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 74, Visits: 362
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
:)
Post #1483664
Posted Tuesday, August 13, 2013 5:52 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 13,368, Visits: 11,148
You can select multiple cells by holding ctrl or shift while selecting them.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1483670
Posted Tuesday, August 13, 2013 6:00 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 74, Visits: 362
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.
Post #1483676
Posted Tuesday, August 13, 2013 6:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 13,368, Visits: 11,148
I can. What version of SSRS are you using?
Can you change it using the properties?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1483679
Posted Tuesday, August 13, 2013 6:07 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 74, Visits: 362
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.

Post #1483680
Posted Tuesday, August 13, 2013 6:08 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 74, Visits: 362
I'm using ssrs 2012
Post #1483681
Posted Tuesday, August 13, 2013 6:55 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 13,368, Visits: 11,148
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?




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1483702
Posted Tuesday, August 13, 2013 7:34 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 74, Visits: 362
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.


Post #1483731
Posted Tuesday, August 13, 2013 1:23 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 1:52 PM
Points: 13,368, Visits: 11,148
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.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence


  Post Attachments 
multipleformatting.jpg (4 views, 71.09 KB)
Post #1483927
Posted Tuesday, August 13, 2013 3:00 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, October 24, 2014 6:14 AM
Points: 74, Visits: 362
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 .
Post #1483986
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse