help with filter issue

Jet Reports Historic Posts

January 09, 2014 09:58

None

I could use some help here, lost in what should be a simple issue
need to fresh up my skills :o and do some more practice…

the result I want is the Sum of open orderamount where order date is 06-01-2014..10-01-2014

open ammount is in the table saleslines
orderdate is in table salesheader

=NL("Sum";"saleslines";"Openstaand bedrag";"nr.";"";"filter=";"salesheader";"Orderdatum";"06-01-2014..10-01-2014")
Aany point in the right direction to solve this is appriciated,
think I miss something on the filter arguments?

Thanks

Date Votes

1 comment

0

Jet Reports Historic Posts January 18, 2014 00:14

Hi Jan,

I think you are looking for Link= instead of Filter= in that formula. You also need to know what the linking fields are for the saleslines and salesheader tables.

Regards,
Hughes

Comment actions Permalink

Please sign in to leave a comment.