ExpressPivotGrid Suite

概要 | 価格及びライセンス | 試用版とそのダウンロード | 互換性 | 開発元詳細 | 結果

拡大 [+]

ご案内：特に説明のない限り、この商品は英語版商品になります。
Add multi-dimensional data analysis to your applications. ExpressPivotGrid Suite was engineered to improve the way in which data-centric applications deliver information to end-users. With its powerful data architecture, the ExpressPivotGrid is able to slice and dice information efficiently and provide users with an extremely intuitive end-user experience. It delivers numerous layout customization options with total end-user control over each individual on-screen report. Regardless of the perspective, data can be rendered to answer business questions and it allows you to focus on business rules rather than creating dozens and dozens of reports.

一般向け価格については下記に表示されています。お客様用の割引価格をご覧になるには、ログインしてください。

ExpressPivotGrid Suite V2.49

すべてのご注文にて弊社標準の 契約条件および返品条件の内容が適用されます。 

一般向け価格については上記に表示されています。お客様用の割引価格をご覧になるには、ログインしてください。

What’s new in ExpressPivotGrid Suite V2?

• OLAP Data Source Support -You can now use the ExpressPivotGrid Suite to display OLAP cube data. To achieve this, simply bind your control to data via the newly-introduced TcxPivotGridOLAPDataSource component. Once bound, end-user report customizations will force server-side data recalculation, which allows you to analyze large amounts of data without affecting your application's performance.
• Visualizing Summary Data using Charts - ExpressPivotGrid v2 simplifies data analysis by allowing you to visualize summary data using charts available in the ExpressQuantumGrid's Chart View (sold separately). To display pivot grid data in a chart, you simply need to bind one control to another using a newly introduced component. By default, the chart displays all data from the pivot grid's current view. This works best when you have static views and fully control your report layout within code. If you provide dynamic views (i.e. allow end-user report customization) it's best to allow end-users to control which data portion should be visualized in the chart. By the enabling of multiple cell selection, your users can specify the data source for the chart by selecting an appropriate cell block.
• Obtaining Summary Data in a Standard Dataset - In addition to its new charting capabilities, you can now display the pivot grid's data in any data aware control. The new TcxPivotGridSummaryDataSet component transforms a pivot report into a standard dataset. For each data cell in a pivot grid, the control generates a record in the resulting dataset. A record will contain the data cell value, as well as appropriate column and row values.
• Obtaining Drill-Down Data -Previously, drill-down data sources could only be generated via code and could only be used with the ExpressQuantumGrid. In version 2, we've introduced an entirely new component that makes drill-down data management more flexible.
• Data Filtering Enhancements - The ExpressPivotGrid now provides end-users with an advanced Filter Editor dialog, Filter Panel and a most recently used filter criteria list, much like that found in the ExpressQuantumGrid.
• Cell Selection Enhancements - ExpressPivotGrid v2 allows end-users to select multiple cells blocks while pressing the CTRL key.
• Customizable Layout Persistence - Much like the ExpressQuantumGrid, the ExpressPivotGrid v2 allows you to specify how the control and individual field properties are persisted to external data stores. This is done via a set of specially designed events, which allow you to do the following:
• • Customize a list of properties to be saved.
  • Control property value save and restore processes.
  • Initialize pivot grid fields that are created during restoration.
  • Maximum and Minimum Value Indication
  • You can now easily highlight maximum and minimum values within a pivot grid control, or within individual columns and rows.

The ExpressPivotGrid Suite is a comprehensive data analysis, data mining, and visual reporting solution for Windows applications. It was engineered to provide a unique bridge between on-screen forms and printed reports. With it, your users can break down raw data in any manner they require using easy-to-understand Windows commands and instantly render the desired output to a printer. By incorporating the ExpressPivotGrid in your application, you can deliver an almost endless array of reports - both on-screen and in printed form.

Quickly Display Table Data into Fully Customizable Visual Reports

The ExpressPivotGrid Suite allows your end users to slice and dice data in a manner similar to that found in MS Excel. It has the power to convert hard to read and difficult to dissect dataset information into compact and summarized visual reports - making your applications far more usable and more effective at addressing your customer's real-time business analysis needs. And just as important, with the ExpressPivotGrid, users can easily change a report's layout visually in order to examine data from different/multiple perspectives. The benefits of this are two-fold - first, you never again have to foresee all possible report scenarios your end-users might require (saving you time and increasing your productivity) and second, your users will not have to deal with hard to use and overly complex reporting tools to answer their business questions.

Control the Level of Detail

By default, the row and column axes contain each unique value in the source column. With the ExpressPivotGrid, you can quickly simplify a report by merging values. For instance, you might have a report containing survey data in which the respondent's age represents an important characteristic. End-users may not want to browse through each and every unique age and instead want to see the ages of respondents in intervals such as 21-30, 31-40, etc. Instead of viewing sales by each unique date, they may want to view the sales for just the first few months. The axis can be customized in almost any fashion and the most common customizations need only a single property to be modified for its implementation.

Print and Render the ExpressPivotGrid with Ease

The ExpressPivotGrid is not just about on-screen data analysis. With it, you can export data to numerous formats and render its contents to paper just like a traditional WYSIWYG report.

Printing support is available via the ExpressPrinting System (must be purchased separately). This allows you to create cross-tab reports easier than ever before. 

• Export to the XLS, XML, HTML and TXT formats
• Multi-cell selection and data export via the clipboard

Arrange Values Hierarchically - See Raw or Summarized Data in a Single Report

Businesses have unique requirements and no two entities will analyze information in the same exact way. Your end-users may want to analyze sales for each product or each product category. They may want to view yearly data or see more detailed data by viewing the data for each month in a year. Using traditional reporting/database tools, you would often be forced to create a myriad of different reports to deliver the appropriate solution to your customers - but that's no longer the case with the ExpressPivotGrid. Since the visual control offers your end-users total runtime customization flexibility, not a single report layout needs to be modified to view data at different detail levels. You simply place fields at lower detail levels on the column or row area. Field values are automatically arranged into a tree structure with expandable parents. End-users are free to expand and collapse child groups to see more summarized or raw reports.

Automatic and Manually Specified Totals

To improve the development experience, the ExpressPivotGrid ensures your ability to deliver superior capabilities with minimal coding. Among the many features available in the component library is its ability to display grand totals for each row and column automatically. On the rare occasion that the built-in summary computation engine does not address a specific business requirement, you can display any number of totals for any value group.

Sort Data and Display Top Rows - Easily Access the Most Important Information

The ExpressPivotGrid automatically sorts row and column values so you can easily locate required data. Comprehensive data analysis, however, often requires a two-way approach to data navigation in that you may need to find data by a specific value or find a value by its data. To allow for the latter approach, the ExpressPivotGrid introduces a unique feature - sorting values by their corresponding grand totals. This means the product you'll see first is not the one which starts with an A or Z, but rather the one that has the most or least sales. This of course is just the beginning to more effective and efficient data analysis. You can also specify the number of top rows that are displayed. So you can view a specific number of best-selling or worst-selling products for each year, month, customer, etc. You can concentrate on only the most important information and avoid being overload with a lot of surplus data.

Filter Data - Filter Out the Values Used to Calculate Summaries on the Fly

You will find that with its built-in visual filtering option, your end-users can manipulate reports on the fly using an easy to understand and familiar visual metaphor.

Hide unnecessary values in the axes

Yet another mechanism that allows end-users to focus only on the most important data. 

Filter the data against which calculations are based

To allow your end-users manage this capability visually, the ExpressPivotGrid has a Filter Panel Region. This pane was specifically designed to contain fields that aren't currently used in the report, and when required, can be dropped onto the report to automatically alter the base data used in the calculations. 

Drill Down - Take a Look at the Data Behind a Summary

The ExpressPivotGrid is designed to transform table data into a summarized report. At the same time, it allows you to do the reverse. With just a single line of code, you can take a look at the records that were used to calculate cell values.