I'm using Reporting Service with Service Pack3 and I want to Apply my own stylesheet in reports. I want to give my own style class to Fonts, Headers etc. Can anyone help me ? Is it possible or not ?SQL 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.
"Gaurav Shah" <Gaurav Shah@.discussions.microsoft.com> wrote in message
news:ACC0AD53-1693-46DA-B929-9DA55A51D373@.microsoft.com...
> I'm using Reporting Service with Service Pack3 and I want to Apply my own
stylesheet in reports. I want to give my own style class to Fonts, Headers
etc. Can anyone help me ? Is it possible or not ?
Showing posts with label font. Show all posts
Showing posts with label font. Show all posts
Tuesday, March 20, 2012
Sunday, February 12, 2012
Anyway to default font of all textboxes to a specific font
Does anyone know of a way to set the default font of all textboxes on a
report to a specific font without doing it in the properties for each
textbox? What about the padding?
Thanks for your help!I don't know of a way to change the default, at least not one I've
actually implemented (e.g., I imagine you can write your own), but
maybe you should contact Chris G. In "Can a TextBox Height and Width be
set dynamically?," he/she says "I have a custom code assembly which I
am using to control my textbox font settings at run time."
Another idea: If you copy and paste an existing textbox, the copy will
have the properties of the original.
Also: Maybe you know this, and even so, it is not an ideal solution,
but you can select more than one textbox (by dragging a selection
rectangle around them or by holding down Ctrl while clicking on each in
turn), then setting a single property (like font) will apply to them
all. You can also copy batches of them this way too.
It is also possible, though maybe not any more practical, to edit the
rdl source file directly.
Cathy wrote:
> Does anyone know of a way to set the default font of all textboxes on a
> report to a specific font without doing it in the properties for each
> textbox? What about the padding?
> Thanks for your help!
report to a specific font without doing it in the properties for each
textbox? What about the padding?
Thanks for your help!I don't know of a way to change the default, at least not one I've
actually implemented (e.g., I imagine you can write your own), but
maybe you should contact Chris G. In "Can a TextBox Height and Width be
set dynamically?," he/she says "I have a custom code assembly which I
am using to control my textbox font settings at run time."
Another idea: If you copy and paste an existing textbox, the copy will
have the properties of the original.
Also: Maybe you know this, and even so, it is not an ideal solution,
but you can select more than one textbox (by dragging a selection
rectangle around them or by holding down Ctrl while clicking on each in
turn), then setting a single property (like font) will apply to them
all. You can also copy batches of them this way too.
It is also possible, though maybe not any more practical, to edit the
rdl source file directly.
Cathy wrote:
> Does anyone know of a way to set the default font of all textboxes on a
> report to a specific font without doing it in the properties for each
> textbox? What about the padding?
> Thanks for your help!
Subscribe to:
Posts (Atom)