building reports from a form

martensens

Good morning,

i want to open a ledger entry report starting from the item card (form).
how can i transfer the filters from form to report.
Is there any idea ?

Thank's in advance

Steve

FPulsfort

You can create a function in your report, which you call before you start your report. The parameters of the function contain your values with which you want to filter in your report. And in the function you can set with these values your filter or you can use the values later in your report.

Hope this helps.

Regards,
Frank

TheDude27

martensens wrote:

Good morning,

i want to open a ledger entry report starting from the item card (form).
how can i transfer the filters from form to report.
Is there any idea ?

Thank's in advance

Steve

For Example in the report the function would look like this:

---

FilterReport(DateVal : Date, ItemFilter2 : Code)

---

"Item Ledger Entry".SETFILTER("Posting Date",DateVal);
"Item Ledger Entry".SETFILTER("Item No.",ItemFilter2);




From the form the code could look like this:

---

ItemReport.FilterReport(Today,"No.");
ItemReport.RUN;

RobertMo

and if you don't want to change your report you can make use of
Report.SETTABLEVIEW(Record);

rYourILE.SETFILTER("Item No.",rec."no.");
rYourILE.SETFILTER("Posting Date",rec."Date Filter");
rYourILE.SETFILTER("Location",rec."Location Filter");
rpYourReport.SETTABLEVIEW(rYourILE);
rpYourReport.RUNMODAL;