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


Report Templates Using Stylesheets


Report Templates Using Stylesheets

Author
Message
Adam Aspin
Adam Aspin
SSC-Addicted
SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)

Group: General Forum Members
Points: 471 Visits: 1032
Comments posted to this topic are about the item Report Templates Using Stylesheets
noxidjkram
noxidjkram
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 82
Great article/series.

One small point - you state that you cannot use databased images in headers and footers... I'd like to point out that you can. Smile You need to store them in the report body first (for example within a hidden textbox, using the functions convertFromBase64 and convertToBase64) then reference them from the header/footer.

SQL Novice - Here to learn.
Adam Aspin
Adam Aspin
SSC-Addicted
SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)SSC-Addicted (471 reputation)

Group: General Forum Members
Points: 471 Visits: 1032
Good tip - thankk you!
BarryK
BarryK
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 78
A database call for every styled element?.... I like the idea of a stylesheet (come on Microsoft, CSS ??!) but maybe a DS that returns the all the styles for the report and use that instead?
Jeremy Baynham
Jeremy Baynham
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 109
Another great article, one point though, as far as I am aware, these self-built templates are only an option if you are using BIDS, not if you use the full Visual Studio. If anyone can prove me wrong here, I will be glad to hear of it! Smile
noxidjkram
noxidjkram
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 82
When it comes to templates it doesnt really matter too much anyway.

You can just copy and paste your 'template' into your newly created project file and add it from there using the 'right-click' on Reports and 'Add existing Item' method. Placing a template into BIDS as a 'click-on' item is just a nicety.

M

SQL Novice - Here to learn.
Jeremy Baynham
Jeremy Baynham
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 109
Hmm, I see what you're saying, but then there is no way of going through the wizard using the template, so you will need to add groups etc manually, not the end of the world, but not wildly convenient either...
noxidjkram
noxidjkram
SSC Rookie
SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)SSC Rookie (27 reputation)

Group: General Forum Members
Points: 27 Visits: 82
For me, the wizard was great to begin with when I didn't have a good handle on how to set properties etc manually, but after using BIDS for 18 months or so I find the wizard to be restrictive, and that it is quicker for me to do things manually. Perhaps it is a factor of personal preference as well.

SQL Novice - Here to learn.
Jeremy Baynham
Jeremy Baynham
Valued Member
Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)Valued Member (54 reputation)

Group: General Forum Members
Points: 54 Visits: 109
No, the wizard isn't great, but it is handy for setting up grouping, as it populates both the group expression and the sort, which I always forget otherwise... Probably 90% of my reports are variants of something that I have already written, so the copy and tweak method isn't so much of a departure from normal workflow. The inconsistencies between BIDS and VS do seem a bit silly though. I have to author some reports in BIDS on the server as I commonly use SSIS as a data source, would be nice to work on everything in the same way.
BarryK
BarryK
Grasshopper
Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)Grasshopper (22 reputation)

Group: General Forum Members
Points: 22 Visits: 78
An alternative way to style your reports...

http://sqldev.wordpress.com/2009/03/12/dynamic-report-styling/
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