Click here to Skip to main content
15,867,704 members
Articles / Programming Languages / C#
Article

EasiReports

Rate me:
Please Sign up or sign in to vote.
4.87/5 (64 votes)
13 Feb 2006CPOL6 min read 478.6K   9.7K   219   128
A library to add reports to your application.

I suggest you start with the help, the binaries, and the examples. The binaries include a generic wrapper application "EasiReporter" which you can use to test EasiReports against your data sources. The examples include many reports that show the capabilities of EasiReports, including using alternative data sources.

Click for full-size image

Click for full-size image.

Introduction

EasiReports provides a reporting solution for your applications. It is a professional-quality library with comprehensive help files and examples.

EasiReports has been written to be as simple as possible to integrate into your applications and to be as simple as possible for your users. You can publish your own reports, but EasiReports is also aimed at giving your users the power to write their own reports, or modify templates that you provide.

Its unique features include:

  • Automatic SQL generation when accessing a database, so your users don’t have to know anything about SQL.
  • It is highly extensible through its “Plugins” architecture, which provides great flexibility in any .NET language.
  • It can use any .NET data source as input.
  • It can output to many graphics file formats in addition to printing and print preview.

EasiReports follows the section paradigm familiar to Access users, so the learning curve is kept to a minimum. Common tasks can be performed easily, while more complex features are available for advanced users. These include writing code for the integrated C# and VB compilers and even referencing CLR assemblies written in any .NET language.

A demo application, EasiReporter, is included in the SDK. You can use this to explore the capabilities of EasiReports and to test against your own databases or other data sources. It is also useful as a generic report editor for writing your own reports.

In this article, I will briefly describe the main features available in EasiReports. For more detailed information, see the help files. In particular, there is a "Walkthrough" describing how to include EasiReports in your application, in the EasiReports section of the help file.

License

You may use EasiReports in your applications for free. You may not use it in comparable or competitive products. See the license file for details.

You may use the following license key in your applications:

"BuiltNicer;4;CodeProject;71502708;4780EB20"

Background

Reporting is often required in applications but is not as easy as it seems. EasiReports provides a generic reporting solution for accessing any .NET data source.

EasiReports has been written to solve a common requirement and is not just for database applications -- it is flexible enough to be used in many scenarios. For instance, if you just want to preview and print standard reports, you do not have to make the report designer available to the end-user.

In my experience, managers under-value reporting in an application and under-estimate the effort required to provide a stable and comprehensive solution. With EasiReports, you can quickly and simply solve this problem.

Features

User report designer

The user report designer is built into the heart of EasiReports. Include this control in your application to allow users to create, edit, preview, and print their own reports, or to modify templates that you provide. This is part of the core functionality of EasiReports and has been made as simple as possible.

No SQL coding required

Users don't have to know anything about SQL -- EasiReports interrogates your database for metadata, and builds dynamic SQL on the fly. It does this by collecting metadata about the tables, fields, primary and foreign keys in your database. It then examines the report to find out which tables and fields are referenced, and it builds a SQL statement, complete with table joins, which returns all the required data. Use EasiReports for this reason alone!

Data Sources

EasiReports uses OLEDB for default database access but all common .NET data sources are directly supported. If your data source is not supported, it is quite simple to write your own data source handler to expose your data.

Output

In addition to print and print preview, you can also export to many graphics file formats such as GIF, JPEG, and PNG, with just one line of code.

Source Code

Full source code is included with EasiReports. This includes the main source, and the code for three assemblies to give you practical examples of using EasiReports. These are:

  • EasiReporter, the demo application.
  • MetadataViewer, a utility application to display and edit metadata.
  • SquareOneSoftware.dll, an example plug-in assembly.

Between them, these assemblies cover most aspects of working with EasiReports.

Package

EasiReports is a single strong-named assembly written entirely in managed C# -- so you can just copy it to your application directory. It is about 1 MB in size.

Update: EasiReports now references the Puzzle source code editor which is packaged in four assemblies. If you want to allow your users to edit the integrated algorithms, you must also copy these assemblies to your application directory.

Controls

EasiReports supports several types of controls, from simple lines to aggregate functions on user-defined data algorithms. All controls allow you to modify their behaviour at runtime from within the code behind the report.

Algorithms

A very powerful feature is the ability to write code behind reports. Based on an event-driven pattern, you can modify the runtime behaviour of reports, even to the extent of drawing directly onto the page Graphics object.

C# and VB compilers

Choose your language –- these integrated compilers give you and your users virtually unlimited flexibility. Intuitive design allows you to write algorithms at the report, data, section, and control levels.

Visual Studio

Use any .NET language to produce a CLR assembly and you can reference it from within EasiReports at runtime. You can use this feature to build a library of common functionality, or to extend EasiReports from the comfort of Visual Studio. The source code for an assembly providing two classes is included with the example reports.

Object Model

The entire public report object model is accessible from the host application as well as from runtime code. This allows you to build or modify reports dynamically.

Example Reports

EasiReports includes many example reports, from the most simple to the very advanced. These show the capabilities of EasiReports and also show how to accomplish common reporting requirements.

Metadata

EasiReports can automatically interrogate your database for metadata about tables, fields, primary and foreign keys. While this is the preferred method of collecting metadata, the object model is public to allow you full control over which parts of your database are available to the user.

Help

A comprehensive help file with over 1000 pages is provided to aid your development. This includes:

  • A "Walkthrough" to show you how to add EasiReports to your application.
  • A .NET style reference section for the entire public object model.
  • Sections on Algorithms and DataSources for advanced users.
  • Many example reports to show the capabilities of EasiReports.

The full HTML source and HTML Help Workshop project files are provided and may be used in your application’s help file.

Support

I am committed to providing the best technical support available. Adding EasiReports to your applications has been made quite simple and is explained in detail in the help file. If you want additional help, you can email me and I will do my best to help you. You can also request support for writing complex reports.

Conclusion

EasiReports is over 60,000 lines of code. I hope that you find it useful.

History

  • Version 4.8: 06 Feb 2006
    • Improved access to alternative data sources.
    • Syntax highlighted integrated code editors.
  • Version 4.6: 01 Aug 2005: Initial release.

License

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


Written By
United Kingdom United Kingdom
I discovered C# and .NET 1.0 Beta 1 in late 2000 and loved them immediately.
I have been writing software professionally in C# ever since

In real life, I have spent 3 years travelling abroad,
I have held a UK Private Pilots Licence for 20 years,
and I am a PADI Divemaster.

I now live near idyllic Bournemouth in England.

I can work 'virtually' anywhere!

Comments and Discussions

 
GeneralMy vote of 5 Pin
Anu Prakash Iyyadurai26-Aug-12 3:29
professionalAnu Prakash Iyyadurai26-Aug-12 3:29 
Questionhow to remove an algorithm Pin
Bahar Akhtarian12-Feb-10 4:49
Bahar Akhtarian12-Feb-10 4:49 
QuestionHow can I add pictures to this ? Pin
Member 418547626-Oct-09 7:48
Member 418547626-Oct-09 7:48 
Generaladd image to report Pin
Bahar Akhtarian10-Sep-09 8:25
Bahar Akhtarian10-Sep-09 8:25 
GeneralVB 2008 Express Edition and EasiReports Pin
ray4life10-Jul-09 19:04
ray4life10-Jul-09 19:04 
GeneralVisual Studio 2008 Express + .NET 3.5 Pin
MCTimotheus26-Apr-09 20:23
MCTimotheus26-Apr-09 20:23 
GeneralRe: Visual Studio 2008 Express + .NET 3.5 Pin
DaveHolmes27-Apr-09 4:53
DaveHolmes27-Apr-09 4:53 
QuestionHow to use the application but DB No FK? Pin
Member 19846691-Mar-09 21:44
Member 19846691-Mar-09 21:44 
Question30 days trial !? Pin
Daemon44412-Sep-08 0:32
Daemon44412-Sep-08 0:32 
AnswerRe: 30 days trial !? Pin
Daemon44412-Sep-08 0:44
Daemon44412-Sep-08 0:44 
GeneralRe: 30 days trial !? Pin
Daemon44412-Sep-08 0:49
Daemon44412-Sep-08 0:49 
QuestionHow to set sql query to Report instead of design Pin
tuanpm8-Sep-08 0:02
tuanpm8-Sep-08 0:02 
GeneralArray data source Pin
docw15-Aug-08 11:32
docw15-Aug-08 11:32 
GeneralRe: Array data source (solved) Pin
docw16-Aug-08 6:49
docw16-Aug-08 6:49 
GeneralLicense problem with CMetadata Pin
docw13-Aug-08 11:43
docw13-Aug-08 11:43 
GeneralRe: License problem with CMetadata Pin
Nicholas Butler14-Aug-08 1:06
sitebuilderNicholas Butler14-Aug-08 1:06 
GeneralRe: License problem with CMetadata Pin
docw14-Aug-08 4:05
docw14-Aug-08 4:05 
GeneralRe: License problem with CMetadata Pin
Nicholas Butler14-Aug-08 4:37
sitebuilderNicholas Butler14-Aug-08 4:37 
GeneralRe: License problem with CMetadata Pin
docw14-Aug-08 11:31
docw14-Aug-08 11:31 
GeneralFirebird Pin
angelmtm30-Jul-08 22:06
angelmtm30-Jul-08 22:06 
GeneralThanks for such an excellent work!!! Pin
Jorge Orellana29-Jul-08 18:11
Jorge Orellana29-Jul-08 18:11 
QuestionIt is great! what about ... ? Pin
Win32nipuh18-Mar-08 21:22
professionalWin32nipuh18-Mar-08 21:22 
AnswerRe: It is great! what about ... ? Pin
Nicholas Butler19-Mar-08 6:59
sitebuilderNicholas Butler19-Mar-08 6:59 
Generalconnection Pin
deltadirac7-Feb-08 12:22
deltadirac7-Feb-08 12:22 
GeneralHowTo: EasiReports - Postgres - Npgsql Pin
Marc Schwarz26-Nov-07 12:59
Marc Schwarz26-Nov-07 12:59 

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.