nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Very slow performance with subreport

sachindhus

Hi, I am generating user analysis report user JDBC data set. This report contain 2 subreport where I have to fire 4 sql queries dynamically. For generating report of 1000 users it takes almost 25 min. Please help me to improve performance & optimize report generation. Regards,Sachin Dhus

Find more posts tagged with

Comments

micajblock

Yes, don't use sub-reports. If I understand correctly you are executing at least 4,000 queries in one report. Think of a way to do this better? Joined data set? Stored procedure?

Leom

Have you tried Joined Data Sets mentioned above .. or cached data?