Phone - Australia: 1300 553 313
Hotline - New Zealand: 0800 450 168
ComponentOne Logo

OLAP for WinForms

Easy to Use Pivot Grids and Charts for Instant Data Analysis

Discover new trends and drive efficiency with essential data analysis and charting. Rather than summarising data in spreadsheets, which can be tedious, repetitive, and error-prone; make ComponentOne OLAP for WinForms your business solution. These controls provides analytical processing features similar to those found in Microsoft Excel Pivot Tables and Pivot Charts. With drag-and-drop views, you get real-time information, insights, and results in seconds. Only available as part of Studio for WinForms, Studio Enterprise or Ultimate.

OLAP for Windows

OLAP at-a-glance

  • Code-free analysis for any data source
  • Subtotals and grouping
  • Run-time filtering and conditional formatting
  • Export and print reports
  • Charts with six different chart types
  • Undo/Redo history
  • Modeled after Microsoft Excel


OLAP for WinForms Features and Highlights

  • Save Time and Deliver Endless Views for Users

    Deliver endless views to end users without writing or re-writing code. Typically when a user needs a new report they ask the developer to make one. With an OLAP solution they can build the report themselves and save it for future runs of the application. ComponentOne OLAP saves developers time while giving more power to the end user.
  • Code-free Data Analysis

    To create the simplest OLAP application, just create a new Windows Forms application, drop the C1OlapPage control on the form, and connect to a database. It's that easy. Run your application and go.
  • Drag-and-drop Views

    Easily create data views by dragging a field into the list. This will give you a summary of your data. You can also summarise your data by modifying the parameters.
  • Subtotals and Grand Totals

    The Olap Grid automatically calculates grand totals for each slice of your data. If you measure multiple dimensions the OLAP Grid can also calculate subtotals with collapsible headers.
  • Multiple Value Fields

    You may add as many value fields to a view as you want. This enables users to aggregate totals for multiple measures from the data set. For example, create a view that compares both total revenue and cost side-by-side.
  • Conditional Formatting

    Simple properties make it easy to apply conditional formatting to the C1OlapGrid. Conditional format thresholds may be specified as absolute values or as percentages. Make certain values stand out to draw attention. For example, apply a unique style for values in the top 10% and another style for values in the bottom 10%.
  • OLAP Charts

    The C1OlapChart control is used to display OLAP charts. It supports five different chart types (Bar, Column, Area, Line and Scatter), automatic tooltips, stacking and palette selection.
  • Reports are a Click Away

    Effortlessly print and email reports. The C1OlapPrintDocument component is used to create reports based on OLAP views. It extends the PrintDocument class and provides properties that allow you to specify content and formatting for showing OLAP grids, charts, and the raw data used to create the report. There's a convenient "Report" button that previews your data in a built-in report. You can change the page orientation, and print the report or export to PDF.
  • Filtering

    To narrow down the data analysis, use the filter feature. You can filter on multiple fields. Just right-click on the field you would like to filter and select Field Settings. From the Field Settings dialog box, you can create your custom text filter. No coding required.
  • Totals and Aggregates

    Choose from many different aggregations for the totals (Value field). Choose from Sum, Count, Average, Maximum, Minimum, First, Last, Variance, Standard Deviation, and Variance Population.
  • Data Formatting

    Format the value field in the Field Settings dialog. Select from decimal, currency, and percentage formats; or create custom format strings.
  • View Underlying Records

    You can see the underlying records behind each cell in the OLAP grid by right-clicking the cell with your mouse pointer.
  • Data Transferrable to Excel

    You may want to copy some or all the data to Excel so you can perform additional data analysis including regressions, create customised reports by annotating the data, or adding custom charts. The C1OlapGrid control supports the clipboard by default, so you can simply select the data you are interested in, press CTRL+C to copy the data, and then paste it directly into an Excel sheet. The row and column headers are included with the data.
  • Save and Load Views

    ReadXml and WriteXml methods allow you to persist views to files and streams. These methods make it very easy to implement predefined views and expose them in a menu so your end-user can select them.
  • Customisable User Interface

    OLAP for WinForms exposes most of the components it contains, which makes customisation straightforward. You can add, remove or change the elements from the ToolStrip, from the TabControl, and show status messages using the LabelStatus property. You can also add other elements to the page in addition to the C1OlapPage.



For more information please contact the MicroWay sales team: buynow
Head Office
MicroWay Pty Ltd
PO Box 84,
Braeside, Victoria, 3195, Australia
Ph: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
Sydney Sales Office
MicroWay Pty Ltd
PO Box 1733,
Crows Nest, NSW 1585, Australia
Tel: 1300 553 313
Fax: 1300 132 709
email: sales@microway.com.au
ABN: 56 129 024 825
New Zealand Sales Office
MicroWay Pty Ltd (NZ)
PO Box 912026
Victoria Street West
Auckland 1142, New Zealand
Tel: 0800 450 168
email: sales@microway.co.nz

International: call +61 3 9580 1333, fax +61 3 9580 8995

© 1995-2023 MicroWay Pty Ltd. All Rights Reserved. Terms and Privacy Policy.