I create a new report. And i need set visible group header by some condition
When i set =$LaborReport_RowsCount>0 in visibleExpr this headers was not visible. But i have rows in Labor Report.
Solved
VisibleExpr in Report Designer
Best answer by bihalivan15
When i add variable RowsCount in detailSection of my sub report its solve for me
+8Hi
This may have to do with the processing order. The RowsCount variable in your subreport is probably not be calculated at the time that the visibility condition for the header is evaluated. You can verify this by adding a control on your report to display the expression at various places on your report.
I haven’t tested this recently, but I think it might be possible to adjust the processing order of the Header section to Always so that the subreport variable is calculated first. Alternatively, you could consider embedding a hidden copy of subreport in an earlier section just to do the rowcount. I realize that’s not the most efficient, but I have used that approach with success.
Hope this helps!
Laura
Laura - https://www.linkedin.com/in/laura-jaffe-965a411a/ ~ If a member helped you, please *Like* their post. If a member provided an answer to your question, please mark it as *Best Answer*.
Hi
This may have to do with the processing order. The RowsCount variable in your subreport is probably not be calculated at the time that the visibility condition for the header is evaluated. You can verify this by adding a control on your report to display the expression at various places on your report.
I haven’t tested this recently, but I think it might be possible to adjust the processing order of the Header section to Always so that the subreport variable is calculated first. Alternatively, you could consider embedding a hidden copy of subreport in an earlier section just to do the rowcount. I realize that’s not the most efficient, but I have used that approach with success.
Hope this helps!
Laura
I do this but not work for me:(
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.