Dear Sir,
I want to see report on every first day of the following month and same report shall be auto run from job queue.
Example- Report to be auto run on 1stJan,1st Feb, 1st March………….like that
Report run on 1st Jan- Data should be between 1st Dec to 31st Dec.
For 1st Feb- Data should be between 1st Jan to 31st Jan.
I have write the below code:
{
//dtstart:=CALCDATE('-1W',TODAY);
//dtend:=CALCDATE('+1W',dtstart);
//dtstart:=CALCDATE('<-1M>',TODAY);
//dtend:=CALCDATE('<+1M>',dtstart);
StartDt:=EVALUATE(CALCDATE('<-1M>',TODAY));
dt1:=CREATEDATETIME(dtstart,0T);
dt2:=CREATEDATETIME(dtend,0T);
SETFILTER("Creation Date Time",'%1|%2',dtstart,dtend);
}
StartDt:=DT2DATE("Dimension Value"."Creation Date Time");
IF "Dimension Value".FINDSET THEN
BEGIN
// REPEAT
txtData[1] := FORMAT(txtRNDType);
txtData[2] := FORMAT("Dimension Value".Code);
txtData[3] := FORMAT("Dimension Value".Description);
txtData[4] := FORMAT("Dimension Value".Name);
txtData[5] := FORMAT("Dimension Value"."Budgted Amount");
txtData[6] := FORMAT("Dimension Value"."Master Project No.");
txtData[7] := FORMAT("Dimension Value"."Enquiry No.");
txtData[8] := FORMAT("Dimension Value"."Project Title");
txtData[9] := FORMAT("Dimension Value".Timeline);
txtData[10] := FORMAT("Dimension Value"."Expected Date");
txtData[11] := FORMAT("Dimension Value"."Extended Date");
txtData[12] := FORMAT("Dimension Value".Blocked);
//UNTIL("Dimension Value".NEXT=0);
END;
