How my report can show automatically the last 6 months?

[Anonymous]

Hello Comunity,

I have built a report which shows company expenses. This report is connected with MySQL database, the data connectivity type is import (not direct query) and every month the new monthly expenses data are added to the report.

We need to set automatically to show the last 6 months, so every time when a new month is coming in the system should take it into acount with the 5 previous months so we can have the last 6 months in the report. Additionally, when the user wants to see any data before the last 6 months, he can do it manually choosing the time period he wants to see. 

Can you please support on how to do this?

[quentin_vigne · Accepted solution]

Hi @Anonymous

You need to apply a relative date filtering as shown below

The simplest solution is to create 2 pages on your report. One where you filter on the last 6 months and the other one where the end user can select the time period he wants.

Quentin