Tuesday, March 20, 2012

Applying Style template afterwards

Hi
Is it possible to apply one of the style templates after creating the report in VS? I'm not using the wizard, but would like to use the style templates afterwards. So first create the whole layout before applying the style.
Cheers, RalfSQL 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.
"RaVaGe" <RaVaGe@.discussions.microsoft.com> wrote in message
news:D78B8A94-5A69-44FA-8990-16A93919B796@.microsoft.com...
> Hi
> Is it possible to apply one of the style templates after creating the
report in VS? I'm not using the wizard, but would like to use the style
templates afterwards. So first create the whole layout before applying the
style.
> Cheers, Ralf

No comments:

Post a Comment