Hi,
I am trying to run a report for multiple companies. I tried using the company= filter and specify multiple companies in that filter, but it doesn't seem to work at all. Is there any way I can run a report that display consolidated information for multiple companies?
Your help is very much appreciated.
Regards,
Jules
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Jules,
You may use only use 1 company name as a filter. Multiple companies are not allowed as Navision only allows access to one company at a time.
If you want to learn more about "Company=": this forum has more topics on it. Search will help you to find it. E.g. http://community.jetreports.com/viewtopic.php?f=7&t=283
If you open the Jet Reports Help pdf file, you may find more info about the Company options on page 190..195.
Take care, -
Jet Reports Historic Posts It's probably not very current anymore, but if it helps anybody else in the future: I got it to work like this:
In the Jet manual, array functions are mentioned. Now, if you use a NP(union) over two NL(filter)'s (one for each company) you can extract rows from this combined list. In specific, my example retrieves all "LV-numbers" from the table "Contact Business Relation" (company specific), unions this, and uses this list as a key to retrieve information from the (shared) table "Contact". Cell D4 lists all (so from both A and B) contact numbers, cell D5 retrieves from the shared table.
—
D4: =NL("Rows"; NP("Union"; NL("Filter";"Contact Business Relation";"Contact No.";"No.";"LV*";"Company=";"Company A"); NL("Filter";"Contact Business Relation";"Contact No.";"No.";"LV*";"Company=";"Company B")))
—
E4: =NL("First";"Contact";"Name";"No.";$D4)
—
*****
Edit: Apparently, this is not default behaviour! Though it may work fine in my company as our Contacts-table has been made enterprise-wide, it seems this is not standard and will therefore not work for everyone. Caveat emptor.
Please sign in to leave a comment.