Hi,
I have one customize report and whenever i try to preview it it will take half an hour to preview it.
I rally don;t understand what wrong with this report.
Any help will be highly appreciated.
Thank You.
*This post is locked for comments
When the data will be more then it will take long time to preview it.
To reduce the time you can use SETCURRENTKEY in your code.
in most cases following issues can cause that:
* huge data load (> 100 records ...)
* loading of images:
- many different images or
- one/some images, which are loaded very often (poor design), check data preview in
report
* a kind of an endless loop, which breaks after half an hour
best you debug. also run the sql profiler during report rendering for analyzing.
If the other reports are working fine then it might be due to a poor design.
How many data items been used and is there any iterations been written in the report? If so check the logic, most of the cases it is something to do with dataset and the iterations.
Hey Sandeep,
Check out this link, It may help you.
www.dynamics101.com/report-performance-optimization-dynamics-nav-2013-r2
There must be some code related to transaction tables like Value Entry or G/L entries.
Get the code verified frm developer and ask to change the coding. Use the right indexes and calcsums or sumindex fields. Avoid using transactions tables as report data item.
there is no pre-filtering setting....
no other report are working fine. So i think something is wrong with pre-filtering.
There might be a variety reasons for that. It might be a customized report that has been designed poorly.
It also might be the case that you select such pre-filtering settings that lead to processing huge volumes of unstructured data; try put more filters to shorten the range of selected data, e.g. limit it by a shorter date range or specific customer or vendor. Some reports are meant to be build by a certain filter value (e.g. by certain customer), and selecting all customers would not make sence but just would result in long pricessing.
Another option is that you have issues with your network and connections, thus it reduces the performance.
Also, the system itself might be slow and loaded with many jobs and users and it also might be the reason for low performance.
But usually, to my practice, first option is more probable :-).
#1
Community Member
2
#2
EH-09052238-0
1
#2
Sohail Ahmed
1
Share
Report
All responses (
Answers (
