Date filter in a report - can I set it through calcdate?

Josetxo

Hello all,

It would be great if I could set the ReqFilterFields of a report in an unattended way.
I'd like to set the "Posting Date" Required Filter Field with a data range that would hold the CALCDATE('-8D', TODAY)..CALCDATE('-1D', TODAY).
Unfortunately, it seems not to work this way.

Can I set the date filter in such a way that it takes from a 8 days before to yesterday?

Many thanks in advance,
Josetxo

kriki

You have to do that before running the report:

recSomeRecordWithPostingDate.RESET;
recSomeRecordWithPostingDate.SETRANGE("Posting Date",CALCDATE('<-8D>', TODAY),CALCDATE('<-1D>', TODAY));

and then run the report:

repReport.SETTABLEVIEW(recSomeRecordWithPostingDate);
repReport.RUNMODAL;

PS: use < and > in a dateformula to make it language independant. (in Italian I would need to use '-8G', and it doesn't work in ENU, but '<-8D>' always works)

Josetxo

Thanks Kriki, solved this way. Great support from Mibuso once more

billhwang2008

:?: Is this solution means I need to develop 2 Reports, one is input those codes, another one is called by the "repReport"?

thanks.

kriki

It is not necessary to use another report. If you have a menuitem on a menubutton on a form, you can put the code in there (or even better: call a codeunit that puts the code) and then run the report.

billhwang2008

Hi kriki, thanks a lot, I completed it as you told.