I'm lost here,
And after spenidng too much time, i'm lost, :ugeek: :roll:
I want to use following filter=NL("rijen";"artikel";;"Vestiging";"0|3";"Productgroepcode";"<>VERVALLEN|UITLOPEND|STATIEGELD";"limiet=";100)
And this should create a list of item record afrom vestiging 0 and 3 and excluding all items with productgroepcode ; vervallen, uitlopend and statiegeld.
the filter vervallen is working
What is wrong with it, I get the feeling that is a newbie issue i overlook
thanks for any help.
Date
Votes
6 comments
-
Jet Reports Historic Posts Official comment Hi Jan,
Link= is what you want to use for that. It might look something like this:=NL("rijen";"artikel";;"Vestiging";"0|3";"Productgroepcode";"<>VERVALLEN&<>UITLOPEND&<>STATIEGELD";"+Leveranciersnaam";"*";"+Levertermijn";"*";"Link=";"Supplier";"leveranciersnaam";"=leveranciersnaam";"Purchaser";"YourValueHere")So the first "leveranciersnaam" is the field on the Supplier table and the "=leveranciersnaam" is the linked field on the Artikel table. It seems slightly strange to link the 2 tables using a name since names are not guaranteed to be unique (usually you link 2 tables using the number), but if it works for you then I guess it's okay. Does that make sense?
Regards,
Hughes -
Jet Reports Historic Posts Hi Jan,
This is an easy mistake to make. You are switching your logical OR and logical AND. You want to filter for Productgroepcode not equal to VERVALLEN AND not equal to UITLOPEND AND not equal to STATIEGELD like this:
<>VERVALLEN&<>UITLOPEND&<>STATIEGELD
Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts :shock:
I thought about &
so close to the solution,
Thanks! -
Jet Reports Historic Posts Hughes,
Code is now fine,=NL("rijen";"artikel";;"Vestiging";"0|3";"Productgroepcode";"<>VERVALLEN&<>UITLOPEND&<>STATIEGELD";"+Leveranciersnaam";"*";"+Levertermijn";"*")
and it create a list of items according to the filterset defined
But I would like to narrow down the list, by including an extra filter; purchaser , but this filter is not within the same table.
in the item table (artikel=item) and the supplier table I have the field suppliername (=leveranciersnaam)
In the supplier table I have the field Purchaser
Now I would like to run this report with an optionsheet where the user can filter by purchaser
I must find a way to get the two tables together? where the suppliername is the connecting field
I was thinking about link= or filter= the samples from the help do not make sence yet.
any help to point me to the right direction is apprciated -
Jet Reports Historic Posts Hi Jan,
So the first "leveranciersnaam" is the field on the Supplier table and the "=leveranciersnaam" is the linked field on the Artikel table. It seems slightly strange to link the 2 tables using a name since names are not guaranteed to be unique (usually you link 2 tables using the number), but if it works for you then I guess it's okay. Does that make sense?
Regards,
Hughes
Hughes,
Your code did the trick, that is the solution I was looking for! thanks!
about using suppliernames
I did not want to use the suppliernumber, this was just an easy way out , the report users are more familair with suppliernames instead of suppliernumbers
But giving me a hint, I could use your more solid method by using the supplier numbers for the link and filter and and still have the suppliername displayd in the report for user benefits :-)
furthermore,
with your tips, I was able to reduse the report runtime from up to 45-50 minutes down to 15 minutes and easy to maintain
For now I'm very happy with the current result. awaiting my next brainwave to improve it. -
Jet Reports Historic Posts Jan,
Hey that is great to hear! I'm glad that fixed the issue and allowed you to reduce the report runtime by so much. Link= is a great tool to have in your toolbox, and it is definitely faster than conditionally hiding or using NL(Filter) most of the time. Good luck with your next brainwave! ;-)
Regards,
Hughes
Please sign in to leave a comment.