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 12345»»»

Add Styles to Your Reporting Services Reports Expand / Collapse
Author
Message
Posted Wednesday, February 25, 2009 11:46 PM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:03 AM
Points: 81, Visits: 903
Comments posted to this topic are about the item Add Styles to Your Reporting Services Reports
Post #664805
Posted Thursday, February 26, 2009 1:32 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, May 30, 2012 7:15 PM
Points: 22, Visits: 121
There is another way to apply "styles" to a report - by storing the report attributes, such as colour, in a database table and then retrieving them in a data set - either together with the data or just as a separate data set. Then you can either use them directly as Fields collection items or by creating parameters, which can be used in any report element regardless of the data set assigned to it. This overcomes some of the limitations that are listed in the article.

Boyan Penev
Post #664837
Posted Thursday, February 26, 2009 1:51 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, March 9, 2012 1:44 AM
Points: 1, Visits: 8
I've never tried this but woulndt it be possible to have Custom Code refering to a external stylesheet that coult be used by multiple reports?
Post #664844
Posted Thursday, February 26, 2009 2:16 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:03 AM
Points: 81, Visits: 903
Indeed - and this is the subject of the next article in this series, which should be out next week!
Post #664854
Posted Thursday, February 26, 2009 4:07 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, March 12, 2009 10:38 AM
Points: 4, Visits: 14
I have added all the custom code functions onto an external class and simply reference the class on all my reports and use whatever function I need, if changes are required I simply change and recomplie the function...

Quite useful for standard stuff such as Date format, company colours and so on....

Post #664897
Posted Thursday, February 26, 2009 4:31 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:03 AM
Points: 81, Visits: 903
Absolutely - this makes centralising styles really easy - and is handled in the third article in the series (where you will see how to add these classes to templates too)!
Post #664909
Posted Thursday, February 26, 2009 5:11 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 6:18 AM
Points: 337, Visits: 1,995
Boyan Penev (2/26/2009)
There is another way to apply "styles" to a report - by storing the report attributes, such as colour, in a database table and then retrieving them in a data set - either together with the data or just as a separate data set. Then you can either use them directly as Fields collection items or by creating parameters, which can be used in any report element regardless of the data set assigned to it. This overcomes some of the limitations that are listed in the article.


I was just about to post with the very same thing!
Storing as much of the style properties in a database as possible... then styles can be updated without having to republish any reports
Post #664919
Posted Thursday, February 26, 2009 5:46 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: 2 days ago @ 7:03 AM
Points: 81, Visits: 903
Thanks to both of you for this one - this is a very good idea that I have not covered it in this way in the following articles so would one of you like to post this as an addition to this "mini-series" to extend the tips and techniques offered?
Post #664940
Posted Thursday, February 26, 2009 7:05 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Wednesday, September 17, 2014 4:02 AM
Points: 648, Visits: 1,874
Nice article - nothing revolutionary, just good relevant practical advice on making life easier. Look forward to the next installments.

David McKinney.
Post #664979
Posted Thursday, February 26, 2009 7:08 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: 2 days ago @ 6:18 AM
Points: 337, Visits: 1,995
Adam Aspin (2/26/2009)
Thanks to both of you for this one - this is a very good idea that I have not covered it in this way in the following articles so would one of you like to post this as an addition to this "mini-series" to extend the tips and techniques offered?


I've not put it into action yet.

Coincidently It was yesterday when I was looking at methods of maintaining consistant colouring when using graphs. I ended up creating some tables and associating colours with categories so when several graphs/charts are on the same report the same category e.g. "bikes" will always be shown using the same colour e.g. "red". Then one legend can be used for several charts.

The concept should be farly easy to extend to other report properties.
Image locations for branding
fonts, font colors, weights etc... for consistant titleing
colour schemes

The final adaptation ties in with using dynamic colours for graphs i.e. using hex values rather than the names for the colours.
Doing it this way gives an option for starting with a base colour - defined as a hex value, then adding or subtracting to the RGB components to give a spread of colours from the base colour

PS. If you're benched at the moment then you've probably got a lot more time than me to work on an article ;)
Post #664984
« Prev Topic | Next Topic »

Add to briefcase 12345»»»

Permissions Expand / Collapse