April 15, 2015 at 9:02 am
I created a report that opens with a summary of shipping records by location. when I try to drill down to individual customers and then individual line items, the data reloads each time. This is causing unacceptable delays when rendering the data. Is there a way I can just load the data in the report once instead of loading every time I drill down?
May 8, 2015 at 7:39 am
Select the Visibility tab then change the Initial appearance of the toggle to Expanded (-).
does that help?
May 8, 2015 at 10:19 am
No, because the report is so long (approximately 4,000 lines) that it isn't useful unless it is initially summarized. We have five locations, and the report summarizes each location's on time delivery percentage. Normally this is all the report is used for. However, on occasion, a location's performance is below par, and then the report users will want to drill down and identify the customer who is experiencing the shortage, and then drill down into the customer to identify the individual line items causing the problem.
So we have to drill down twice to get to trouble spots, and each drill down operation causes the report to re-render, which takes about a minute. Sitting there twiddling your thumbs for 60 seconds every time the plant manager wants to take a look at a trouble spot during a meeting can get awkward....
May 9, 2015 at 1:30 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply