I am using the Table Builder and it seems that when I try to tie in a 4th Table using Jet Express, the data does not come into Excel. Jet runs its connection to SQL just fine and everything appears to work and bring data in, but the fourth table's data is blank. The Column is there for the data but there is nothing in the column.
Is this because I am using Jet Express? Please Advise.
Date
Votes
5 comments
-
Jet Reports Historic Posts Hello jpocock1,
This isn't a limitation of Jet Express that I am aware of, I was able to build a report using four tables without issue.
Can you provide a copy of your report that I can review to see how it is constructed?
Without knowing what tables, fields and links you are using it would be difficult to determine why you aren't getting data returned for the fourth table.
It also depends on whether you are linking to the main table or the previous table in the hierarchy.
Best regards,
MWilson -
Jet Reports Historic Posts I currently have the following Table Layout.
Prod. Order Routing Line
Production Order
Sales Header
Transfer Header
I link the Sales Header and the Transfer Header to Production order with No. for Sales Header and Ref. Sales Order No. in Transfer Header.
I am merely trying to get the Shipment date from the Sales Header table and the Transfer Header table. I use no other date from those tables.
I am using the report to try to track the status of completion of our product through the Prod. Order Routing Line Operation No. column.
I get no information from the Transfer Header- Shipment Date field when I link the fourth table. -
Jet Reports Historic Posts Hello jpocock1,
Can you please provide a copy of the report so that I can see exactly how you are establishing your links and which tables are linking to which?
Best regards,
MWilson -
Jet Reports Historic Posts I have added the tables and links to this as a jpg attachment.
Let me know what else you need to know. Thank you. -
Jet Reports Historic Posts Hello jpocock1,
It appears that you are utilizing a custom field "Ref Sales Order No." to link the Sales Header and Transfer Header.
Is "Ref Sales Order No." the primary key on the Transfer Header table as No. is on the Sales Header table?
If you create a new Table Builder report and add just the Sales Header and Transfer Header tables to the report using that link are you able to pull information into the report from the Transfer Header table?
It sounds as though there is no direct link between the two tables and so no information is being generated because of that.
You may need to consult your NAV partner to see how a link can be established between these two tables.
There is additional functionality in Jet Essentials that would allow you to do this without changing anything, but it would require the use of a function that is not available in Jet Express (NP(Formula)).
Best regards,
MWilson
Please sign in to leave a comment.