Hi,

I have a task of generating and printing an outgoing document (with the company letterhead). The address, subject, text fields etc. are all saved in a database. I tried doing this using plain HTML but it is almost impossible to get the whole thing fit in and print an A4 size document.

I guess PDF is one option here. Can anyone guide me in this matter. Should I use any third-party component?

 Here is the summary of what I want to do:

1. Add a header, footer and a side image (background perhaps).

2. Adjust the borders.

3. Write text which does not overlap the images.

Thanks in advance.    //  I am using C# ;

DevFox 

Which version of SQL Server do you have? Both SQL 2000 (via an add-on) and SQL2005 by an install option  have reporting services. Reporting service can produce a document and export it as a PDF.

Bah, you dont need reporting services or anything like this.  Asp.net supports PDF printing natively, the only caveat is that, I believe you need to have the full Visual Studio.  Once you have created your report within visual studio you will be all set.  There are two way to output the file, one is with the report viewer control (this option sucks) and the second option is to render the pdf right to the response object. 

Dim abll As New BLL.MydataObject 'You need to get data for your report

Dim reportType As String = "PDF"

Dim mimeType As String = Nothing

Dim encoding As String = Nothing

Dim fileNameExtension As String = Nothing

"<DeviceInfo>" & _

" <PageWidth>8.5in</PageWidth>" & _

" <MarginTop>0.5in</MarginTop>" & _

" <MarginRight>1in</MarginRight>" & _

"</DeviceInfo>"

Dim warnings As Warning() = Nothing

Dim renderedBytes As Byte() = Nothing

Dim streams As String() = Nothing

End Sub

Good luck!!