Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have report with last five year of data.
It is taking much time while loading the report.
Instated of total data, can we put a filter for the current month data only need to be populated in the report.
we have filter in the report like year and month.
write the where condition in script like
where Date>='01-jun-2017' ;
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 ];
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
];
Regards!
Rahul Pawar
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.
