Hi all,
We have just gone live and as software owner am going through a baptism of fire with Jet. We consciously have held off training while the master users (Designers) get a general feel for the software so as to get the most from our training.
I have two questions if people could help.
1. My laptop takes for ever to run reports, crashes Excel repeatedly and then tries to convince me to disable the Jet add-on. I have seen Jet spend 20 minutes thinking its way through rows and then sit in calculation mode overnight. Is this normal?
2. How do you link tables. If anyone has a very simple example from two standard tables I would be extremely grateful. We have figured out columns and time filters…stuck on table linking.
Thank you very much.
David.
Date
Votes
1 comment
-
Jet Reports Historic Posts 1. My laptop takes for ever to run reports, crashes Excel repeatedly and then tries to convince me to disable the Jet add-on. I have seen Jet spend 20 minutes thinking its way through rows and then sit in calculation mode overnight. Is this normal?
The first part yes ( rows - but depends on complexity involved)
2nd part not so much
Essentially in my experience report time depends on a whole raft of things -
How much horsepower ( memory and processiong speed) your laptop has
Which Version of Jet you have ( newest definitely improved)
Where data is located ( network speed)
Server where data is located ( IO can be a killer as well as memory swapping )
What else is going on with database at same time
How big the database is and how much data actually has to be evaluated ( example GL entry sums on 7 years of GL data can take a verryyyyy long time)
2. How do you link tables. If anyone has a very simple example from two standard tables I would be extremely grateful. We have figured out columns and time filters…stuck on table linking.
If you check this section there is a discussion(s) on the topic ( essentially you have to be know which fields in the tables correlate and then filter based on that .
Depending on what you're trying to accomplish it can be as simple as take a value from table in cell and use it to filter table b
Please sign in to leave a comment.