Applying Stylesheet in Reports (e.g. Font, Header)

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 ?

Append Data to a Flat file

Hello,

I was wondering if there was a way for me to append data to a flat file. The reason why i ask this is because i need to create a header for the report that i am exporting.

The way i imagined this working would to be create a dts that would export the header information to a flat file and the create another dts to export the report data and appensd it to the same file that the header dts created. This might not be the correct approach so i was hoping i could get some guidance of how i can accomplish this.

I am using SQL Server 2000.

Thank you!Look up "BCP" in Books on Line (BoL) to be able to do this in SQL.|||Thank you for the tip. I will look this up and post the findings.|||Unless they have changed things, BCP is not able to append to a data file. OSQL, however, can be made to append, given the proper commandline syntax (>>). At that point, however, the whole report may as well be done with a single script in OSQL. Why is Reporting Services not being considered here?|||Right. I just tryed the bcp command and it will not append to the file. I overrights it.

I am not using reporting services because it is not installed on the box.

Can you format the file that osql creates with pipes?