Click here to Skip to main content
15,867,141 members
Articles / Programming Languages / Visual Basic
Article

Printing Reports in .NET

Rate me:
Please Sign up or sign in to vote.
4.85/5 (70 votes)
26 Aug 2008CPOL11 min read 438K   15.6K   257   92
Using the library presented, you can print reports from C# and other .NET languages
Sample Image - SampleReport1_small.png

Introduction

Printing a document programmatically can be quite involved. Using the ReportPrinting library presented here, you'll be able to print reports with multiple sections with very little code.

The reports are comprised of plain text sections (such as the title "Birthdays", and the other paragraphs) and grids of data from a database (more specifically, from a DataView object). Lines and images (using the .NET Image class) and boxes (like the CSS box model) are also supported. The framework presented can easily be extended to handle many other primitives.

I do not plan to keep this page up-to-date with the latest code and documentation. This will just be a quick presentation of what you can do and the classes involved. For the latest version, see here. However, this project is not actively being developed, so use at your own risk. This was all written for the .NET 1.1 Framework, and I know a lot of new namespaces were added in .NET 2.0 that may make a lot of this obsolete. It solved a problem I had at the time.

Step-by-Step

This section will take you through the process of using the ReportPrinting library, step by step.

Create a DataView

The first step is to create a DataTable and DataView that serves as the source of data. The following code will create a table of some famous birthdays:

C#
public static DataView GetDataView()
{
    DataTable dt = new DataTable("People");
    dt.Columns.Add("FirstName", typeof(string));
    dt.Columns.Add("LastName", typeof(string));
    dt.Columns.Add("Birthdate", typeof(DateTime));

    dt.Rows.Add(new Object[] {"Theodore", "Roosevelt",
        new DateTime(1858, 11, 27)});
    dt.Rows.Add(new Object[] {"Winston",  "Churchill",
        new DateTime(1874, 11, 30)});
    dt.Rows.Add(new Object[] {"Pablo",    "Picasso",
        new DateTime(1881, 10, 25)});
    dt.Rows.Add(new Object[] {"Charlie",  "Chaplin",
        new DateTime(1889,  4, 16)});
    dt.Rows.Add(new Object[] {"Steven",   "Spielberg",
        new DateTime(1946, 12, 18)});
    dt.Rows.Add(new Object[] {"Bart",     "Simpson",
        new DateTime(1987,  4, 19)});
    dt.Rows.Add(new Object[] {"Louis",    "Armstrong",
        new DateTime(1901,  8,  4)});
    dt.Rows.Add(new Object[] {"Igor",     "Stravinski",
        new DateTime(1882,  6, 17)});
    dt.Rows.Add(new Object[] {"Bill",     "Gates",
        new DateTime(1955, 10, 28)});
    dt.Rows.Add(new Object[] {"Albert",   "Einstein",
        new DateTime(1879,  3, 14)});
    dt.Rows.Add(new Object[] {"Marilyn",  "Monroe",
        new DateTime(1927,  6,  1)});
    dt.Rows.Add(new Object[] {"Mother",   "Teresa",
        new DateTime(1910,  8, 27)});

    DataView dv = dt.DefaultView;
    return dv;
}

This function will return a DataView for a table of a dozen famous individuals and their birthdays.

Create a ReportMaker

The ReportPrinting.IReportMaker interface is used to create objects that setup a ReportDocument. That is, an object that implements IReportMaker will contain all the code necessary to make a report. For this example, it is a class called SampleReportMaker1. It has one method to implement:

C#
public void MakeDocument(ReportDocument reportDocument)
{

Let's take a look at the implementation of this method step-by-step. First, it is a good idea to reset the TextStyle class. TextStyle provides global styles for the formatting of text (such as heading, normal paragraphs, headers, footers, etc.) Since the scope of this class is application wide, it should be reset to a known state at the beginning of report generation.

C#
TextStyle.ResetStyles();

Next, setup the default margins for the document, if desired.

C#
// Setup default margins for the document (units of 1/100 inch)

reportDocument.DefaultPageSettings.Margins.Top = 50;
reportDocument.DefaultPageSettings.Margins.Bottom = 50;
reportDocument.DefaultPageSettings.Margins.Left = 75;
reportDocument.DefaultPageSettings.Margins.Right = 75;

As mentioned, the TextStyle class has several static, global styles that can be applied to different text blocks. These styles can each be customized. We'll change some fonts and colors just to show what's possible.

C#
// Setup the global TextStyles
TextStyle.Heading1.FontFamily = new FontFamily("Comic Sans MS");
TextStyle.Heading1.Brush = Brushes.DarkBlue;
TextStyle.Heading1.SizeDelta = 5.0f;
TextStyle.TableHeader.Brush = Brushes.White;
TextStyle.TableHeader.BackgroundBrush = Brushes.DarkBlue;
TextStyle.TableRow.BackgroundBrush = Brushes.AntiqueWhite;
TextStyle.Normal.Size = 12.0f;

// Add some white-space to the page.  By adding a 1/10 inch margin
// to the bottom of every line, quite a bit of white space will be added
TextStyle.Normal.MarginBottom = 0.1f;

Using our method defined earlier, we'll get a dataview and set the default sort based on the values setup in a GUI. (Note, this is a hack. Better encapsulation should be used to isolate the dialog, defined later, from this class.)

C#
// create a data table and a default view from it.
DataView dv = GetDataView();

// set the sort on the data view
if (myPrintDialog.cmbOrderBy.SelectedItem != null)
{
    string str = myPrintDialog.cmbOrderBy.SelectedItem.ToString();
    if (myPrintDialog.chkReverse.Checked)
    {
        str += " DESC";
    }
    dv.Sort = str;
}

The next step is creating an instance of the ReportPrinting.ReportBuilder class. This object is used to simplify the task of piecing together text, data, and the container sections that they go into (these classes for text, data and sections are described in more detail later in this article).

C#
// create a builder to help with putting the table together.
ReportBuilder builder = new ReportBuilder(reportDocument);

Creating a header and footer are quite easy with the builder class's five overloaded functions. The one below creates a simple header with text on the left side (Birthdays Report) and on the right side (page #). The footer has the date centered.

C#
// Add a simple page header and footer that is the same on all pages.
builder.AddPageHeader("Birthdays Report", String.Empty, "page %p");
builder.AddPageFooter(String.Empty, DateTime.Now.ToLongDateString(),

    String.Empty);

Now the real fun begins: we start a vertical, linear layout because every section from here should be added below the preceding section.

C#
builder.StartLinearLayout(Direction.Vertical);

Now add two text sections. The first section added will be a heading (as defined by TextStyle.Heading1). The second section is just normal text (as defined by the TextStyle.Normal).

C#
// Add text sections
builder.AddTextSection("Birthdays", TextStyle.Heading1);
builder.AddTextSection("The following are various birthdays of people " +
    "who are considered important in history.");

Next, we add a section of a data table. The first line adds a data section with a visible header row. Then three column descriptors are added. These are added in the order that the columns are displayed. That is, LastName will be the first column, followed by FirstName, followed by Birthdate.

The first parameter passed to AddColumn is the name of the column in the underlying DataTable. The second parameter is the string as printed in the header row. The last three parameters describe the widths used. A max-width can be specified in inches. Optionally, the width can be auto-sized based on the header row and/or the data rows. In this case, with false being passed, no auto-sizing is performed.

C#
// Add a data section, then add columns
builder.AddDataSection(dv, true);
builder.AddColumn ("LastName", "Last Name", 1.5f, false, false);
builder.AddColumn ("FirstName", "First Name", 1.5f, false, false);
builder.AddColumn ("Birthdate", "Birthdate", 3.0f, false, false);

We set a format expression for the last column added (the date column). These format expressions are identical to those used by String.Format. This makes the date show up in long format.

C#
// Set the format expression to this string.
builder.CurrentColumn.FormatExpression = "{0:D}";

And the very last thing is to finish the LinearLayout that was started earlier.

C#
    builder.FinishLinearLayout();
}

Create a Form for Printing

There are only a handful of controls on the following form: a label, a combo box, a check box, and a usercontrol from ReportPrinting namespace called PrintControl. This control has the four buttons you see at the bottom of the form.

Image 2

This form also has an instance of the ReportPrinting.ReportDocument class. This is a subclass of System.Drawing.Printing.PrintDocument. If you create the above form in a designer, here is the constructor required to create a new ReportDocument object.

C#
private ReportDocument reportDocument;
public ReportPrinting.PrintControl PrintControls;
public System.Windows.Forms.ComboBox cmbOrderBy;
public System.Windows.Forms.CheckBox chkReverse;

public SamplePrintDialog1()
{
    InitializeComponent();

    this.reportDocument = new ReportDocument();
    this.PrintControls.Document = reportDocument;

    SampleReportMaker1 reportMaker = new SampleReportMaker1(this);

    this.reportDocument.ReportMaker = reportMaker;

    this.cmbOrderBy.Items.Clear();
    this.cmbOrderBy.Items.Add("FirstName");
    this.cmbOrderBy.Items.Add("LastName");
    this.cmbOrderBy.Items.Add("Birthdate");
}

In this constructor, an instance of ReportDocument is created. This instance is assigned to the PrintControls.Document property. A SampleReportMaker1 object (defined above) is then instantiated and assigned to the ReportDocument's ReportMaker property. The final bit of the constructor simply sets up the ComboBox.

You're Finished

The above code prints a fairly simple document. Just to note, you can use the standard PrintDialog, PrintPreview, and PageSettings dialogs (without using the PrintControls usercontrol).

This entire sample can be found in the download of the ReportPrinting library, along with many other tests that I have created (most are boring to look at, but test various random settings).

Report Document Classes

There are several classes introduced into the ReportPrinting namespace. They work together for the printing of the above report (in addition to all the .NET Framework base classes that are used). Here is a quasi-UML diagram that shows the relationship between these classes. An open triangle is generalization (i.e. it points to the super-class in the inheritance chain). The black diamonds are composite (i.e. show that one class instantiates members of another class). The dashed-lines are dependency (i.e. it uses the class).

Image 3

ReportDocument

ReportDocument extends from PrintDocument and is customized for printing reports from one or more tables of data. A ReportDocument object is the top-level container for all the sections that make up the report. (This consists of a header, body, and footer.)

The ReportDocument's main job is printing, which occurs when the Print() method is called of the base class. The Print() method iterates through all the ReportSections making up the document, printing each one.

The strategy design pattern is employed for formatting the report. An object implementing IReportMaker may be associated with the ReportDocument. This IReportMaker object is application specific and knows how to create a report based on application state and user settings. This object would be responsible for creating sections, associating DataViews, and applying any required styles through use of the TextStyle class. It will generally use the ReportBuilder class to assist with the complexity of building a report.

ReportSection

ReportSection is an abstract class that represents a printable section of a report. There are several subclasses of ReportSection, including ReportSectionText (which represents a string of text) and ReportSectionData (which represents a printable DataView). There are also container sections (which derive from SectionContainer class, which in turn derives from ReportSection). These containers hold child ReportSection objects (also known as subsections) to be printed. Let’s take a quick look at how this might work with an example.

In the sample report shown at the top of this article, there is a paragraph of text followed by a table of data. (There are actually two paragraphs of text, one of which is a heading. Plus there is a page header, but we'll ignore all that for now.) We would create a ReportSectionText object to print the paragraph of text and a ReportSectionData object to print the table of data. To add both of these ReportSections to the ReportDocument, we must create a container. We would create a LinearSections container to hold these two sections. This container is then made the body of the ReportDocument. When the document is printed, the section container will first print the ReportSectionText, and then below that, it will print the ReportSectionData. Simply printing each section below the preceding one will result in the finished report. But there are many other ways to set up these classes.

SectionContainer

This abstract class defines a container of sections. There are two types provided with the framework: LinearSections and LayeredSections.

LinearSections

The LinearSections class is a subclass of SectionContainer, which is a subclass of ReportSection. Therefore, the LinearSections can be thought of as "a printable section of a report." However, it is also a container of one or more sections.

As its name implies, it lays sections out linearly -- that is, in a row or in a column. A property named Direction specifies if this container will layout sections going down the page (typical) or across the page (not as typical).

LayeredSections

The LayeredSections class is also a subclass of SectionContainer, which is a subclass of ReportSection. Therefore, the LayeredSections can be thought of as "a printable section of a report." It is also a container of one or more sections.

The child sections of a LayeredSections object are all painted on top of one another (creating layers). The first section added to a LayeredSections object is the bottom layer. Subsequent ReportSection objects added to the LayeredSections object will be shown on top of each other.

ReportSectionText

The ReportSectionText prints a string to the page. Two public properties are used to setup this section. Text is used to specify the string to print. TextStyle, described later, sets the font, color, alignment and other properties for how the text is printed.

It is interesting to note that the string specified for this section can be just one word, or many paragraphs of text.

ReportSectionData

The ReportSectionData prints a table of data. It uses a DataView object (from the .NET System.Data namespace) as the source of data. It then uses a series of ReportDataColumns to provide the formatting details. These ReportDataColumns are similar to the DataGridColumnStyle class.

ReportDataColumn

The ReportDataColumn provides the necessary information for formatting data for a column of a report. For every column to be presented within a section of data, a new ReportDataColumn object is instantiated and added to the ReportSection. At a minimum, each column describes a source field from the DataSource (that is, a column name from the DataView) and a maximum width on the page.

The ReportDataColumn can be setup with its own unique TextStyle for both header and normal rows. Therefore, each column's data can be formatted differently (e.g. an important column could be bold and red). The TextStyle is also used to set the horizontal alignment (justification).

TextStyle

The TextStyle class allows styles and fonts to be added to text selectively, allowing default styles to be used when not explicitly set. All styles (except for the static TextStyle.Normal) have another style as their "default" style. Until a property is set (like bold, underline, size, font family, etc), a TextStyle object always uses the corresponding value from its default (or parent) style.

For example, a new style can be defined using Normal as its default, but setting bold.

C#
TextStyle paragraphStyle = new TextStyle(TextStyle.Normal);
paragraphStyle.Bold = true;

It will have all the same properties as TextStyle.Normal, except it will be bold. A later change to Normal (such as below) will have the effect of increasing the size of both styles (Normal and paragraphStyle).

C#
TextStyle.Normal.Size += 1.0f

ReportBuilder

ReportBuilder assists with the building of a report. This class is the main interface between your code and the ReportPrinting library. In many cases, you will never explicitly create any of the above objects. Instead, the ReportBuilder will create them for you.

To instantiate a ReportBuilder, you must provide the ReportDocument to be built. Then you can call its various Add… methods to sequentially add pieces to a report document.

We've already seen an example of using ReportBuilder above.

IReportMaker

IReportMaker is an interface used to implement the strategy design pattern. An object that implements IReportMaker can be added to a ReportDocument. When the document is about to be printed, it automatically calls the single method MakeDocument(). The above example shows an implementation of that method to print a one-page report.

For example, you could have an application that can print either detailed reports or a shorter overview. The logic to make each of these reports would be located in separate classes. Each class would implement the IReportMaker interface. Your print dialog could have a "Print What" combo box to allow the user to select the type of report, and use the selection in the combo box to associate the correct implementation of IReportMaker with the ReportDocument.

Conclusion

That summarizes the ReportPrinting library.

Revision History

  • 06-Sep-2003
    • Initial version of article posted with version 0.32 of the ReportPrinting library
  • 01-Sep-2003
    • An updated version of code
  • 24-Aug-2008
    • Removed two dead links
    • Updated code to the latest known good code from Sourceforge
    • Added a little bit of text that this is no longer being actively worked on
    • Ran through Visual Studio's reformat document to clean up some HTML

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)


Written By
United States United States
This member has not yet provided a Biography. Assume it's interesting and varied, and probably something to do with programming.

Comments and Discussions

 
GeneralRe: Unicode processing and right to left layout Pin
Member 29796896-Sep-08 9:58
Member 29796896-Sep-08 9:58 
GeneralLandscape from page 1 Pin
Bertil de Groot19-May-08 23:09
professionalBertil de Groot19-May-08 23:09 
GeneralRe: Landscape from page 1 Pin
Grafne8-Sep-09 1:25
Grafne8-Sep-09 1:25 
GeneralRe: Landscape from page 1 Pin
Ajay Britto5-Feb-10 22:04
Ajay Britto5-Feb-10 22:04 
GeneralRe: Landscape from page 1 Pin
Wahbiii21-Jan-11 9:35
Wahbiii21-Jan-11 9:35 
GeneralRe: Landscape from page 1 Pin
Osman Kalache23-Jun-12 21:39
Osman Kalache23-Jun-12 21:39 
Questionvb.net print form problem Pin
ranipriya 201014-May-08 4:35
ranipriya 201014-May-08 4:35 
GeneralCountPages bug. Pin
evxif25-May-07 10:49
evxif25-May-07 10:49 
If you have a table run on more than one page and set reportDocument.CountPages = true; the printing goes to infinite loop.

Anyway to sort this out.

Many thanks


GeneralRe: CountPages bug. Pin
v# guy3-Sep-07 15:07
v# guy3-Sep-07 15:07 
QuestionPrint Preview Control - SpeedUp the generation of pages Pin
umaramiya11-Dec-06 21:59
umaramiya11-Dec-06 21:59 
GeneralNow Released on SourceForge Pin
Mark Farmiloe27-Nov-06 7:55
Mark Farmiloe27-Nov-06 7:55 
GeneralNow on SourceForge Pin
Mark Farmiloe22-Oct-06 4:17
Mark Farmiloe22-Oct-06 4:17 
GeneralRe: Now on SourceForge Pin
Klaasjan Mors29-Oct-06 23:20
Klaasjan Mors29-Oct-06 23:20 
GeneralRe: Now on SourceForge Pin
Zoltan Balazs30-Oct-06 6:53
Zoltan Balazs30-Oct-06 6:53 
GeneralRe: Now on SourceForge Pin
Mark Farmiloe31-Oct-06 10:02
Mark Farmiloe31-Oct-06 10:02 
GeneralRe: Now on SourceForge Pin
Zoltan Balazs31-Oct-06 10:48
Zoltan Balazs31-Oct-06 10:48 
GeneralRe: Now on SourceForge Pin
Mark Farmiloe27-Nov-06 7:50
Mark Farmiloe27-Nov-06 7:50 
GeneralRe: Now on SourceForge Pin
Zoltan Balazs28-Nov-06 20:26
Zoltan Balazs28-Nov-06 20:26 
QuestionVersion 0.5 Update....? Pin
KentuckyEnglishman28-Oct-05 8:03
KentuckyEnglishman28-Oct-05 8:03 
AnswerRe: Version 0.5 Update....? Pin
KentuckyEnglishman28-Oct-05 8:05
KentuckyEnglishman28-Oct-05 8:05 
GeneralRe: Version 0.5 Update....? Pin
Mark Farmiloe20-Mar-06 6:16
Mark Farmiloe20-Mar-06 6:16 
GeneralRe: Version 0.5 Update....? Pin
KentuckyEnglishman21-Mar-06 2:50
KentuckyEnglishman21-Mar-06 2:50 
GeneralRe: Version 0.5 Update....? Pin
Zoltan Balazs18-Jul-06 3:21
Zoltan Balazs18-Jul-06 3:21 
GeneralRe: Version 0.5 Update....? Pin
Mark Farmiloe18-Jul-06 4:54
Mark Farmiloe18-Jul-06 4:54 
GeneralRe: Version 0.5 Update....? Pin
Zoltan Balazs18-Jul-06 5:47
Zoltan Balazs18-Jul-06 5:47 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.