May be this:
Data: LOAD * WHERE Date(Date) >= MonthStart(Today()) AND Date(Date) <= MonthEnd(Today()); LOAD * INLINE [ Date, Sales 01/04/2017, 123000 02/04/2017, 456000 03/04/2017, 789000 04/04/2017, 123400 05/04/2017, 789100 06/04/2017, 123450 07/04/2017, 789120 08/04/2017, 123456 09/04/2017, 789123 ];
let assume we have a qvd file which having total data of last five years.
In report we are loading total 5 years data.
In filter panel can we set such that it will list only current month data when i am opening the report.
Assume that i have datarange picker extension in my report.
it has to list the current month data by default.