Click here to Skip to main content
15,301,841 members
Articles / Programming Languages / Visual Basic
Posted 14 Aug 2006


247 bookmarked

A New .NET Reporting Way

Rate me:
Please Sign up or sign in to vote.
4.67/5 (50 votes)
29 Sep 2007CPOL3 min read
Looking for a free and simple way to design and add reports to your .NET application? Take a look at MyNeoReport library.
Sample Image - myneoreport_designer.jpg


About three years ago, I started developing in .NET using a famous free editor and I needed to add some reports to my applications. Since I like to see what I'm going to print, just not to waste half a forest in paper only to adjust that text font, I started developing a little reporting library and a designer that uses it. By the way, my initial work was included into that famous free .NET editor, but I abandoned that project because I saw that it was badly designed (this is the doom of most first drafts), so it became a brand new project: MyNeoReport engine and designer, that let me design reports in a WYSIWYG way and, if I want, I now have total control on each the report objects from my application.


Today, if you are an hobbyist you have also some Microsoft® free solutions to develop your application, but these entry level IDEs still don't have built-in reporting tools (and I also dislike the one included in professional ones). There isn't a free (good and working) solution out there that lets you manage printing in an easy way in managed code, so I decided to begin MyNeoReport and now, after three years, it is quite mature (ok, there are no hyper-advanced features, but boy... it is simple to use, well-organized and free).

Using the Code

In this article, I'll describe some code that you can use for managing the report content in your application. Note that you can access the report at runtime or you can define the report in the designer. Note that the full designer covers almost all the capabilities of the engine, and if you want, you can write your own designer (maybe better than mine).

The preview of the sample report is shown below:


The engine is composed of two libraries:

  1. NeoDataType.MyNeoReport.dll - The core of all
  2. NeoDataType.LiveCodeEngine.dll - The engine for scripting feature

These libraries must be distributed with your application, but you need to reference only NeoDataType.MyNeoReport.dll, since the other is just for support. The main namespace you need to include is NeoDataType.MyNeoReport:

// c#
using NeoDataType.MyNeoReport;

Imports NeoDataType.MyNeoReport

Here you can find all the report entity classes. The most important ones are:

  1. Report, of course, the most important
  2. Page, that defines the page characteristics
  3. Section, that identifies a section (report and page headers and footers, details and groups)
  4. Label, Image, Shape, DataLabel, Dataimage, that are the base items that you can print

Report identifies the report document, it allows you to load and save a report to disk, it gives you some information such as how many pages the report will print, but, more important, it exposes the Page property.

Page describes the page size, orientation, measure unit, and, of course, the sections to be printed.

Section is a horizontal band that contains the items to be printed. Default sections are ReportHeader, PageHeader, Details, PageFooter, ReporFooter, but MyNeoReport also supports grouping sections.

In summary, the structure of a report is as follows:

 +- Page
     +- Sections

Create a New Report and Add Items

// c#
private void CreateANewReportSample()
    // Create a new report
    Report report = new Report();
    // Now you can set Page properties
    Page page = report.Page;
    // Set the page width to 5x8 inches
    page.Units = ScaleMode.Inches;
    page.Width = 5;
    page.Height = 8;
    // Add some items to print
    // - add a label that indicates the page number
    Label label = page.ReportHeader.AddLabel();
    // This label uses special functions as described here:
    label.Text = "Page {@PageNumber} of {@PageCount}";

    // - add an ellipse shape rotated by 20 degrees
    // This is another way to create and add an item
    Shape shape = new Shape();
    shape.ShapeType = ShapeType.Ellipse;
    shape.Angle = 20;
    // If you use the PageControl to add designer capability
    // to your application, you need to assign the Page object
    // to it

Define the Details Data Source

// c#
private void SetDetailsDataSource()
    // Default datasource is OleDbDataSource that lets you connect to OleDb providers.
    // You can choose to pass data to a datasource changing it to a TableDataSource
    // with section.ChangeDatasourceType(DataSourceType.UseDataTable)
    OleDbDataSource dataSource = (OleDbDataSource)report.Page.Details.DataSource;
    dataSource.ConnectionString = myConnectionString;
    // Add a label and a data label bounded to the data
    // to the details section
    // - add a label that indicate the record number
    Label label = page.ReportHeader.AddLabel();
    // This label uses special functions as described here:
    label.Text = "Product {@RecordNumber} of {@RecordCount}";

    // - add a data label that indicates product name
    DataLabel datalabel = page.Details.AddDataLabel();
    // Move the data label to the right
    datalabel.X = label.X + label.Width;
    datalabel.DataField = "ProductName";
    // - add a data label that indicates product price
    datalabel2 = page.Details.AddDataLabel();
    // Move the data label to the right
    datalabel2.X = datalabel.X + datalabel.Width;
    datalabel2.DataField = "UnitPrice";
    // Set the text in case the data is NULL
    datalabel2.NullText = "Price undefined";
    // Set the format of the data, according to MSDN 
    // for the format strings
    datalabel2.Format = "#,###.00";
    // You can call the standard connection string wizard
    // using dataSource.ShowConnectionStringWizard();


Show the Preview and Print

// c#
private void ShowThePreview()
    // Ok, now that you set all the report properties and items
    // you can preview and print it!
    // First of all, you need to choose the destination printer.
    // This is needed also for the preview, so it can be appropriate.

    // Show the preview in a separate window.
    // Note that you can use the NeoDataType.MyNeoReport.PreviewControl
    // if you want a preview in your form.
    // You can also print the report directly with
    // report.Print();

Points of Interest

I like MyNeoReport because its classes let you create a report (data bounded or not) without a designer, but just via your code because the classes give you total control over each aspect of the report and its components.

If you think that the built in items (Label, Image, Shape, DataLabel, DataImage) are too few, you must know that MyNe<code>oReport is extensible: you can write your own item by just inheriting from NeoDataType.MyNeoReport.ItemBase. You can look at the Designer code that is supplied to check all the abilities of the Report classes.

This is just a little introduction to the power of MyNeoReport library. For more information, documentation, support and newer releases, you can visit the site that supports me.


The MyNeoReport 1.4 is a big update, with some new enhancements, optimizations and bug fixes. This is described in the file upgradeinfo.txt contained in the download package.


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


About the Author

Fabio Zanetta
Web Developer
Italy Italy
No Biography provided

Comments and Discussions

QuestionRegarding Designed and Load report Pin
InfoExtract Scripting24-Sep-20 4:16
MemberInfoExtract Scripting24-Sep-20 4:16 
QuestionUnusual header request Pin
robertd90316-Jan-20 10:44
Memberrobertd90316-Jan-20 10:44 
QuestionVB10 e MyNeoReport Pin
sanzio101219735-Mar-18 6:03
Membersanzio101219735-Mar-18 6:03 
QuestionDataSource / subtotal use Pin
Member 1328364528-Jun-17 11:57
MemberMember 1328364528-Jun-17 11:57 
Questiondatagridview to report Pin
Eliseu Fil25-Apr-17 10:27
MemberEliseu Fil25-Apr-17 10:27 
AnswerRe: datagridview to report Pin
Eliseu Fil12-Jun-17 2:11
MemberEliseu Fil12-Jun-17 2:11 
SuggestionWorking DataTable Example Pin
BelloSguardo22-Nov-16 22:59
MemberBelloSguardo22-Nov-16 22:59 
GeneralRe: Working DataTable Example Pin
InfoExtract Scripting25-Sep-20 3:08
MemberInfoExtract Scripting25-Sep-20 3:08 
QuestionEsempio Pin
takoda17-Jan-16 21:56
Membertakoda17-Jan-16 21:56 
eadalb3-Jun-15 8:31
Membereadalb3-Jun-15 8:31 
QuestionNot open source? Pin
i0021-May-15 20:50
Memberi0021-May-15 20:50 
QuestionInsert Page No. in Footer Pin
Member 107007561-Apr-14 5:09
MemberMember 107007561-Apr-14 5:09 
AnswerRe: Insert Page No. in Footer Pin
cnqt6-Sep-16 19:27
Membercnqt6-Sep-16 19:27 
QuestionWhere were you man? Pin
Member 1032848616-Feb-14 1:22
MemberMember 1032848616-Feb-14 1:22 for mono Pin
eujobi1-Feb-14 5:39
Membereujobi1-Feb-14 5:39 
QuestionNeoDataType ?? Pin
Wrangly3-Apr-13 4:42
MemberWrangly3-Apr-13 4:42 
QuestionNot able to use LoadFrom function Pin
mihirj30-Mar-13 2:39
Membermihirj30-Mar-13 2:39 
GeneralRe: Not able to use LoadFrom function Pin
Member 1014336225-Oct-13 10:24
MemberMember 1014336225-Oct-13 10:24 
Questionpagecontrol Pin
oujea26-Jan-13 13:45
Memberoujea26-Jan-13 13:45 
GeneralMy vote of 5 Pin
kelvin.kong3-Sep-12 20:36
Memberkelvin.kong3-Sep-12 20:36 
GeneralMy vote of 5 Pin
Manoj Kumar Choubey5-Mar-12 1:59
professionalManoj Kumar Choubey5-Mar-12 1:59 
QuestionPrinting Dialog Range Problem Pin
Mr.Jocker26-Feb-12 21:22
MemberMr.Jocker26-Feb-12 21:22 
AnswerRe: Printing Dialog Range Problem Pin
sweet022018-Jul-12 20:00
Membersweet022018-Jul-12 20:00 
GeneralMy vote of 5 Pin
Samir Fatah18-Jan-12 18:55
MemberSamir Fatah18-Jan-12 18:55 
GeneralWhere to place the files Pin
SimpleGuyMu4-Jan-11 20:31
MemberSimpleGuyMu4-Jan-11 20:31 

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.