How to improve RDLC Report performanace.

Business Central/NAV Developers Forum
1

Hii all,

i have develop a RDLC report , when i run the report its run very slowly , how to improve speed of Report performance, even i already optimize the code ,it shows this type message.

pastedimage1486638443695v2.png

Kindly give the some suggestion for this…

Thank You

2

Hey Akkrahul,

There’s no sort of magical trick which can be Implemented in RDLC reports to enhance it’s performance. Some thing you can consider is

  1. A very well maintained Optimised code.
  2. Not a very complicated, Indented Datasets.
  3. Not a very critical design with way more logic’s written over there.(RDLC Part)
  4. Use Row Visibility.
    5.Always check About this Page of the Report and make sure its not heavily loaded and try to remove unnecessary excution if you find any.
3

Great answer. When then person asking this generic, then the answer also has to be this generic.[:)]

4

Akkrahul,
Basically periodic restarts of ReportServer clears the cache and generally it takes time when you start it for the first time. From there on it should work normal.

But below queries should help you to get a basic matrix on the reports execution.

SELECT TOP 10 Itempath,[parameters],
TimeDataRetrieval + TimeProcessing + TimeRendering as [total time],
TimeDataRetrieval, TimeProcessing, TimeRendering,
ByteCount, [RowCount],Source, AdditionalInfo
FROM [ReportServer]…ExecutionLog3
ORDER BY Timestart DESC

SELECT
COUNT(REPORTPATH) AS RUNS,
REPORTPATH,
MAX(TIMEDATARETRIEVAL) AS MAX_DATA ,
MAX(TIMEPROCESSING) AS MAX_PROCESSING,
MAX(TIMERENDERING) AS MAX_RENDER,
MIN(TIMEDATARETRIEVAL) AS MIN_DATA ,
MIN(TIMEPROCESSING) AS MIN_PROCESSING,
MIN(TIMERENDERING) AS MIN_RENDER
FROM [ReportServer]…EXECUTIONLOG2
WHERE
STATUS IN (‘RSSUCCESS’)
GROUP BY REPORTPATH
ORDER BY COUNT(REPORTPATH) DESC

5

okey…Thanks

6

Hi Venkat,
Which report server do you talk about? And what is the purpose of this script? Looks more AX to me?

7

Erik, The script is generic and related to SQL Server Reporting Services. Any technology that uses SSRS reports can execute the script on SQL Server reports database to get a matrix of the reports history which have been executed. It gives a basic idea, insight and understanding of the report execution cycle then developers can narrow down on what can be done to improve and where…
Hope I covered explanation.

8

Hi Venkat,
And how does that help someone using Dynamics NAV?
NAV does not use SSRS, but AX does.

9

Ok, The suggestion applies to the NAV using SSRS
blogs.msdn.microsoft.com/…/
robertostefanettinavblog.com/…/

10

Amazing. Still trying to save face? [;)]

The question was about RDLC Report performance, not the theoretical option to use SSRS…

11

Erik, All MS products do use SSRS (ex: GP, CRM, AX ), I forgot NAV doesn’t use. But the latest NAV in azure seems does. They started this work somewhere in 2006 but looks like made it in 2016, so its no more theoretical.

Watch 2016 presentation from “Roberto Stefanetti”, it is publicly available.
www.youtube.com/watch
www.slideshare.net/…/ssrs-sql-server-reporting-services-reports-for-nav-users

12

There is a difference between “can use” and “does use”. The standard NAV product does not use SSRS.

13

Please try to reduce the size of the dataset to maximum as possible, like replace the FIELDCAPTIONS used in report dataset with ‘Labels’ feature in RDLC, try to use Filter, visibility conditions on the layout as required, If any Image used then reduce the iteration of that dataset value to maximum of once instead of looping each time in dataset.
Hope these approaches can make some difference I guess. :slight_smile: