ActiveBI Suite for .NET
Report on and explore relational and multidimensional data.
Publicado por MESCIUS (formerly GrapeCity)
Distribuido por ComponentSource desde 1996
Report on and explore relational and multidimensional data.
ActiveBI Suite for .NET includes ActiveAnalysis and Data Dynamics Reports. Data Dynamics Reports integrates into Web and Windows Forms applications and provides a rich API with which to create and modify reports. Features include: master reports, additional chart types, banded list data regions, barcode report items, formatted text report items, themes and data visualizers. Documents created with Data Dynamics Reports can layout data using a combination of lists, tables, charts, matrices or banded lists in a layout-based report. Reports can be populated with data from an ADO.NET DataSet, .NET Object, SQL Server, Oracle, OLEDB, ODBC, or an XML data source. ActiveAnalysis (formerly Data Dynamics Analysis) is a complete OLAP, data visualization and Business Intelligence component for Silverlight, Windows Forms and ASP.NET that allows you to rapidly embed interactive, ad hoc Business Intelligence features for both Windows and Web applications.
ActiveAnalysis - Features and Benefits
ActiveAnalysis - Out-of-the-box functionality saves time
Thanks to the out-of-the-box features and the built-in user interface in ActiveAnalysis, you can develop and deploy a full-blown Business Intelligence solution with interactive OLAP and data visualization features without writing a single line of code.
ActiveAnalysis - Silverlight, Windows Forms, and ASP.NET support ensures a rich user experience whether on Windows or the Web
ActiveAnalysis supports Microsoft Silverlight, Windows Forms and ASP.NET. That means you can provide the same rich user experience in your Web applications that would normally require a Windows application, all in one convenient package.
ActiveAnalysis - Combines charts and pivot tables into one powerful data visualization component
Unlike some OLAP and analysis products that are either primarily pivot tables or primarily charts, ActiveAnalysis goes beyond these limitations. We grasp data at its fundamental level and deliver a single component that offers a wide array of data visualization capabilities. With the click of a button, you can turn a cross-tab pivot table into a trellis display of feature-rich charts and turn it back with another click.
ActiveAnalysis - Interactive, drag-and-drop user interface accelerates discovery of data trends
No matter what industry you are in, ActiveAnalysis will allow your users to find new trends in their data. A single connection can generate thousands of chart variations with simple mouse clicks. Each view gives users a different perspective on their data. They can tell a different story using the same data by reorganizing field layouts. With the right perspective, new data findings appear that may have otherwise gone unnoticed.
ActiveAnalysis - Microsoft Excel export allows users to share analysis results offline
Allow your users to take the analysis they perform within your application and put it into a format that they can use. Excel exports allow them to perform additional analysis and what-if scenarios, and to share the results with people who do not have access to the data.
ActiveAnalysis - Data binding without limits allows users to analyze a wide range of data
ActiveAnalysis works with a wide range of data types, including both structured and flat data, and works in both connected and disconnected modes. For easy setup, we include several data source controls that help bind to the more common data sources such as SQL Server, MySQL, Oracle, Microsoft Access, Microsoft Excel, Xml, DB2, and Microsoft SQL Server Analysis Services. You can even use an included utility to create an XML file that models flat data into a multidimensional format for a full OLAP analysis experience. If you can get access to your data in code, then ActiveAnalysis allows your users to explore it visually.
ActiveAnalysis - Modular user interface that is easy to customize
ActiveAnalysis allows you and your users to display, reposition, or hide any aspect of the user interface with dockable cards. This feature not only allows for a customized experience for each user, but also fully encapsulates the user interface logic within the component itself. You can save card layouts to disk or memory, and reload them at any time.
ActiveAnalysis - Built-in toolbar gives end users access to data visualization features
In addition to the drag-and-drop user interface, most of the ActiveAnalysis functionality is accessible using the built-in toolbar. This allows developers to get up and running with a full data analysis solution in no time at all. You can hide the toolbar using the design-time Properties grid or at run time with a single line of code.
ActiveAnalysis - Powerful built-in data filters for fast analysis
Filtering data is an essential element of any data analysis experience. ActiveAnalysis is built to ensure that every conceivable way to filter data is available by default with no configuration necessary. Simply place the control on a Windows Form, a Silverlight form or an ASP.NET Web form, add data, and your users are immediately able to begin drilling into their data and filtering results to show only the data that are most important to their analysis goals.
ActiveAnalysis - Continuous mode allows easier analysis of numeric and date-based data
Continuous mode makes it easier to deal with numeric or date-based attributes, easily spot gaps in data, and view a larger data set without scrolling, thus revealing trends that would otherwise be hard to find.
ActiveAnalysis - Data summarization feature displays key statistics to aid understanding
ActiveAnalysis users can highlight a selection of data points and watch various aggregate results appear on the Summary Card. This feature gives detailed analysis of dynamic displays, and makes it easy to determine what values make up major outliers.
ActiveAnalysis - Aggregate and underlying data views enable top-down and bottom-up analysis
ActiveAnalysis users can highlight a section of data and use the built-in context menu to view aggregate and underlying data. They can then select this data and copy it to the clipboard to paste into any application that accepts tab-separated data.
ActiveAnalysis - Paging and slideshow features help analyze data changes over time
ActiveAnalysis provides paging to help in visually analyzing data changes over time by displaying each time interval as its own page. Users can either manually switch between pages or use the slideshow feature to turn the pages automatically.
ActiveAnalysis - Numerous ways to rank and sort data
With the built-in context menus in ActiveAnalysis, users can sort their data in many different ways. They can sort and rank members in ascending or descending order, by caption, key or any field they select. When the user applies sorting to a field, a sort indicator displays on the field to remind them that a custom sort operation is set.
ActiveAnalysis - Undo and redo capabilities encourage iterative analysis and save development time
When your users are analyzing data, they are looking for undiscovered patterns, for insight. In order to support this fast analytical thinking, ActiveAnalysis provides the ability to undo any changes made to the view. This allows them to revisit previous results at any time. Having this built right into the component saves hours and possibly weeks of development for such support.
ActiveAnalysis - Restrict user interface functions by user role with the permission-based security model
With ActiveAnalysis, you can restrict which users can do what within the PivotView user interface. For example, you can globally disallow sorting, filtering or other user interface functions. Or you can associate these permissions with user roles in your application to restrict groups of users to specific user interface operations.
ActiveAnalysis - CSS-like styling to easily change look and feel without recompilation
ActiveAnalysis offers a robust themes engine that lets you create the look and feel that you want. Control the look of each aspect of the view using a CSS style approach. The product ships with many pre-built themes like Office 2007, Windows Classic, Windows Vista, and more. Configuring your own style is as easy as modifying an XML file, CSS file, or XAML markup and does not require a full recompile of the hosting application.
ActiveAnalysis - Easy printing of data analysis results
Users can share their results by using the ActiveAnalysis print preview and print features. All of the presentation data are sent to the printer as well to help describe the resulting view, including the various legends, the title, and the description text.
ActiveAnalysis - Easy deployment via Save and Load capabilities, with no runtime royalties
ActiveAnalysis features robust deployment architecture with no run-time royalties. You and your users can save and load various aspects of the view such as layouts, permissions, card configurations, data, and styles without ever recompiling the hosting application and at no extra costs.
ActiveAnalysis - Layouts
Save data layout configurations to XML and you can load them later to refresh the view with the latest data. When you save layouts, an optional flag allows you to save them with data. This lets you send layouts to business users who do not have access to the data source.
ActiveAnalysis - Card Settings
Save and load card layouts so that each user can customize the application to fit their needs.
ActiveAnalysis - Permissions
Easily load permissions at design time with a checked list of permission settings. At run time, it's as easy as loading a saved XML file.
ActiveAnalysis – Styles
Style the Pivot View to fit seamlessly into your existing Silverlight, Windows Forms and ASP.NET applications with the endlessly configurable user interface.
ActiveAnalysis - Data Source
Most analysis solutions can connect to multiple data sources with the same database schema. ActiveAnalysis enables layout files to persist the data source information with the layout file, ensuring that the layout always uses the specified data source. Alternatively, omit the data source information to allow the current layout to run against an older version of the database for historical analysis.
Data Dynamics Reports has all of the features found in RDL and has added several enhancements:
Rendering extensions are more than just an export, they render the report using the underlying layout of the report. This means that each report item can be rendered in a way that makes sense for that rendering extension. Rendering extensions available:
Data Dynamics Reports includes several controls that you can ship with your applications:
Data Dynamics Reports is not a replacement for ActiveReports for .NET. The goal behind creating Data Dynamics Reports is to create a reporting product in which users need not write code to create most basic reports.
What are the main differences between Data Dynamics Reports and Active Reports for .NET? Briefly, Data Dynamics Reports supports multiple data sources, data sets, and several different data regions. It also supports the use of VB.NET expressions to set properties. These expressions control the entire report generation process and replace the event handlers fired from within ActiveReports for .NET.
Expressions - With ActiveReports for .NET, if you want to set the color of a TextBox at run time based on its value, you have to write an event handler like the following:
private void detail_Format(object sender, EventArgs e)
{
if ( ( (double) textbox.Value) < 0.0 ) {
textbox.ForeColor = Color.Red;
}
else {
textbox.ForeColor = Color.Black;
}
}
In Data Dynamics Reports you instead use expressions- snippets of inline VB.NET code that when executed return the value desired. The expression to duplicate the event handler earlier would be written like so:
=IIF( Fields!field.Value < 0, “Red”, “Black” )
Multiple Data Sources/Data Sets - Each report can have multiple data sources and data sets associated with it. A data region and its children can only be associated with a single dataset. If multiple data sets are needed within a data region a subreport can still be used to link in the second data set. However, in most cases a data set that contains the join of both sets of data could be used.
Drilldown - Data Dynamics Reports has true drilldown support, that allows report authors to hide data conditionally in the report and expose it when requested. This is done by setting a report item to be hidden and then setting its ToggleItem property to the name of a textbox or image report item in the report.
Data Regions - A data region is a how a set of data is manipulated to be output by various report items (if needed). The List data region outputs itself once for every row of data in the data set or unique set of grouping expressions. The Banded List functions very similar to how a report in ActiveReports for .NET works. The Chart data region contains the same charting technology used in ActiveReports, but it has been updated to work with the Data Dynamics Reports ideas of a data set and expressions.
Nested Data Regions - In ActiveReports for .NET it is possible to add a chart to any section of the report, but that is the limit of nesting a data region. In Data Dynamics Reports data regions can also be added within data regions that accept report tiems, as long as the data is grouped. The ability to nest data regions means that report authors don’t have to resort to using subreports which incur additional processing overhead that should be avoided if possible. A standard usage is to nest another data region within the List data region when it has detail grouping set. This set up allows the summary data to be output in the outer List while details are output in the inner List. Another usage is to take advantage of the grouping construct of the Matrix data region. This allows the report author to create a trellis display of charts, tables, or lists.
Matrix (Crosstab) - Data Dynamics Reports also features a matrix data region – sometimes called a crosstab or pivot table. This data region consists of a grid that adds columns and rows for distinct sets of field values in the data set. Many products exist for the same premise, to group data in n-ways and look at the data comes out. Each row or column group in a matrix can optionally have a subtotal column/row as well. This works by taking the same expression in the data cell and expanding its scope to include all of the data in that group.
Table - Data Dynamics Reports offers a Table data region which simplifies the positioning and sizing of report items in a grid format. The designer makes it easy to set gridlines on the table as well.
Data Dynamics Reports Frequently Asked Questions
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:
Features available only in ActiveReports for .NET include:
Special Data Dynamics features in both products include:
Question: What are the differences between Data Dynamics Reports and Microsoft SQL Server Reporting Services 2005?
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.
Question: What is the Report Definition Language and why do I care that Data Dynamics Reports supports it?
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:
Data Dynamics Reports and Microsoft SQL Server Reporting Services are just two products that implement the RDL 2005 specification.
Question: Does Data Dynamics Reports require Microsoft SQL Server Reporting Services?
Answer: 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.