Data Dynamics Reports Logo Data Dynamics Reports Screenshot

Full-featured reporting solution that makes it easy to create reports, dashboards, and other documents to inform.

At a Glance

Data Dynamics Reports is a feature-rich reporting engine designed to create reports, dashboards, invoices, form letters, and other documents easily. Integration with the Visual Studio IDE puts the full aresenal of features at developer's fingertips.

Documents created in Reports resemble the final output while being edited due to the layout options available within the designer. Productivity enhancement features such as master reports, shared data sources and report themes reduce the time it takes to create new reports.

System Requirements
Design Time
  • Visual Studio 2005 SP1 or Visual Studio 2008
  • Windows 2000 or later
  • .NET Framework 2.0 or later
Run Time
  • Windows 2000 or later
  • .NET Framework 2.0 or later
More than just reports
Excel support

The new Excel Transformation Device makes it possible to analyze the numbers using the familiar Excel environment. More than a simple export, the Excel Transformation Device allows users to thange the form of their reports into useful Excel spreadsheets and take full advantage of all Excel has to offer. Bind data to Excel charts or pivot tables and see the display change as you perform what-if analysis. View a video of the Excel capabilities now!

This release of the Excel Transformation Device is a beta release that contains much of the functionality that will exist in the release version. Still to come are the transformation capabilities that would allow report authors or developers to create their own templates with charts pre-bound to the data.

Transform reports into Excel spreadsheets!
Dashboards

Keep informed of the current status of your business with the included Dashboard controls.

Sparklines allow readers to see what data has done overtime to see a trend without distracting from the important part of the display, the trend.

Bullet graphs give readers an instant recognition of how a KPI or other statistic is currently doing, broken down into 2-3 ranges and displaying an optional target; all in a space saving display. View a video of the dashboard controls now!

Call center dashboard displaying several different KPIs
Form letters
Produce great looking form letters using the included Formatted Text control. Display XHTML and CSS content in the document and bind it to fields in your dataset.
A form letter that uses binds data to the document
Batch documents
The page numbering features in Data Dynamics Reports make it easy to create batch documents where each section can have its own set of page numbers. View a video showing how to add this feature to an existing report now
A series of pages are display with page numbers: 1 of 2, 2 of 2, 1 of 3, 2 of 3, 3 of 3
Calendars
The built in calendar control is perfect for analyzing or displaying date-based data.
Take documents with you
Data Dynamics Reports supports many different document formats each tailored for different purposes so everyone can make the most of the data put together in the report. Excel, PDF, Word, HTML, XML, and various image formats are supported.
Key Features
Region-based documents
Position document elements where you want them to appear. A table next to a chart in the monthly sales report, a chart inside of a matrix in the sales by product report, a grid of sparklines and bullet graphs in the warehouse status dashboard. The near-WYSIWYG experience takes the guess work out of what the final document will look like.
A table of data, a column chart, and a cross tab display various aspects of sales data
Master Reports
Master Reports allow report authors to have a consistent base layout to work from as well as provide common data sources, data sets, report parameters, embedded images, theme, and custom code. Developers use them to let end-users start with a template of content. Authors working on a suite of reports use them to create a consistent look throughout the entire suite. View a video explaining the Master Reports feature now!
Themes
Theme support allows report authors to use a standard set of colors, fonts, and images throughout a set of documents. This makes it easy to update the look of a report by just changing the one theme file.
Data Relationships
Data Dynamics Reports understands how data is constructed and doesn't force authors to change the way they store data in thier application in order to report off of it. When using the ADO.NET DataSet data provider authors can pull data from related data tables by following the existing DataRelations built into the dataset. The Object data provider can also follow a chain of properties to access the related data, allowing authors to go from the OrderDetail object to the Order, to the Customer, to access the customer's name. XPath expressions can be used in the XML data provider to access data located higher up in the element hierarchy.
Barcode
The included bar code report item supplies support for over 20 different barcode formats to be used within a document. The barcode report item can be used to tie paper reports into existing information management systems.
Report navigation
Drilldown

Drill down allows viewers to expose or hide content conditionally. Expose hidden table rows or columns, break data in a matrix into finer detail, hide additional customer detail all without having to rerun the report.

Drillthrough

Drillthrough links reports together. The report being linked to as well as the parameters to pass can be determined at runtime by using expressions. For example, the details of a matrix may link to one report while the subtotal could link to a different one. In addition to working with regular textboxes, drillthrough is also supported on charts allowing each chart area to link to a report and pass in parameters. Watch a video showing how to set this up in your own reports now!

Hyperlinks

Hyperlinks allow report authors to link to website, intranets, files, and other URI based schemes. When combined with the bookmark feature it also creates a way for a report reader to be linked to other places within the report as well.

Document map

Both the windows viewer and the ASP.NET web viewer have the option of displaying a document map; allowing readers of the document to jump to the particular section they are interested in.

Bookmarks

Bookmarks, when combined with hyperlinks, allow authors to link to particular places within the document. A section at the top of the document may list all of the available companies in the report, each linking to a particular bookmark. Further into the report the bookmark property may be set on a textbox to serve as the anchor for the earlier links.

Data visualizers
Research has shown that the brain can only hold about 4 pieces of information in working memory at a time*, with the data visualization functions you can reduce the amount of data the reader needs to consider when interpreting the results of analytical reports.
Data bar

Data bars display a bar against a known minimum and maximum value, similar to how a horizontal bar graph would appear. Infact they are typically used to create reports where more information can be displayed with the bar graph as the example below shows.

Range bar

Similar to the data bar, the range bar displays a bar against a known minimum and maximum value. It also adds a secondary bar or point, typically to indicate progress but it could also be used to encode a second value.

Icon set

Icon sets distill information into 6 possible states, 1 of 5 different images, or no image at all. This is done by specifying several different expressions, the first one to evaluate to true represents the image to display. Eleven different sets of icons are available and it supports using user-defined images as well.

Color scale

Color scale maps a numeric value onto a range of colors. Useful for producing a heat map or using color intensity to indicate extreme values, the color scale reduces the complexity when dealing with many values.

Designer
Unified data explorer
The unified data explorer puts common expressions, parameters, data sources, data sets, and embedded images at your finger-tips.
Data visualizer editor
The customizations allowed in the data visualizers can create a hefty expression to type in by hand. The data visualizer option on image and color properties makes it simple to construct the data visualizer needed for your document, complete with a preview of how the data visualizer may look at run-time.
Visual studio integration
The designer is fully integrated into Visual Studio to provide a familiar design environment. From the property grid, to the toolbox and data explorer window each is integrated directly into Visual Studio.
Smart panels
Smart panels provide a standard way of accessing the properties available on data regions and report items alike. The built-in editors make it easy to set up the documents being designed.
Designer control

The same designer that is available in Visual Studio can also be embedded in your own Windows Forms and WPF applications. Let your users design their own documents or just tweak existing ones.

Licensing
Royalty-free deployment
Royalty-free deployment keeps your costs low as you deploy to as many users or servers as you want.
Free maintencence updates
Our development team is constantly working on adding new features and fixing bugs in the product. These maintenance releases are free to to customers and made available from the website.
Question: What are the differences between Data Dynamics Reports and ActiveReports for .NET 3.0?

Answer: Data Dynamics Reports targets reporting as a function of business intelligence applications while ActiveReports for .NET focuses on providing the most flexible object model that gives developers the freedom to customize and create complex reports with ease.

Data Dynamics Reports is designed to require less code "behind" the report and instead to use Visual Basic .NET expressions within report item properties to evaluate values. ActiveReports for .NET on the other hand, is a very developer-oriented system that features events for complete run-time customization of the report.

Both Data Dynamics Reports and ActiveReports for .NET include WebForms report preview controls, however ActiveReports also includes an ActiveX-based viewer that renders the report graphically instead of through HTML and CSS. Both products also include Windows Forms report preview controls and end-user designer components. Data Dynamics Reports ships with pre-built applications for report viewing and creation.

Data Dynamics Reports supports different data regions. In ActiveReports for .NET, a report is created in a series of bands, each band displaying its data in certain parts of the report. Data Dynamics Reports supports this data region, called the Banded List, and also supports Table, Chart, Matrix (crosstab), and List data regions.

Features available only in Data Dynamics Reports include:

  • Less code (no code-behind events; uses VB.NET expressions)
  • Data Visualization functions
  • Report Drilldown
  • Matrix (crosstab)
  • FormattedText report item that displays XHTML and CSS content
  • Multiple Datasets or Data Sources in a report
  • Pre-built report viewer and designer applications
  • Advanced aggregate functions
  • Master reports that act as templates for child reports
  • Themes that allow you to set up common styles, colors, and images in one location.
  • Word Rendering Extension
  • Image Rendering Extension that renders reports to BMP, EMF, GIF, JPEG, TIFF, and PNG formats
  • Layout-based reporting

Features available only in ActiveReports for .NET include:

  • Code behind and an Event system for complete run-time customization
  • ActiveX Report Viewer
  • OLE Object and Windows Forms Controls can be used on reports
  • Unbound mode events for run-time data binding to any data source
  • Flexible object model
  • RTF content
  • Excel Export
  • RTF Export
  • Plain Text Export
  • Graphical canvas-based reporting

Special features that save you time and money in both products include:

  • A chart that supports all of the most commonly-used chart types plus a diverse array of financial chart types
  • A barcode that supports all of the most popular symbologies
  • PDF Export (or Rendering Extension)
  • HTML Export (or Rendering Extension)
  • Excel Export (or Transformation Device)
  • Royalty-free developer licensing

Answer: Both products implement the Report Definition Language (RDL) 2005 specification but from there the products differ.

Data Dynamics Reports introduces several features not found in SSRS.

  • Master Reports:
    Master Reports are similar in design to Master Pages in ASP.NET. Reports can specify a live-template that provides a common set of report items, data sources, data sets, report theme, and report parameters.
  • Report Theme
    Report Themes allow report authors to easily follow a consistent look for their reports by providing a set of colors, fonts, and images.
  • Data Visualizers
    Data Visualizer functions allow the user to display a graphic based on some set of data instead of forcing the user to read individual values. A color scale selects a color from a range based on a value from that range. A data bar or range bar displays a rectangle with the length dependant on the value. An optional progress indicator can be used as well. The icon set allows the report to display one of 5 images to represent the state of some data.
  • FormattedText Report Item: Renders XHTML and CSS into your reports
  • Barcode Report Item: Supports over 20 of the most popular barcode types
  • Banded List data region: Gives report authors the freeform placement of the List data region with enhanced grouping support
  • Enhanced chart control with additional chart types not found in SSRS
  • Enhanced PDF support with built in security options, font embedding, and font subsetting
  • Developer support
    • Report API allows developers to create and render reports programmatically without using the viewer or designer controls.
    • The Designer control allows your end-users to create their own reports with the same design capabilities as found in the Visual Stduio 2005 IDE.
    • The Viewer controls allow the full functionality of Data Dynamics Reports; connect to any supported data source, use any of the custom report items, or custom rendering extensions.

Answer: The Report Definition Language (RDL) sets out both a file format and how elements in a report should be rendered. It also defines a base set of functionality that should be available in a report.

Some of the features required in the RDL 2005 specification include:

  • Table, Chart, List, and Matrix data regions
  • Grouping, sorting, and filtering support
  • Multiple Data Sources and Data Sets in a report
  • Textbox, image, rectangle, and line report items

Data Dynamics Reports and Microsoft SQL Server Reporting Services are just two products that implement the RDL 2005 specification.

No, Data Dynamics Reports does not build on Microsoft SQL Server Reporting Services (SSRS). Data Dynamics Reports is a self-contained reporting library that contains its own report engine, API, viewer, and designer controls.

Data Dynamics Reports can read and execute the RDL files produced by SSRS because the files follow the RDL format, but that is the only connection.

License Agreement and Limited Warranty

Data Dynamics Reports 1.5

Please read carefully before installing this software package. Your installation of the package indicates your acceptance of the terms and conditions of this license agreement. Contact GrapeCity, inc. if you have any questions about this license.

The Product (libraries and object code) is proprietary to GrapeCity, inc. and is protected by Federal Copyright Law. GrapeCity, inc. retains the title to and ownership of the Product. You are licensed to use this Product on the following terms and conditions:

LICENSE: The Product is licensed per software application developer ("developer") and must be activated by said developer. Licensee is defined as the person or entity that pays consideration for the license to use the Product. GrapeCity, inc. hereby grants the Licensee a nonexclusive License authorizing one, and only one, developer at a time to use the Product for development purposes. The Licensee is also permitted to distribute applications containing the files designated below on a royalty free basis. The use of this License does not create any kind of partnership or joint ownership interest in the Licensee's proprietary applications. Please contact GrapeCity, inc. if you require additional Licenses. Licensee may incorporate the sample code into Licensee's applications. Use of this product by more than one developer at a time terminates, without notification, this License and the right to use this product.

LICENSEE MAY NOT: Distribute, rent, sub-license or otherwise make available to others the software or documentation or copies thereof, except as expressly permitted in this License without prior written consent from GrapeCity, inc.. In the case of an authorized transfer, the transferee must agree to be bound by the terms and conditions of this License Agreement.

RESTRICTIONS: Licensee may use this Product in Licensee's business application for sale or distribution as long as:

  1. The product that Licensee produces and/or distributes is NOT a software development product; a product that is sold primarily to software developers or system integrators or a development environment of any kind. Please contact GrapeCity, inc. for special commercial licensing provisions in these circumstances.
  2. The software license is activated and registered through GrapeCity, inc..
    • Activation and registration is accomplished during installation via a web service
    • In the event that web access is not available, the registering developer should contact our technical support group for assistance
  3. Licensee may not remove any proprietary notices, labels, trademarks on the software or documentation.
  4. Licensee may not modify, de-compile, disassemble, reverse engineer or translate the software.

FILES THAT MAY BE DISTRIBUTED WITH LICENSEE'S APPLICATION:

datadynamics.reports.config, DataDynamics.Reports.dll, DataDynamics.Reports.Calendar.dll, DataDynamics.Reports.Dashboard.dll, DataDynamics.Reports.Design.dll, DataDynamics.Reports.Diagnostics.dll, DataDynamics.Reports.Extensibility.dll, DataDynamics.Reports.Rendering.Excel.dll, DataDynamics.Reports.Rendering.Graphics.dll, DataDynamics.Reports.Rendering.Html.dll, DataDynamics.Reports.Rendering.Pdf.dll, DataDynamics.Reports.Rendering.Word.dll, DataDynamics.Reports.Rendering.Xml.dll, DataDynamics.Reports.Web.dll, DataDynamics.Reports.Windows.Forms.dll, DataDynamics.Reports.Designer.exe, DataDynamics.Reports.Designer.chm, DataDynamics.Reports.Preview.exe, DataDynamics.Reports.Preview.chm, DataDynamics.Reports.ThemeEditor.exe

US GOVERNMENT RESTRICTED RIGHTS: Use, duplication or disclosure by the United States Government is subject to restrictions as set forth under DFARS 252.227-7013 or in FARS 52.227-19 Commercial Computer Software - Restricted Rights.

TERM: Licensee may terminate its License and this Agreement at any time by destroying all copies of the Product and Product Documentation. This License and this Agreement will also terminate automatically if Licensee fails to comply with any term or condition in this Agreement.

LIMITED WARRANTY: This software and documentation are sold "as is" without any warranty as to their performance, merchantability or fitness for any particular purpose. Licensee assumes the entire risk as to the quality and performance of the software. GrapeCity, inc. warrants that the media on which the Program is furnished will be free from any defects in materials. Exclusive remedy in the event of a defect is expressly limited to the replacement of media. In no event shall GrapeCity, inc. or anyone else who has been involved in the creation, development, production, or delivery of this software be liable for any direct, incidental or consequential damages, such as, but not limited to, loss of anticipated profits, benefits, use, or data resulting from the use of this software, or arising out of any breach of warranty.

Online Support Forum
Data Dynamics Reports Support Forums are a great place to get other developers' opinions, views and ideas. Developers can expect to find the Data Dynamics staff posting comments and helpful information as well.
Email Support
If you can't find your answer on the support forum, feel free to email us with your questions or comments by visiting our online Support Request page.
Phone Support
Data Dynamics also offers free phone support. However, it is recommended that this be the last resort when providing feedback or asking questions. When calling in for support, please have your serial number on hand to ensure that your call gets directed to our technical support staff as fast as possible. Our phone number is (425) 880-2601.


Data Dynamics Reports - Excel Transformation Device Overview:

  • Rendering Reports to Excel Format
  • Support for All Report Items
  • Clean Layouts and Formatting
  • Excel Rendering Templates

View the 'Excel Transformation Device Overview' Screencast

Data Dynamics Reports - Dashboard Controls:

  • Bullet Graph - A small, concise, easy to read replacement for guages.
  • Sparkline - A small and simple way to display trends in data.

View the 'Dashboard Controls' Screencast

Data Dynamics Reports - Section Page Numbering:

  • Detail Grouping
  • Report Sections
  • Page Numbering

View the 'Section Page Numbering' Screencast

Using charts to visualize sales data:

  • Chart Control
  • Chart Smart Panel
  • Chart Types
  • Chart Formatting

View the 'Chart Report Item' Screencast

Data Dynamics Reports Charts with Drillthrough:

  • Using Chart Data Value Actions to jump to another report.
  • Using Navigation Actions with a TextBox to jump back to the main report.

View the 'Chart Drillthrough' Screencast

Using the LocateDataSource event:

  • To populate report data in the designer at preview time
Using Xml Data Provider additons:
  • To populate reports with data from an Xml Web Service

View the 'UserDesignerControl.LocateDataSource & Xml Data Provider Additions' Screencast

Using Detail Grouping in a List Data Region.

  • Detail Grouping
  • Page Expressions
  • Interactive Sort

View the 'Detail Grouping' Screencast

Using the field selector:

  • Selecting fields in data regions
  • Selecting common expressions in the Page Header and Page Footer

View the 'Field Selector' Screencast

Demonstrates the use of master reports to provide a consistent look and feel across multiple reports.

  • Master Reports
  • Embedded Images

View the 'Master Reports' Screencast

An overview of the Matrix Data Region showing how to group sales by store and time period of sale.

  • Matrix Data Region
  • Connecting to a data source
  • Visibility Toggling
  • Adding Subtotals

View the 'Matrix Data Region' Screencast

Using Data Dynamics Reports with Visual Studio 2008 beta 2:

  • To populate report data using Language Integrated Query (LINQ)

View the 'Visual Studio 2008 Beta Support' Screencast

Data Dynamics Reports 1.5.905.0
New Features
  • 111195 - A new chart palette has been added that will use the accent colors from a report theme.
  • 115512 - AggregateIf now supports the DistinctSum aggregate
  • 116202 - The Excel export now supports subreports
  • 117657 - Banded list detail sections can now be conditionally hidden.
Fixed Issues
  • 109849 - Image are now split into parts when it spans several pages (HTML, Word)
  • 115315 - Resizing a report item using the middle left/right resize handle will no longer alter the height of the report item.
  • 116345 - Excel templates now contain the formatting found on a textbox, rather than using the runtime value of the textbox.
  • 116482 - When importing ActiveReports layouts, invalid property values for position and size are now ignored and reasonable defaults used.
  • 116979 - Containers with a transparent now render the contents beneath them.
  • 117357 - Margins on A4 paper are now properly set.
  • 117532 - The HTML Rendering Extension no longer cuts off text when a textbox has a large amount of text in it.
  • 117659 - Rectangles on the body using the ToggleItem or Hidden property now collapse space when required.
  • 117884 - Hidden lists are now not output when rendering a report to Excel.
  • 117940 - A Null Reference Exception is no longer is thrown when binding a Matrix to an empty data set.
  • 119343 - Using the FormattedText report item no longer causes issues in the windows forms viewer control.
  • 34553 - Designer performance has been increased a little when dealing with report items that overlap.
Data Dynamics Reports 1.5.866.0
Data Dynamics Reports 1.5.807.0
Data Dynamics Reports 1.5.750.0
Data Dynamics Reports 1.5.711.0