Microsoft Dynamics NAV (Archived)

Report is taking too much time to preview

(0) Share

Report

Posted on by Community Member

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

I have the same question (0)

All responses (8)

Answers (2)

Suggested answer

Alexander Ermakov 28,096 on at

Like (0)

Report

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 :-).

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

no other report are working fine. So i think something is wrong with pre-filtering.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

there is no pre-filtering setting....

Was this reply helpful? Yes No
Suggested answer

Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No
RockwithNav 8,625 Super User 2025 Season 2 on at

Like (0)

Report

Hey Sandeep,

Check out this link, It may help you.

www.dynamics101.com/report-performance-optimization-dynamics-nav-2013-r2

Was this reply helpful? Yes No
Verified answer

Tharanga Chandrasekara 23,118 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Verified answer

keoma 32,729 on at

Like (0)

Report

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.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

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.

Was this reply helpful? Yes No