Friday, March 30, 2012

Manage style of reports from one place?

Is it possible to maintain the style of all of my reports from one place,
say by using a style sheet or by applying a template?
--
McGeeky
http://mcgeeky.blogspot.comThis will help you:
http://www.databasejournal.com/features/mssql/article.php/3422801
It´s a nice guide.
HTH, Jens Suessmeyer.
--
http://www.sqlserver2005.de
--
"McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
> Is it possible to maintain the style of all of my reports from one place,
> say by using a style sheet or by applying a template?
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
>|||Hi Jens,
Thanks for getting back to me with the link. It is useful but it doesn't
quite fit my requirements. The template approach helps when creating a new
report but what if you already have existing reports and you want to change
their look? It seems overly labourious to go in to every report and manually
change all the fonts, colours etc.
Thanks
--
McGeeky
http://mcgeeky.blogspot.com
"Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
> This will help you:
> http://www.databasejournal.com/features/mssql/article.php/3422801
> It´s a nice guide.
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
> news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
>> Is it possible to maintain the style of all of my reports from one place,
>> say by using a style sheet or by applying a template?
>> --
>> McGeeky
>> http://mcgeeky.blogspot.com
>>
>|||If all your reports are the same layout e.g. excel style, you could write
something to parse the reports & apply in your fonts, colours etc. using
xpath. The report would have to be published as a new report, but you could
always delete the old one or move it to a new folder.
Obviously if all the reports are different layouts, then this technique
won't be so good as you'd end up writing a parser for each report!
"McGeeky" wrote:
> Hi Jens,
> Thanks for getting back to me with the link. It is useful but it doesn't
> quite fit my requirements. The template approach helps when creating a new
> report but what if you already have existing reports and you want to change
> their look? It seems overly labourious to go in to every report and manually
> change all the fonts, colours etc.
> Thanks
> --
> McGeeky
> http://mcgeeky.blogspot.com
>
> "Jens Sü�meyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote in
> message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
> > This will help you:
> >
> > http://www.databasejournal.com/features/mssql/article.php/3422801
> >
> > It´s a nice guide.
> >
> > HTH, Jens Suessmeyer.
> >
> > --
> > http://www.sqlserver2005.de
> > --
> >
> > "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
> > news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
> >> Is it possible to maintain the style of all of my reports from one place,
> >> say by using a style sheet or by applying a template?
> >>
> >> --
> >> McGeeky
> >> http://mcgeeky.blogspot.com
> >>
> >>
> >>
> >
> >
>
>|||Thanks for your suggestion. As the number of reports increases I may need to
do something like that.
I found an article since posting this question that said that stylesheets
are not supported in this version of reporting services but will be
introduced in a later version. I suppose you don't know which version that
would be?
Thanks.
--
McGeeky
http://mcgeeky.blogspot.com
"mark-s" <marks@.discussions.microsoft.com> wrote in message
news:F261DC6E-E8CA-428F-A765-5C4688BE4CD4@.microsoft.com...
> If all your reports are the same layout e.g. excel style, you could write
> something to parse the reports & apply in your fonts, colours etc. using
> xpath. The report would have to be published as a new report, but you
> could
> always delete the old one or move it to a new folder.
> Obviously if all the reports are different layouts, then this technique
> won't be so good as you'd end up writing a parser for each report!
> "McGeeky" wrote:
>> Hi Jens,
>> Thanks for getting back to me with the link. It is useful but it doesn't
>> quite fit my requirements. The template approach helps when creating a
>> new
>> report but what if you already have existing reports and you want to
>> change
>> their look? It seems overly labourious to go in to every report and
>> manually
>> change all the fonts, colours etc.
>> Thanks
>> --
>> McGeeky
>> http://mcgeeky.blogspot.com
>>
>> "Jens Süßmeyer" <Jens@.Remove_this_For_Contacting.sqlserver2005.de> wrote
>> in
>> message news:uU%23EOukRFHA.2356@.TK2MSFTNGP14.phx.gbl...
>> > This will help you:
>> >
>> > http://www.databasejournal.com/features/mssql/article.php/3422801
>> >
>> > It´s a nice guide.
>> >
>> > HTH, Jens Suessmeyer.
>> >
>> > --
>> > http://www.sqlserver2005.de
>> > --
>> >
>> > "McGeeky" <anon@.anon.com> schrieb im Newsbeitrag
>> > news:uVk6BgkRFHA.3288@.TK2MSFTNGP14.phx.gbl...
>> >> Is it possible to maintain the style of all of my reports from one
>> >> place,
>> >> say by using a style sheet or by applying a template?
>> >>
>> >> --
>> >> McGeeky
>> >> http://mcgeeky.blogspot.com
>> >>
>> >>
>> >>
>> >
>> >
>>

No comments:

Post a Comment