Is there some setting for performance issue.
Our company has two environment on-premises and BC cloud.
Performance of on-premises is quite fast.
However, BC cloud is quite slow.
I think we can not use Jet Report for business.
Is there some setting for performance issue.
Hi, when you say "slow", what kind of run time are you having at the moment? Also, depending on if you need to run/re-run the report during the day or not you can schedule it to run overnight or in the background so it doesn't affect other work.
Speed depend a lot on the report design
1) Avoid multiple NL rows/columns, but use dynamic report vs. static where possible.
2) Utilise NL Table as much as possible
3) using excel functions can often speed down as well, use NP("formula") where possible
4) conditional hiding can also slow down.
A lot has been trial and error, but hopefully it will speed up for you soon.
For a simple GL trial balance report with grouped by dimensions (static/dynamic), I'd expect to take about 1-1:30 to run.
Thank you very much.
I will discuss with workmate first.
When I run Jet Report, it is takes 30 mins to generate report.
I do not know why it takes such a long time.
I used two or three NL function and connecting same key such as "No." and "Document No."
=NL("Rows","Purch. Inv. Header",,"No.","@@"&$F15,".......................
=NL("Rows","Purch. Inv. Line",,"Document No.","@@"&$H14,"..........................
Did I misunderstand to use Jet report?
Or Jet Report can not use these kind of way.
There are several settings that can be adjusted to optimize performance when querying a BC cloud data source. The Jet Support Team is great at troubleshooting those configurations.
One more comment regarding your two data sources. You mention that on-prem performs "quite fast" but the Cloud version "is quite slow".
This is to be expected as the Cloud connector via webservices can, and is, throttled by Microsoft limiting the number of queries Jet can pass. If, for example, the on-prem can send 100 queries at a time but the cloud limits it to 5 queries at a time, the cloud will need to have 20x more back and forths with the data. (all numbers are made up just for illustration).
