Anyone know how I can specify a company (other than the default company) for a "Table Builder" report to use?
I.e. the equivalent of a "Company=" filter that would use on a NL function.
Thanks,
John
JET Essentials 2012 R2
Date
Votes
7 comments
-
Jet Reports Historic Posts Hi John,
When you are done using your Table Builder you get Headers, Fields and a NL Table function.
Then you can use the Function Wizard to open this NL Table function and add the "Company=" filter that you want to use.
Good luck!
Regards,
Bert. -
Jet Reports Historic Posts Been trying to do this on a couple of Reports without success. Does anyone have an example of this i could follow.
See image of the example and code i am currently using.
Regards
Gary
Update found it. Need to put code in where is says table on the spreadsheet. Just added to the bottom of all fx formulas works fine now. Hope this helps some people. -
Jet Reports Historic Posts Been trying to do this on a couple of Reports without success. Does anyone have an example of this i could follow.
See image of the example and code i am currently using.
Regards
Gary
Hi Gary,
If you were to follow the example Bert gave, which is a good idea, you are writing the company filter in the wrong Cell. Add it to the NL("Table"…) function in Cell D11 :)
That should solve it.
/Kemad -
Jet Reports Historic Posts Been trying to do this on a couple of Reports without success. Does anyone have an example of this i could follow.
See image of the example and code i am currently using.
Regards
Gary
Hi Gary,
If you were to follow the example Bert gave, which is a good idea, you are writing the company filter in the wrong Cell. Add it to the NL("Table"…) function in Cell D11 :)
That should solve it.
/Kemad
Cheers all sorted now and working. :roll: To long staring at the screen couldn't see it.. -
Mike Keiper Hi Everyone,
Do you know if it is possible to include a filter for multiple companies as well? I can follow the comments above, but I get an error message when I enter multiple companies in the filter as part of the table builder (Company 1|Company 2|Company 3 instead of just Company 1).
Thanks,
Mike
-
Harry Lewis Hello Mike -
With Microsoft Dynamics NAV and GP, queries which return a summed amount can now be set to return a combined value from multiple companies. This includes the NL(Sum) function and GL functions which return balance, budget, credit or debit amounts.
Operators such as “*”, “|” and “..” can be used in this way with either the GL or NL(“Sum”) function.
This functionality is not currently available with other functions [such as NL("Table")]
-
Mike Keiper Thanks Harry. I have a few functions that are being pulled in and automatically formatted as a table by excel (not a table builder). However, when I include Auto+Hide+Values I receive an error message that the table excel isn't compatible with Jet, which is why I tried recreating the data through the table builder. Is there any way to have a report containing multiple companies formatted as a table that doesn't recalculate when opening?
Please sign in to leave a comment.