Can I set font/color attributes to reports from a template like for eg. css ?

I have 20 rdl reports that I am working on. I will have to keep a
consistency at the colours, backgroud colours, fonts etc in all of the
reports. Is there any one place where I can define all these
attributes and somehow apply the same attributes to all the reports
with a single stroke(either at the designer or through a .net program)
I mean like calling the css style from a html page.
Consider the above scenario, I guess there are 2 ways i can choose to
build the reporting system. 1) Build all the reports and give the URLs
of the reports to a calling main application 2) Create a .Net program
which calls each report by the programatic rs.render(,,,..) method.
whichever way I build the system I need to have a common way of
setting the attributes. Is that possible ? Please help with solid
ideas/code
Thanks,
Anand SagarSQL Server 2000 Reporting Services has somewhat limited style template
support. Improving support in this area is being looked at for inclusion in
a future release.
Until then you have the following options:
1. You can approximate this behavior by creating the specific report you
want and then placing it in C:\ProgramFiles\Microsoft SQL
Server\80\Tools\Report Designer\ProjectItems\ReportProject directory. These
reports "templates" will show up in Report Designer's Add New Item dialog
along with the Report Wizard, Report, and Data Source templates when
you add a new report to a project.
2. For simple wizard-created reports, you can control the style via
modifying the wizard style templates (there's an XML config file for this
documented in the help)
3. If you're wanting to modify the style dynamically after the reports are
created, you could store style information in your database and then query
for that information in your report, setting style properties based on the
query results (e.g. FontFamily
=First(Fields!DetailRowFontFamily.Value,"StyleDataSet"))
Bruce Johnson [MSFT]
Microsoft SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Anand Sagar" <anandsagar@.gmail.com> wrote in message
news:3f76a771.0408110416.53ab9992@.posting.google.com...
> I have 20 rdl reports that I am working on. I will have to keep a
> consistency at the colours, backgroud colours, fonts etc in all of the
> reports. Is there any one place where I can define all these
> attributes and somehow apply the same attributes to all the reports
> with a single stroke(either at the designer or through a .net program)
> I mean like calling the css style from a html page.
> Consider the above scenario, I guess there are 2 ways i can choose to
> build the reporting system. 1) Build all the reports and give the URLs
> of the reports to a calling main application 2) Create a .Net program
> which calls each report by the programatic rs.render(,,,..) method.
> whichever way I build the system I need to have a common way of
> setting the attributes. Is that possible ? Please help with solid
> ideas/code
> Thanks,
> Anand Sagar