SOP30200 Sales Transaction History - holds header information
SOP30300 Sales Transaction Amounts History - holds line information
When reporting on these tables it takes an unacceptably long time to run. To get one weeks data I stopped the report after 40 minutes as it was affecting performance for other users within GP. Admittedly these tables are large (7.7m records in SOP30300) and although it runs slow to get this data in a smartlist I can get it much quicker than using Jet. One weeks data would be roughly 10-11k lines
Any ideas? If this is the "just the way it is" then I'm afraid Jet Reports isn't going to work for me.
Any feedback would be appreciated
Thanks
Date
Votes
2 comments
-
Jet Reports Historic Posts Hello Aldo73.
The Jet functions are simply SQL queries. If the reports are running slow then I would troubleshoot the connection to the database and table indexes. Try adding the ShowQuery parameter to your report to troubleshoot. When I do it on with a sum function on the sales history table it shows like this:
The function =NL("Sum","SOP30200","DOCAMNT","ShowQuery=","True") will show SELECT SUM("DOCAMNT") FROM "TWO"."dbo"."SOP30200"
Running the direct SQL queries should allow you to spot any problems in performance.
Its possible that the connection between the computer where Jet Reports is running is on a slow connection to the database. If they are using a VPN then I would recommend switching to a remote desktop solution.
If in troubleshooting you find that everything is optimal between where Jet Reports is running and the database then next I would reach out to Jet and work with a Report Analyst to see if there is any way to redesign the reports to better perform.
Hope this helps.
Best
Jason -
Jet Reports Historic Posts Jason
Thanks for the reply, I think there was something wrong with the report. All seems fine just now, although early days.
Regards
Alan
Please sign in to leave a comment.