SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Centralising Reporting Services Stylesheets


Centralising Reporting Services Stylesheets

Author
Message
mohd.nizamuddin
mohd.nizamuddin
SSC-Addicted
SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)SSC-Addicted (462 reputation)

Group: General Forum Members
Points: 462 Visits: 198
Googd Work.

Thanks a lot.

This is the way I was expecting making a DLL and get rid of COPY-PASTE code into each report code-window.

Your DLL with Table approach is awsome because there is no need to compile the DLL, if data value (color attribute) changes.
Excellent work.

Regards,
Nizam
Adam Aspin
Adam Aspin
Say Hey Kid
Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)

Group: General Forum Members
Points: 687 Visits: 1032
Thanks Nizam - and there's more next week in the final article in the series.

Adam
Adam Aspin
Adam Aspin
Say Hey Kid
Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)

Group: General Forum Members
Points: 687 Visits: 1032
Hi Irina,

I am not getting this - are you sure that yu are copying the code exactly as it is?

Regards,

Adam
Irina Ostrovskaya
Irina Ostrovskaya
SSC Eights!
SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)

Group: General Forum Members
Points: 841 Visits: 112
Hello, Adam.
Thank you very much for your response.
I followed instructions from article:Using a Custom Assembly, Using an SQL server table with Custom Assembly.I am getting the same error if I am trying to use any of them in my custom code. What can cause the error I am receiving? When I am building Class FixedStyleLibrary it should give me error if I didn't copy the code correctly. Right?
jpratt-797544
jpratt-797544
SSC-Enthusiastic
SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)SSC-Enthusiastic (125 reputation)

Group: General Forum Members
Points: 125 Visits: 79
For Irina: The error is coming from the report itself. It cannot find the DLL. Make sure you add the reference in your *report* project to the style DLL, and that the latter is in the correct location at run-time.

For Adam: DUDE! This rocks, especially the data-driven piece, which is exactly what I will implement. I've actually be waiting for the last week for this article to appear. The one thing I will try to add, and to address issues about performance, is caching of the result set from the DLL. I.e. Once the data is loaded from the database, it should be memory resident on the report server unless forced to reload. At the very least (in case in-memory caching is not doable), each report should have 2 functions: 1 calls a method inside the DLL that returns a dataset of all the style info and stores it in a variable in the report, and a second that searches the data set variable for the requested style for each property setting. I can't wait to get my fingers into this! Thanks for a great article.
Irina Ostrovskaya
Irina Ostrovskaya
SSC Eights!
SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)SSC Eights! (841 reputation)

Group: General Forum Members
Points: 841 Visits: 112
Thank you very much for your help. My problem was: the configuration for build project was in release mode instead of debug. My custom code works now. Thank you very much. Irina.
admin-499013
admin-499013
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 114
Unless I am missing something, this does not work in the header or footer of the report. Would love to be proved wrong but if so it does limit the applicability of this approach
admin-499013
admin-499013
Valued Member
Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)Valued Member (51 reputation)

Group: General Forum Members
Points: 51 Visits: 114
Sorry, Footer is O.K. - header no luck - same sort of restriction as for db images. Come on M$!
Susan Laing
Susan Laing
Valued Member
Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)Valued Member (74 reputation)

Group: General Forum Members
Points: 74 Visits: 188
Hi Adam

This is a fantastic article and just what I'm looking for to reduce the workload in creating many reports while ensuring a consistent look and feel. I've worked through the steps for the data driven option and can compile and preview in Visual Studio 2005, however when I try to deploy to the report server I get:

The Color expression for the textbox ‘textbox1’ contains an error: [BC30456] 'DataStyleLibrary' is not a member of 'DynamicStyleLibrary'. (rsCompilerErrorInExpression)

I have checked that the dll is referenced in report properties references tab, and as I said, this previews fine from VS so I believe the dll is fine. My knowledge of vb programming is limited so I'm now stuck for solutions. Can you help please?

Susan
Adam Aspin
Adam Aspin
Say Hey Kid
Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)Say Hey Kid (687 reputation)

Group: General Forum Members
Points: 687 Visits: 1032
Hi Susan,

This could mean that the Dll is not deployed correctly - you will have to make sure that you are copying it to the right directories!

Good luck,

Adam
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