387
Dear Experts,
In my customize report, find the data from last one month based on creation date and time field and send by job queue on every first day of current month..
Please suggest me the best to apply it.
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;
Which table are you using for your report? and how are you applying the filter? Provide more details.
I found a blog that covers this. Here it is:
www.archerpoint.com/.../how-add-report-filters-dynamics-business-central-or-nav
#1
André Arnaud de Cal...
292,516
Super User 2025 Season 1
#2
Martin Dráb
231,407
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
