Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Custom Formatting

Author  Topic 

michael.appleton
Posting Yak Master

160 Posts

Posted - 2009-11-18 : 12:25:06
I'm wondering is there any way to give the option to change the formatting of a report, such as several different styles, when the report is run on the server? Or do I need to create a report for each style?
Thanks,
Michael

JCirocco
Constraint Violating Yak Guru

392 Posts

Posted - 2009-11-18 : 20:34:26
I am sure you could pull it off but the formatting expressions would be UGLY

John
It's a small world (but I wouldn't want to paint it)
Go to Top of Page

michael.appleton
Posting Yak Master

160 Posts

Posted - 2009-11-19 : 04:26:31
I'm very surprised, I thought separating the formatting and content of a report would be something a lot of people would want. I guess reporting services is the wrong tool for me. What kind of (preferably free) reporting tools are out there that support separation of formatting and content, or will I have to create my own web application?
Thanks.
Go to Top of Page

michael.appleton
Posting Yak Master

160 Posts

Posted - 2009-11-19 : 10:03:25
I've found this article that explains a way to make styling dynamic:

[url]http://www.simple-talk.com/sql/reporting-services/reporting-services-with-style/[/url]

Seems a bit of a bodge and a pain adding each a reference to each element of an object, but could be useful if you have to stick to reporting services.

I'm looking into using BIRT now, it supports linking to a style sheet, I believe a basic requirement for reporting. And it's free! Have a look here:

[url]http://www.eclipse.org/birt/phoenix/project/notable2.2.php#jump_16[/url]

If any of you have any other suggestions for reporting services or any other ideas of tools to use, please let me know.
Go to Top of Page
   

- Advertisement -