logo
small logo
  • Products
  • Comprar
  • Suporte
  • Articles
  • Customer panel Suporte
    • en
    • pt
    • es
    • de
    • pl
    • JP
    • ZH
  • Home
  • /
  • Articles
  • /
  • How to use filters and sorting options in FastCube VCL
  • O que é FastCube e para que serve?

    29 de fevereiro de 2020

    É difícil imaginar análise de dados sem a tecnologia OLAP (On-Line Analytical Processing). Embora existam

    read more
  • Como imprimir cartões de visita a partir de um aplicativo Delphi

    24 de agosto de 2020

    Aplicações construídas em Delphi são menos comuns do que, por exemplo, aquelas construídas em C#.

    read more
  • Como usar o FastCube .NET com a aplicação Vue SPA

    14 de abril de 2021

    O framework Vue.js é atualmente muito popular, e, está em alinhado com o Angular. Já

    read more
  • Como usar o FastCube .NET em conjunto com SPA Angular

    19 de abril de 2021

    Uma das estruturas mais populares para a criação de aplicativos de página única é a

    read more
  • Como proteger seu PDF?

    30 de novembro de 2020

    No dia da proteção de dados, decidimos preparar um artigo sobre a proteção de documentos

    read more

How to use filters and sorting options in FastCube VCL

6 de outubro de 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 download comprar
avatar
Pavel Ishenin
OLAP Development
Fast Reports Team: Pavel Ishenin - OLAP Development 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
  • Comprar
  • Download
  • Documentação
  • Depoimentos
  • Como desinstalar nossos produtos
  • Ticket system
  • FAQ
  • Tutorial Video
  • Forum
  • Articles
  • Our News
  • Informação sobre nós
  • Parceiros
  • Contatos

© 1998-2022 by Fast Reports Inc.

  • Privacidade