Chart It - About

Displaying Sql Server Databases
Multi Dimensionally, thru Charts and Grids

Show Sections Hide Sections

Chart It/(MDAccess) Example Charts

Chart It - a Multi Dimensional Database Reporting Application

Chart It is the Web version of MDAccess. Chart It displays data from Sql Server databases accessible over the internet in a Multi Dimensional form thru Charts and Grid Reports. It provides easy access and manipulation of selected subsets of that data in a flexible, easy to use manner.

Chart It reports directly from Sql Server Tables or Views.

Chart It Intro Video

Features offered by Chart It include...

  1. Predefined Data Sources
        - user accounts can have their data connection strings predefined with login.
  2. Dynamic Data Source Selection
        - data sources can be accessed dynamically thru the use of a connection string.
  3. Flexible Element Selector
        - allows for easy selection of database subsets quickly showing available data in subsets selected.
  4. Multi Select Element Selector
        - allows for data to be constrained to multiple values on one field.
  5. Seamless Chart Type Conversion
        - allows for easy change of one chart type to another.
  6. Easy Axis Rotation
        - allows for easy data view alteration.
  7. Calculations
        - allows % of Chart Group and % of Chart Page as calculations.
  8. Multi Page Charts
        - allows for easy arrangement of multiple pages of a chart within one chart space section. Each page differs by its selection on the 'Page Dimension'.
  9. Multi Charts
        - allows for multiple Charts to be defined and positioned.
  10. PreSets
        - allows for easy Save and Restore of Data Source, Data Selection, and Chart and Grid Parameter settings.
  11. Excel Export Functionality
        - provides for easy export of data to Excel.
  12. Print Preview
        - allows printing of Chart(s) to a printer.
  13. Same Scaling across Multiple Page Charts
        - optionally allows auto-scaling across any number of pages in a 'Multi Page Chart'.
  14. BiScale Charting
        - optionally allows selected data to be charted according to two separate scales.
  15. Separate Chart and Grid Displays
        - Charts and Grids are displayed and controled thru two different panels and sets of parameters.
  16. Trend Lines
        - shows average trends that can be displayed across time.
  17. Flexible Sorting
        - allows for sorting of Chart Pieces, Chart Groups, by Element Titles or Data Values.

plus many more...

Chart It Parameter Selection...

Chart It parameter selection is separated into the following Groups:
  • Login

        - allows the user to login to their account using the predefined database connection string (if option has been predefined).

  • PreSets

        - PreSets allow the user to save and restore current parameter selections for future display.

    To create a Chart or Grid in Chart It, one has to specify:

    1. Connection String to a Database
    2. Table (or View) in Database
    3. Fields in Database (to select from)
    4. Values in Fields to select
    5. Fields that are Measures
    6. Chart Parameters
    7. Grid Parameters

    When this is done, a Chart and Grid will display. This set of selections can then be saved in a database in what is called a 'PreSet'. The 'PreSet' has a Title, and can be selected by its Title for redisplay at any time after it has been created. Doing this saves the user the time of reselecting and respecifying all the parameters that were needed in order to originally display this PreSet.

  • Data Source

        - data source connection string can be predefined and used by selecting the radio button 'Use Login Connection String' or
        - user can enter a new connection string in the 'Connection String Textbox' and select the radio button 'Use Connection String'.

    Once the Data Source connection to a Database has occurred, the user can select the Database Table or View to report from.

  • Database Table or View

        - the Database Table or View provides the data that is the basis of the report. (A View can be constructed by linking several Tables.) This Database Table or View contains the columns that become: Selection Fields, Measure Fields, and Database Dimensions in the Chart or Grid.

  • Selection Fields

        - allows the user to select fields that can be used to constrain the data to a subset of the database data to report from.

  • Selection Values

        - after the selection fields have been made, user can select the data values to constrain the data to.

        When a Selection Field Value has been selected, the other Selection Fields (if any) have their available Values reduced to what is available in the new subset.

    Multi-Select allows the user to select multiple values in a Selection Field to constrain the data to.

  • Measure Fields

        - When a Chart or Grid is constructed, a numeric field has to be used to display the data quantity. The available Binary fields (numeric data fields) in the Data Source Table or View are used for this. A new Data Source field is made available for each existing Binary field in the Data Source by taking the name of the original Binary field and appending a 'Sum_' to the Binary field name. If these 'Sum_' Binary fields are selected, they are added to a new Dimension called 'Measures'. If no 'Sum_' fields are selected, the first 'Sum_' field is automatically selected when a Chart or Grid is constructed. If no 'Sum_' fields are available, a Chart or Grid cannot be made.

    When a Chart or Cross Tab Grid is constructed and the 'Measures' Dimension is associated with a Chart or Grid Axis, the selected Measure Field Element Titles are displayed on that Chart or Grid Axis, and data values for those 'Sum_' fields are correspondingly displayed.

    If the 'Measures' Dimension is not associated with a Chart or Grid Axis, then the first 'Sum_' selected is used to display the data values.

  • Chart Parameters

    Each Chart contains parameter specifications for the following:

    • Calculation - Data Value, or % or Chart Part
    • Chart Axis Associations - displays existing values in the data subset on the associated Axis.
    • Sort Parameters - by Title or Data Value
    • Trend Line option
    • Chart Type
    • Legend Location
    • Chart Group Titles Direction
    • Tabular Number Display option
    • Color Palette
    • Chart Size
    • Color Palette
    • Margin
    • 3D
    • Tabular in Chart Piece Color
    • Fill Type
    • Multi Page Chart Parameters
    • Same Scale - create common scale over all Chart Pages
    • BiScale Parameters - Second scale is created for last item of selected Axis (except for Stacked Chart Types)

    The 'Add a Chart' option allows the user to create Multiple Charts within the Chart space. 'Multi Chart' differs from 'Multi Page Chart' in that 'Multi Chart' has one set of parameter specifications for each Chart. Each Chart (in a 'Multi Chart') displays one Chart, each in its own section of the Chart space.

    A 'Multi Page Chart' is one set of parameters with one Chart space section, that displays multiple pages from the same Chart. Each page in a 'Multi Page Chart' is a different selection value on the 'Page Dimension'.

  • Chart

        - Creates or Prints Chart for the current selection of parameters.

  • Cross Tab Grid Parameters

    The Cross Tab Grid Report has the following parameters:

    • Calculation - Data Value, or % or Grid Part
    • Grid Axis Associations - displays existing values in the data subset on the associated Axis.
    • Sort Parameters - by Title or Data Value

  • Cross Tab Grid

    Allows the following options:

    • Creates Grid for the current selection of parameters
    • Displays Grid in separate window for Printing
    • Download Grid to Excel

    The Cross Tab Grid uses all Measures selected if the 'Measures' Dimension is associated with a Report Axis, otherwise it uses the first Measure selected.

  • Columnar Grid Parameters

    - Select the SubTotal Break Fields that sums should be created for.
    - The Columnar Grid Report sums the Selected Measure Fields for every unique combination of values in the selected SubTotal Break Fields.
    - The available SubTotal Break Fields are the fields in the DataTable or View.

  • Columnar Grid

    Allows the following options:

    • Creates Grid for the current selection of parameters
    • Displays Grid in separate window for Printing
    • Download Grid to Excel

How to Use

  1. Create a (Free) account on the Chart It Purchase Page.
  2. Login to Chart It.
  3. Define a Database Connection String on the 'Database Connection' Page.
  4. Create Charts and Reports on the 'Chart It' Page.