<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
Article Discussions
»
Article Discussions by Author
»
Discuss content posted by Adam Aspin
»
Add Styles to Your Reporting Services Reports...
45 posts, Page 1 of 5
1
2
3
4
5
»
»»
Add Styles to Your Reporting Services Reports
Rate Topic
Display Mode
Topic Options
Author
Message
Adam Aspin
Adam Aspin
Posted Wednesday, February 25, 2009 11:46 PM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:42 AM
Points: 80,
Visits: 846
Comments posted to this topic are about the item
Add Styles to Your Reporting Services Reports
Post #664805
Boyan Penev
Boyan Penev
Posted Thursday, February 26, 2009 1:32 AM
Grasshopper
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
ggkids
ggkids
Posted Thursday, February 26, 2009 1:51 AM
Forum Newbie
Group: General Forum Members
Last Login: Friday, March 09, 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
Adam Aspin
Adam Aspin
Posted Thursday, February 26, 2009 2:16 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:42 AM
Points: 80,
Visits: 846
Indeed - and this is the subject of the next article in this series, which should be out next week!
Post #664854
Maurizio Urbano
Maurizio Urbano
Posted Thursday, February 26, 2009 4:07 AM
Forum 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
Adam Aspin
Adam Aspin
Posted Thursday, February 26, 2009 4:31 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:42 AM
Points: 80,
Visits: 846
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
Samuel Vella
Samuel Vella
Posted Thursday, February 26, 2009 5:11 AM
Old Hand
Group: General Forum Members
Last Login: Friday, May 03, 2013 2:54 AM
Points: 328,
Visits: 1,848
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
Adam Aspin
Adam Aspin
Posted Thursday, February 26, 2009 5:46 AM
SSC Journeyman
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 3:42 AM
Points: 80,
Visits: 846
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
David McKinney
David McKinney
Posted Thursday, February 26, 2009 7:05 AM
Mr or Mrs. 500
Group: General Forum Members
Last Login: Wednesday, May 15, 2013 12:43 AM
Points: 582,
Visits: 1,601
Nice article - nothing revolutionary, just good relevant practical advice on making life easier. Look forward to the next installments.
David McKinney.
Post #664979
Samuel Vella
Samuel Vella
Posted Thursday, February 26, 2009 7:08 AM
Old Hand
Group: General Forum Members
Last Login: Friday, May 03, 2013 2:54 AM
Points: 328,
Visits: 1,848
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 »
45 posts, Page 1 of 5
1
2
3
4
5
»
»»
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
