Active Reports SubReport behavior

Active Reports SubReport behavior

Posted by: connor.shepler on 19 November 2019, 1:19 pm EST

• 

  connor.shepler

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 19 November 2019, 1:19 pm EST

  I am trying to understand what is causing my report to run extremely slow.

  Does active reports load all sub reports into memory regardless of their visibility?

  For example,

  I have a parent report of Id’s and a sub report for each Id in the parent report. Are the sub reports queries automatically run regardless if they are hidden by a toggleItem?

  Is it possible to prevent sub reports from running unless their ToggleItem is opened?

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 20 November 2019, 7:18 am EST

  Hello,

  Yes, the subreports render in the toggle state. That’s because using the Toggle button, its just the visibility that changes and not the rendering of the reports.
  
  Allow me to discuss with the concerned team regarding the ways to prevent the same (Internal Tracking ID: 277528). Will get back to you once it is done.

  Thanks,
  
  Esha

• 

  connor.shepler

  • Post Options:
  • Link
    Copy

  Posted 20 November 2019, 9:22 am EST - Updated 30 September 2022, 5:22 pm EST

  Thanks Esha. Let me know if there is a way I can prevent the sub reports from loading unless toggled.

• 

  esha.dhir

  

  • Post Options:
  • Link
    Copy

  Posted 21 November 2019, 2:31 am EST

  Hello,

  As per the team, this is by-design currently. Unfortunately, we have no ETA of when this shall change and skip rendering of the reports for toggling situations.

  Regards,
  
  Esha