How to change the code

Tue, 29 Apr 2014 12:05:42 GMT

Hi All,

I have a QVW which will generate QVD on weekly basis.

now i need to change the master calendar to generate the QVd in Monthly basis. This is the master calendar we are using

LET tableloadStartTime=0;

SET vTotalRecordCount = 0;

Let NoOfDaysShift =0;

LET tableloadStartTime=Now(1);

if(WeekDay(today())<> 'Sat') and (WeekDay(today())<> 'Sun') Then

let NoOfDaysShift= num(WeekDay(today())*-1)-1;

ENDIF

IF (WeekDay(today())= 'Sun') Then

let NoOfDaysShift= -1;

ENDIF

let vExecDate = date(today()+$(NoOfDaysShift),'MM/DD/YYYY') ;

trace The date of execution is : $(vExecDate);

Let vToday = Today(1); // Custom Run

Let vToday_Num = num(floor(today(1)+$(NoOfDaysShift)));

According to this code QVW will run on Every Sunday in a week.

As per the First QVW which i have attached..

I need to run the QVW in Every sunday in a month ,

after the month end i need to show all the 4 or 5 weeks QVD data whcih is append to every week

if i run the QVW in any day in a month it has to generate the QVD.

Ex: if i run today it will load the QVD based on previous week sunday(i.e 26-4-2014)

like that after month end we need to show all the weekly data in month ..

Re: How to Do this

Tue, 29 Apr 2014 14:33:05 GMT

please help me ... i need it immediately

its_anandrjs — Tue, 29 Apr 2014 14:36:00 GMT

You can use task schedular for QVD making and triggered the QVD makers on particular date of month and also there is many options for the QVD makers.