I am designing a report that processes a massive amount (>3,000,000) of database rows.
I want to have a drill down report where the master report performs an aggregate query, and the query for the child report only gets run when the user expands on the master report node.
Can this be done with a drill down report? Or will it always populate each sub-report at the beginning, whether it's visible or not?
I want to have a drill down report where the master report performs an aggregate query, and the query for the child report only gets run when the user expands on the master report node.
Can this be done with a drill down report? Or will it always populate each sub-report at the beginning, whether it's visible or not?