logo
small logo
  • Products
  • Buy
  • Support
  • About
  • Customer panel Support
    • en
    • de
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to use filters and sorting options in FastCube VCL
  • FastCube - High-Speed OLAP Cube Engine and Pivot Grid

    February 29, 2020

    It is difficult to imagine data analysis without OLAP (On-Line Analytical Processing) technology. Although there

    read more
  • How to create a ZPL file in Delphi/ C++ Builder/Lazarus

    December 22, 2020

    What is a ZPL file? ZPL stands for Zebra Programming Language. It allows team to

    read more
  • How to use FastCube .NET in the SPA application Knockout.js

    July 21, 2021

    To output the data cube, we will create a SPA application by means of Knockout.js

    read more
  • Web reports in Lazarus on Linux

    December 15, 2020

    Until recently, the task of generating reports through the Web from an application written in

    read more
  • How to print business cards from a Delphi application

    August 24, 2020

    Applications built in Delphi are less common than, for example, those built in C #.

    read more

How to use filters and sorting options in FastCube VCL

October 6, 2021

FastCube VCL

Data filtering is essential when working with information. It is difficult to imagine analytical tools without this option. Most often, filters and sorting are used for:

  • quick access to data;

  • making data user-friendly;

  • convenient editing of data;

  • structuring information.

FastCube VCL Dialog Box

You need to use the Measure tool to work with filters in FastCube VCL. Once you left-click it, you will see the following window:

List of indicators

Here you can control the displayed data using the buttons at the bottom.

FastCube VCL - display all measures;

FastCube VCL - remove all measures;

FastCube VCL - reverse the order of the displayed and not displayed data;

FastCube VCL - move the measure one level up;

FastCube VCL - move the measure one level down;

FastCube VCL - accept changes.

The screenshots below show how the buttons for moving columns up and down the list work.

How to use the function to move columns by levelsHow to use the function to move columns by levelsHow to use the function to move columns by levels

It is also possible to apply filtering via the measures menu. To do this, right-click on the item you want to filter and select “Filter out this item” or “Filter out all other items”. The item you need will be filtered.

Filtering

Now we are going to create a filter by condition. Right-click on one of the items in the field list and select “create a custom filter”.

Range editor

The custom filter can be configured in the range editor. It can include several items, as in the example below.

Multiple item filter

You need to click on the measure editor button to filter aggregation items by indicator.

Item edit button

This screenshot shows the “general” window, where filtering will be applied only for one aggregate item. In this case, it will be the “sum” item.

Dialog box

Now you know about filtering and sorting options available in the FastCube VCL analytical environment.

about product buy
avatar
Dmitriy Fedyashov
Technical Writer
Fast Reports Team: Dmitriy Fedyashov - Technical Writer at Fast Reports
VCL FastCube Filtering

Add comment
logo
  • 800-985-8986 (English, US)
  • +4930568373928 (German)
  • +55 19 98147-8148 (Portuguese)
  • info@fast-report.com
  • 901 N Pitt Str #325 Alexandria VA 22314
  • Buy
  • Download
  • Documentation
  • Testimonials
  • How to uninstall
  • FAQ
  • Tutorial Video
  • Forum
  • Support SLA
  • Articles
  • Our News
  • Press about us
  • Resellers
  • Extended licensing
  • Contact us

© 1998-2023 by Fast Reports Inc.

  • Privacy Policy

Trustpilot