Hi,
Does anyone know how to create a template for reports that can be
linked to every report. Changes in the template would then be
automatically reflected in every report connected to the template.
This is a similar paradigm as a css style sheet. There is a
description of way to do this in "Hitchhiker's Guide to SQL Server 2000
Reporting Services", but it is rather cryptic and involves a lot of
complex hacks.
Thanks,
Woody
MCADA simplier approach may be to store your "template" information in a table.
Create a template rdl that pulls the information, such as a Page Header that
displays your corp. image lets say. If you need to ever change it, you just
need to overwrite the record in the table.
Obviously, everyone who designs reports would have to use the template. To
ensure that everyone, in fact, does use the same template report, you can
have them overwrite the default template with the new template. The following
is the path to the default template.
C:\Program Files\Microsoft SQL Server\80\Tools\Report
Designer\ProjectItems\ReportProject\Report.rdl
Hope this helps!
"lwoodyiii" wrote:
> Hi,
> Does anyone know how to create a template for reports that can be
> linked to every report. Changes in the template would then be
> automatically reflected in every report connected to the template.
> This is a similar paradigm as a css style sheet. There is a
> description of way to do this in "Hitchhiker's Guide to SQL Server 2000
> Reporting Services", but it is rather cryptic and involves a lot of
> complex hacks.
> Thanks,
> Woody
> MCAD
>|||Thanks for the help :)!!
No comments:
Post a Comment