Transform your LINQ queries into Excel/PDF reports with DoddleReport 1.2

2 minutes read

DoddleReport generates tabular reports from any IEnumerable datasource. Out of the box it can render reports to Excel, PDF, HTML, and CSV – fully pluggable of course. I created the project to provide reporting output over the LINQ queries we had already written for an application, but maybe you can find other uses for it.

So what does it generate?

The following samples are generated live in real-time (notice the data will change every time you open the report)

Excel Report (OpenXML)

  • Creates a native Excel file using OpenXML
  • Requires the DoddleReport.OpenXml package
  • See it live!

Excel Report (HTML)

  • Creates an Excel file using HTML (downside being an Excel security prompt when opening the report)
  • Automatic Sticky/Frozen Headers stay at the top when scrolling through the data
  • See it live!

doddlexlsreport

doddlexlsreport

PDF Report (iTextSharp)

  • Automatically repeats title and column headers numbers on every page
  • Requires the DoddleReport.iTextSharp package
  • See it live!

PDF Report (ABCpdf)

  • Automatically repeats title, column headers, and page numbers on every page
  • Requires the DoddleReport.AbcPdf package
  • Requires an ABCpdf license
  • See it live!

image_thumb[8]

doddlepdfreport

CSV/Delimited

HTML Report

doddleTxtReport

doddleHtmlReport

Get Started!

New to DoddleReport?

Get it!

NuGet Packages

DoddleReport has been split into multiple packages to support more users’ needs. See their Descriptions within NuGet for more on the differences.

  • Install-Package DoddleReport
  • Install-Package DoddleReport.Web
  • Install-Package DoddleReport.iTextSharp
  • Install-Package DoddleReport.AbcPdf
  • Install-Package DoddleReport.OpenXml
  • Install-Package DoddleReport.Dynamic

New in v1.2

  • NEW WRITER: A new OpenXML ExcelReportWriter found in the DoddleReport.OpenXml package, courtesy of Louis-Philippe Perras
  • NEW WRITER: A new iTextSharp PDF writer can be found in the DoddleReport.iTextSharp package, courtesy of Louis-Philippe Perras (thanks again!)
  • Breaking change: The root namespace changed from Doddle.Reporting to just DoddleReport
  • Breaking change: The Default Orientation for reports is now Portrait
  • All Web references moved to separate project to allow for .NET Client Profile support for WinForms/WPF
  • Added “myReport.RenderHints.BooleansAsYesNo = true” to write Yes/No on the reports for boolean fields
  • Added custom FileName support for web reporting as requested in Discussions
  • Added MVC Areas support by calling areaRegistrationContext.MapReportingRoute();
  • Various Bug fixes and enhancements as reported in the Discussion forum and Issue Tracker

Updated:

Leave a Comment