Generating PDF Report from database in C#, specifically ASP

Question

I need to generate a high quality report based on information in a SQL Server database, and I want very explicit control of the layout and appearance from inside C#.

I have several choices that I know of that are already being used for various other reports at our company:

1) SQL Server's built in Reporting Services

2) Adobe Forms

3) Crystal Reports

This information I need as PDF directly parallels what is already being displayed in the user's web browser as HTML, so creating a print stylesheet and converting the browser body to PDF is an option as well.

So this creates option 4:

4) JavaScript convert HTML to PDF (my preference at this time)

Does anybody have a recommendation as to which approach I should take, or even better an alternative? All the choices seem pretty horrible.

What does scary you in MS Reporting Service? It,s pretty awesome. I personally would definitely prefer it to CrystalReports. — Tigran
– Tigran, Commented Jul 4, 2011 at 20:17
Of those four: SQL Server Reporting Services - hands down. By far the best of those options, in my opinion. — marc_s
– marc_s, Commented Jul 4, 2011 at 20:35
There is also a tutorial out there Output SQL Server Reporting Services (SSRS) Report as PDF from URL with VB.NET or C#.NET that may help someone. — jk.
– jk., Commented Jan 30, 2012 at 17:29

Justin M. Keyes · Accepted Answer · 2011-07-04 21:03:08Z

2

I've used iTextSharp with very good results. It is an open-source .NET port of a java library. It works really well for creating PDFs from scratch. Remember that editing PDFs will always be hacky with any library, because PDF is an output format, not a read-write format.

Provided your HTML is fairly clean (remove javascript postbacks, anchors, ...),the iText HtmlWorker can convert HTML to PDF, if you prefer that route.

HTML to PDF in using iTextSharp:

Document doc = new Document(PageSize.A4);
HTMLWorker parser = new HTMLWorker(doc);
PdfWriter.GetInstance(doc, Response.OutputStream);

Also here.

answered Jul 4, 2011 at 21:03

Justin M. Keyes

7,0343 gold badges36 silver badges65 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Coding Flow · Accepted Answer · 2011-07-04 20:16:58Z

2

Use SSRS, it has a built in PDF rendering mode.

answered Jul 4, 2011 at 20:16

Coding Flow

21.9k6 gold badges68 silver badges84 bronze badges

Comments

Ostemar · Accepted Answer · 2011-07-04 20:20:46Z

1

I have used two other PDF report libraries with great success; Active Reports and Telerik Reporting. Personally I prefer the latter when it comes to programmatic control of layout and such.

answered Jul 4, 2011 at 20:20

Ostemar

5,8282 gold badges21 silver badges16 bronze badges

Comments

Mikhail · Accepted Answer · 2011-07-04 20:26:19Z

1

Take a look also at the DevExpress Reporting (non-free 3rd party tool):

Overview

Online Demos

Documentation

answered Jul 4, 2011 at 20:26

Mikhail

9,3104 gold badges35 silver badges52 bronze badges

Comments

Jacco · Accepted Answer · 2011-07-04 21:08:32Z

Yes, you should use the best tools to get the best solution. The best tool in this case probably is SSRS.

But that's just looking at the capabilities of the tool. Don't forget to look at your own capabilities!

My story: I know SQL, I know C#. (Both intermediate, I'm not a guru.) Then I lay my hands on SSRS. And burnt them, once, twice, etc. At the end, there was a nice result. So burning your fingers is not a wrong thing to do. But first try to pull your html through an html to pdf converter (demo version) and see if the result it serves your needs.

Currently I'm using both:

SSRS for creating invoices, because amounts have to be transported from one page to the next
- Winnovative to generate documents that only need page numbers

ray2k · Accepted Answer · 2011-07-04 22:31:55Z

I would suggest using .Net ReportViewer control in local mode (no report server required). It works in both webforms and winforms. You create a client-side report (.rdlc) file (which contains all the visuals as well as placement of data fields), link it up to the ReportViewer, and supply the data (DataTable or collection of objects, as long as the fields match, it doesn't matter). In client mode it supports exporting to pdf and excel (and Word too? don't remember). By default these done by a dropdown in the control itself however you can programmatically export to any of the supported formats as well. You'll end up with a byte array you can shove into a file stream.

Basically you get most of the good parts of SSRS without all of that backend complexity. There should be a ReportViewer folder in %programFiles%\Microsoft Visual Studio 10.0\ReportViewer - but versions exist for 2005 and 2008 as well. Check out http://gotreportviewer.com/

zavolokas · Accepted Answer · 2011-07-05 07:21:32Z

0

I think the 4th option is the best. In this case you don't need to change either layout of the HTML page or a layout of PDF, if one of them has been changed. It is also more convenient making a nice design via HTML than programmatically via C# :)

Take a look at WebToPDF.NET which is a .NET component written in C# that converts HTML to PDF. The converter supports HTML 4.01, XHTML 1.0, XHTML 1.1 and CSS 2.1 including page breaks, forms and links. It passes all W3C tests (except BIDI).

answered Jul 5, 2011 at 7:21

zavolokas

7072 gold badges5 silver badges20 bronze badges

Comments

Dark Storm · Accepted Answer · 2023-01-08 12:22:07Z

0

You can use Fast Report it's good tool and i has a free version

answered Jan 8, 2023 at 12:22

Dark Storm

3375 silver badges12 bronze badges

Collectives™ on Stack Overflow

Generating PDF Report from database in C#, specifically ASP

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

8 Answers 8

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related