Selecting and filtering data

On this page we will show a number of common ways to select and filter data in reports, models, and imports.

  • With selecting, we mean that you specify criteria when you run a report. These can be static (always the same value), or dynamic (for example, selected by users when they run a report). These critera determine the contents of the report.
  • With filtering, we mean that you can interactively filter the data within a generated report. By enabling or disabling values you can slice and dice through the information without having the re-run the report. Filtering in XLReporting is interactive and super fast.

You can also watch the tutorial video.

Static selections

If you always want limit the data in a report on the same critera, you can simply enter the static value(s).

BETWEEN("2019-07", "2019-12")

screenshot account convert filter data

Dynamic (user) selections

In many cases you want to enable the user to select critera when they run a report or import. For example, the company they want to import, or the period for which they want to run a report. You can achieve that with the SELECT() function. See the detailed description of this function.

screenshot define import columns select

A special variant of this is the SELECTPERIOD() function. If you use this function in combination with the PERIODSUM() function, you can build powerful and dynamic period-discrete and year-to-date calculations with just a few clicks. See the detailed description of this function.

Filter data

To filter data in your report, or on screen, simply select a value from any of the dropdowns at the top of the screen:

screenshot filters data columns

This only filters data visibly on your screen, not in the database.

We value your privacy

We use cookies to enhance your browsing experience and analyze our traffic.
By accepting, you consent to our use of cookies.

Accept Reject Cookie Policy