to sum subreport DBCalc when subreport in drilldown or invisible mode
i have 3 subreport, where each of them contains a DBCalc component that sum
a datafield insdie their subreport respectively.
i have place another DBCalc/Variable to sum all those subreport DBCalc in my
main pipeline.
i wan the 3 subreport in drilldown or invisible mode, the problem is that
the DBCalc.Variable compoenent that sum all subreport DBCalc only return
correct values when all those subreports are drilled down or visible.
otherwise, it will return 0 and same thing happends to subreport DBCalc as i
believe this is because my subreports are in drilldown or invisible mode.
is there any solution?
thanks in advance.
a datafield insdie their subreport respectively.
i have place another DBCalc/Variable to sum all those subreport DBCalc in my
main pipeline.
i wan the 3 subreport in drilldown or invisible mode, the problem is that
the DBCalc.Variable compoenent that sum all subreport DBCalc only return
correct values when all those subreports are drilled down or visible.
otherwise, it will return 0 and same thing happends to subreport DBCalc as i
believe this is because my subreports are in drilldown or invisible mode.
is there any solution?
thanks in advance.
This discussion has been closed.
Comments
When a subreport is not visible or in drilldown mode, the components
contained inside the subreport are not automatically created. Since you are
using ReportBuilder components to make calculations, you need these
components to be created and calculated. You may try either making these
calculations elsewhere in your application or perhaps calculating these sums
inside another query in your database to remove the need for the subreports
to be visible.
--
Nico Cizik
Digital Metaphors
http://www.digital-metaphors.com