Question
UPMC
US
Last activity: 23 Aug 2024 10:28 EDT
Can I return the sub report row count results to main report?
I have a subreport where I need to return the count of row results from the sub to be exposed in the main report. Is this possible to return this count type?
Maantic Inc
IN
Yes it works as a normal column. In the main report you can refer it as 'subreport prefix'.'subreport column name'. If you referring the main report from a data page, the value will come in .pxPages('subreport prefix).pySummaryCount(1).
Maantic Inc
IN
No it'll return the count of the column of the column in the subreport against which the summarization is done.
UPMC
US
@SohamM95 Hmm okay, I'm trying to return the results count of the subreport and expose that as a column in the main report. Trying to see if there is a way for that to be done
Maantic Inc
IN
Data page creates the pxresults pagelist, so you need to a data page for the count. In the primary report you can only add a data page in the filters but it wont suffice your requirement.