Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Centralising Reporting Services Stylesheets


Centralising Reporting Services Stylesheets

Author
Message
Adam Aspin
Adam Aspin
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 1032
Comments posted to this topic are about the item Centralising Reporting Services Stylesheets
kenno_rules
kenno_rules
SSC-Enthusiastic
SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)SSC-Enthusiastic (122 reputation)

Group: General Forum Members
Points: 122 Visits: 173
Good work Adam. I spend a lot of my time authoring and maintaining Reporting Services reports, but my programming knowledge outside of SQL/T-SQL is VERY poor, and have therefore been quite slow to embrace the full set of features available.

This article (and the first one) was very easy to follow, and I will definitely be trying to influence my team to use these techniques as soon as we can. We have a LOT of reports that do have a consistent look and feel, but this is achieved through us just being vigilant and making sure things are as they are meant to be. Of course, we don't always get it right, and heaven forbid we should ever have to change styles.

Thanks for this. Hope you can show us more ways to use RS to the full.

Matt.



Fatherjack
Fatherjack
Old Hand
Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)Old Hand (302 reputation)

Group: General Forum Members
Points: 302 Visits: 627
Another thank you Adam.

I have always wanted something like this but have been unsure how to implement it (and more than a little concerned about busting something!). This is a brilliant start for me.

I would like to work towards having text content based on similar principles too. We run lots of business contracts here and groups of reports have to have standardised report disclaimers / security messages in the footer according to the contract we are provisioning. If I can control the text in a database row and then reference a function from a text box in the footer then I can be certain to have all reports content identical, and future updates (contract changes) will be much more easily propogated.

thanks again

Jonathan
christina.hughes
christina.hughes
SSC Veteran
SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)

Group: General Forum Members
Points: 224 Visits: 64
Hello Adam!

So far your article is easy to follow, however I have a question. Whenever I launch Visual Studio I do not have a Class Library Project as an option, only SSAS, SSIS, and SSRS for SQL Server. Can you point me in the right direction?
John.Sansom
John.Sansom
SSC-Addicted
SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)SSC-Addicted (497 reputation)

Group: General Forum Members
Points: 497 Visits: 1558
Hi Christina,

If I may answer on Adams behalf, it sounds as though you are attempting to open BIDS rather than a specific version of visual studio.

The Express version of Vidual Studio is available to download for free and will provide what you are looking for.

Cheers,


John Sansom (@sqlBrit) | www.johnsansom.com
wordracr
wordracr
SSC Journeyman
SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)SSC Journeyman (94 reputation)

Group: General Forum Members
Points: 94 Visits: 155
One thing to keep in mind about using the dll method is that you may run into performance problems, especially in matrix cell formatting, as the call seems to be running per outputted cell.. maybe it was something I was doing that caused the call that often, but just something to be aware of.
Adam Aspin
Adam Aspin
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 1032
Hi Christina,

Just make sure that you have selected :

Visual Basic
Windows

On the left, and you will be able to select a class project.

And thanks to John for the extra help - I was busy with a work crisis!

Regards,

Adam
Adam Aspin
Adam Aspin
SSC Veteran
SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)SSC Veteran (231 reputation)

Group: General Forum Members
Points: 231 Visits: 1032
Thanks for this hint, Ryan, I will keep an eye out for performance problems.

I have not noticed any so far - but the MDX & T-SQL on the reports I was using (before adding dll styles) was so slow that any preformance hit due to styling was lost in the general turgid nature of the output.

Oh for enlightened managers and proper investment in hardware... (rant finished).

Regards,

Adam
christina.hughes
christina.hughes
SSC Veteran
SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)SSC Veteran (224 reputation)

Group: General Forum Members
Points: 224 Visits: 64
Ok, I am on the right track. thanks to both Adam and John!
Irina Ostrovskaya
Irina Ostrovskaya
Right there with Babe
Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)Right there with Babe (799 reputation)

Group: General Forum Members
Points: 799 Visits: 112
I would like some help. I am trying to use the function what we created, I am getting the error:

[rsCompilerErrorInExpression] The BackgroundColor expression for the text box ‘textbox11’ contains an error: [BC30451] Name 'DynamicStyleLibrary' is not declared.
Build complete -- 1 errors, 0 warnings


PLease help. Thank you.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search