Request Form with 2 data items

ta5

Hi
As we know it is possible to start a report like the ffw code, to have the filters of the first data item set.
...
r.settableview(rec)
r.runmodal() //r is a report
..

My challenge is now to set the filters of another data item in the report r.
Any ideas.

Many thanks
Thomas

s.delikostov

Same way:

r.settableview(rec)
r.settableview(rec1)
r.settableview(rec2)
r.runmodal() //r is a report

kriki

Didn't know that trick.

But what if I have a certain record twice in the report?
Eg.
First dataitem: customer
second dataitem: customer ledger entry (invoices)
third dataitem: customer ledger entry (closing entries of the invoices)

second dataitem : I want only the invoices from a certain date
third dataitem, I want to see only the credit memo's and not the payments

How do I do that?

s.delikostov

In this case use functions

r.setcustledgentry(custledgentry);
r.setcustomer(cust);

r.setvariables(DocumentTypeFilter,DocumentTypeFilter2);

r.runmodal;
-----
setcustledgentry(custledgentry: record 21)
begin
   "Customer Ledger Entry".copyfilters(custledgentry)
end;

setcustomer(cust: record 18)
begin
  Customer.copyfilters(cust);
end;

setvariables(filt1,filt2)
begin
   "Customer Ledger Entry".setfilter("DocumentType,filt1);
   "Customer Ledger Entry - Payments".setfilter("DocumentType,filt2);
end;

ta5

Hi Stamen
Works perfectly for me. Thx very much!
Thomas