Designing Customized Company Reports

Question

Designing Customized Company Reports

Rofty

SSCrazy

Points: 2585
More actions
August 17, 2009 at 6:23 am

#209602

I have to design reports that need to abide by the designing standards of the company.
Logo and Company Details in Page Header
Date/Time and Page Number in Page Footer
Company Colors as Color Scheme for Grouping Tables
How can one create new reports and use a design template automatically creates the report with the above mentions settings.
I have tried the editing the CSS already ... but doesn't support using images
[font="Courier New"]-----------------------------------------------------------------------------------------------------------------------
😀 Arguing with Programmers are like wrestling a pig in mud, soon you realize the pig is enjoying it. 😀
-----------------------------------------------------------------------------------------------------------------------[/font]

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Gift Peddie SSC Guru Points: 73570 More actions · Answer 1

Hi,

This is not very complicated however I am not sure you can create a template because both header and footer in SSRS comes with base restrictions. So spend time to create one make sure you get the result you wanted and use that as a sample for future versions. You need to make sure your images are either GIF or JPEG and file size is small. So I think the first thing to do is read up on the header and footer restrictions.

Kind regards,
Gift Peddie

becklery Hall of Fame Points: 3315 More actions · Answer 2

Hi, roelofsleroux.

Maybe you can try RAQ Report[/url]. As I know, developers can save designed report style in the style list with it. Then, when meet report with same condition, users can select the desired style directly.

RAQ Report: Web-based Excel-like Java reporting tool[/url]

royce.bacon SSC Eights! Points: 990 More actions · Answer 3

Here is a discussion about creating templates - http://blogs.msdn.com/bimusings/archive/2005/12/06/500462.aspx

The main key seems to be to put the starting report template in the right folder for Visual Studio to see it.

boumerlin SSCrazy Points: 2023 More actions · Answer 4

IMO, templates were somewhat of an afterthought in SSRS; however, you can also use Custom Assemblies and Code Modules:

http://msdn.microsoft.com/en-us/library/ms155034(SQL.90).aspx

We have integrated SSRS into hosted applications and I used the above to setup style elements based on client.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 5

boumerlin (9/15/2009)
IMO, templates were somewhat of an afterthought in SSRS; however, you can also use Custom Assemblies and Code Modules:
http://msdn.microsoft.com/en-us/library/ms155034(SQL.90).aspx
We have integrated SSRS into hosted applications and I used the above to setup style elements based on client.

The problem with full trust assembly is the you cannot run the application in all places.

Kind regards,
Gift Peddie

boumerlin SSCrazy Points: 2023 More actions · Answer 6

I just dropped my assembly in my C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin folder on the Report Server and have never had a permissions issue.

Gift Peddie SSC Guru Points: 73570 More actions · Answer 7

boumerlin (9/15/2009)
I just dropped my assembly in my C:\Program Files\Microsoft SQL Server\MSSQL.x\Reporting Services\ReportServer\bin folder on the Report Server and have never had a permissions issue.

That means your what is in your assembly is qualified for medium trust.

Kind regards,
Gift Peddie