Forum Discussion
Paginated report Expression column sum() Grand Total
Hello Gurus, I am working on a Paginated report where I have created a expression column, I need to show grand total of this expression column. Highlighted in Yellow. How to use following formul...
AbhiSSRS
Solution Sage
Solution SageHello! This works best when totals are accessed from textbox values in totals row. So you may give names to Totals row textboxes which contain your totals as per requirement and then put final formula in the required textbox as
=Sum(IIf( (A - ReportItems!txtBtotal.value) >ReportItems!txtCtotal.value),
ReportItems!txtCtotal.value)
, (A-ReportItems!txtBtotal.value))
)
)