How To Generate And Download Pdf Report From Database In Mvc Using Itextsharp C

0 views

Skip to first unread message

Sasha Stolt

unread,

Apr 18, 2024, 10:54:16 AM4/18/24

to herzflanewtol

Your post to that software has given me the embryo of an idea of a possible improvement to the library. It can already export data to CSV and SQL, mainly for archiving purposes, but what about PDF (or HTML for that matter) for report generation?. I think it might be nice to be able to generate reports directly from a DB and squirt them out to, say, PDF.

how to generate and download pdf report from database in mvc using itextsharp c

DOWNLOAD ✪ https://t.co/QGQY45h8cm

My Question is: I already try to find a tutorial to make a PDF report with the concept of Master-detail that I explain above in Google, but I have not found a tutorial yet. Is there any source or documentation from ITextSharp or PDFsharp to make PDF report with master detail but from list in code, not from database?

I've been trying to use iTextSharp to create a link to a page in another PDF document (see C# example at ) in an RS report that will be preserved when the report is exported to PDF. A programmer in our shop wrote a C# program to generate the entire PDF report with the links we want, but for obvious reasons, we'd prefer use RS to generate the report, and reference the itextsharp dll to embed the links.

Many of us tried to generate report in *.pdf format but there are no correct tools that just give this feature for free. Here I found one library iTextSharp.dll file which is for PDF reports but there are so many versions of it and it is really very hard to get the right DLL file to generate report, formatting, page numbers and all. So in this article, you will find all these things get done with a simple few lines of codes.

This project is done in ASP.NET using C# language. Here the database used is the Access database. But it really works with SQL Server too. I have tried SQL Server database too but it's easy for me to attach .mdb file in here. The article provides the easiest way to deal with multiple tables and retrieve data from multiple tables and generate the PDF file with header and footer. Also this article helps to insert the page number in each PDF page.

The whole project is attached in the zip file. You can just download and take benefit of this example in your project. The main gist code of the article is shown below. But before using this code, you have to add iTextSharp.dll version 4.1.2.0 file in the Reference of your project and on the top of the *.cs page, you have to import this file. The whole thing is shown in the downloadable zip file. I am getting data from multiple tables joining. The tables being used are CustomerOrder and OrderedItem which are shown in the codes below too. Using DataRelation feature for combining two tables with the total sum are automatically calculated and shown in the report. The codes for this are:

Recently I was looking for an Advance Tool to create complex PDF Report in C#.Netand I found iTextSharp. The main problem is that lacks of Documentation.Yes, there are a few examples in C#, but that is not sufficient to the Beginnersand the examples are in older version of iTextSharp, there are lotsof change in the latest version. So, it will be difficult for beginners to convertolder version to latest version. Besides, I think that if I write an Article onthis, then it will help me also as a future reference as I'll describe each functionalityof this library with example. Frankly speaking, in this Article, you find all theexamples from Chapter 1 of the book iText in Action, Second Edition which is written for Java Developers. I'llexplain all the examples of the rest Chapters in my next release of this Article.So if any one is interested in using this library, he/she will get a good kick start.

Whenever we add Layer in PDF Document, then the content of the Layer resides underOCG Group. So if I remove this Layer we can remove the content of theLayer also e.g. here it is Watermark Text. To remove all the Layers from PDF Document,you have to remove OCG Group completely from the Document using reader.Catalog.Remove(PdfName.OCPROPERTIES).Now follow the Steps below to remove the Watermark Text from Layer:

Another option for generating PDFs with C# is to use a third-party cloud-based API such as CraftMyPDF. CraftMyPDF is a powerful tool that makes it easy to create professional-quality images and PDF documents. With CraftMyPDF, you can easily generate PDFs from existing templates and customize them with your own text and images. CraftMyPDF have many features including:

The .NET framework also provides a few built-in classes for generating PDFs in C#. The most commonly used class is the System.Drawing.Printing.PrintDocument class, which provides an easy way to generate PDFs from scratch.

You can also use the Microsoft Office Interop library to generate PDFs using Microsoft Word. Microsoft Office Interop is a library that allows developers to access the features of Microsoft Office from .NET applications. It provides an easy way to create and manipulate Word, Excel, PowerPoint, and other documents. The library is often used to automate the creation of documents or to extract data from documents.

Crystal Reports is a powerful reporting tool that allows you to generate PDFs from data stored in different sources, such as databases and spreadsheets. To use Crystal Reports in C#, you need to first install the NuGet package Crystal Reports for .NET.

Thinking of getting a business card already? Worry less. In this article, I will be showing you how to auto-generate name cards with Node.js, PHP, and Python using a pre-designed template from CraftMyPDF. So, next time you attend an event or meet someone new, you have your personalized name card ready to do the trick!

Rather than templating a PDF document itself, with IronPDF we can template our HTML using existing, well tried technologies. When the HTML template is combined with data from a query-string or database we end up with a dynamically generated PDF document.

Handlebars makes it possible to create dynamic HTML from C# objects and class instances including database records. Handlebars is particularly effective where a query may return an unknown number of rows such as in the generation of an invoice.

This is wonderful. How weird. We are trying to read a PDF from a database as a stream, add a settable watermark to the document, and then read the document in the browser viewer, from whence it can be printed. We do not wish to save the document with the watermark in the DB, only the pre-watermarked document. This is the only place I could find that shows how this can be done with ITextSharp. PDFSharp and some commercial of the shelf tools can do this just fine. I wonder why I can find so few examples of doing this in ITextSharp but so many examples of this in the other tools?

Using SSRS to generate PDFs was an option recommended by a colleague that left me scratching my head. It seemed like overkill and a nonoptimal solution, but once we talked a little about it, I realized what a great option this one is, the caveat here being that your client is already using SQL Server and SSRS and the solution is on premise. I would not recommend this approach for a cloud-based solution or if your client has not already made the investment of standing up a SQL Server.

The first thing I would recommend is grabbing the RestSharp NuGet package. This package brings a lot of simplicity and features to the table as opposed to HttpClient Class in .NET. We can instantiate a new RestClient using the base URL of our SSRS server and a new RestRequest with the full path to the report we created (MyReport).

I am generating pdf's using iTextSharp dll.I need to put watermark on every page generated.
how can I add watermark to the pdf generated using iTextsharp dll?
Any assistance would be appreciated...

For this exercise, I only want to generate a PDF. No editing, reading or password-protecting PDFs required. The PDF content is a report consisting of table of data from a database. The design makes use of Bootstrap 5 CSS and icons. I also want to use web fonts (Open Sans from Google Fonts) within the PDF. Here's a screenshot of the web version of the report. The table uses the table-striped CSS class to apply alternative backgrounds to table rows. Discontinued items are displayed using the text-black-50 class from bootstrap 5. It also uses Bootstrap icons to indicate whether items need to be reordered. The colour of the icon in these instances is controlled by thetext-danger CSS class. The header and the logo are placed in aflex container and positioned using the justify-content-between CSS class from Bootstrap. You cansee the source code on Github if you are interested.

Each option can generate a PDF file from a string of HTML (as well as other sources, including variously files, streams and URLs). I'm generating my HTML byrendering Razor partials to a string using the technique I blogged about previously. The contents of the partial is essentially a complete HTML5 file. It includes references to local CSS assets using relative paths:

The primary method for generating a PDF from HTML in iText is the HtmlConverter.ConvertToPdf method. This overload take a string, a stream for the output and a ConverterProperties object that consists of options for the converter. You can tell this library was written by Java developers. They love to provide methods for setting property values whereas .NET developers are more likely to allow you to just set the value via a public property. Otherwise the API for generating an A4 portrait PDF (the default document size and orientation) is straightforward . Anyway, we use the ConverterProperties object to set the BaseUri without which iText is unable to resolve the relative URLs in the CSS references in the partial, resulting in no styling being applied to the final PDF. I only discovered this from a Stackoverflow post. The one example on the iText site that demonstrates generating a PDF from HTML fails to mention it. Let's take a look at what is actually generated. The resulting file size is 43KB:

I've taken a look at generating PDF files from HTML within an ASP.NET Core application using three different tools. Each has their different features and requirements. Hopefully this exploration will help you choose a suitable solution for your use. If not, there are a large number of other solutions, mostly 100% commercial, available.