//Add a line number to the .rdlc textbox: use this formula
=RowNumber(nothing)
//ReportViewer Conditional Formatting of BorderStyle based on whether anything is in the report.
=iif(CountRows()=0,"None","Solid")
=iif(CountRows()=0,"None","Dashed")
=iif(CountRows()=0,"None","Dotted")
//ReportViewer Conditional Formating and showing the Avg if there are rows in the report.
=iif(CountRows()=0,"",(Avg(Fields!PctDisb.Value) & "%"))
textbox:
name: PageXofY
="Page " & Globals.PageNumber & " of " & Globals.TotalPages
page footer not being displayed in excel export of reportviewer
http://forums.msdn.microsoft.com/en-US/vsreportcontrols/thread/0ead9e34-bc45-4062-90dd-17f8f8ebf062/
PctOfTotal
=(Fields!EOM_Total.Value)/(Sum(Fields!EOM_Total.Value))
=iif((CStr(Fields!EOM_Total.Value/ReportItems!SumEOM.Value)="NaN"),0,(Fields!EOM_Total.Value/ReportItems!SumEOM.Value))
Sum of PctOfTotal
=Sum((Fields!EOM_Total.Value)/(Sum(Fields!EOM_Total.Value)))
=Fields!PctOfTotal.Value
=ReportItems!PctValue.Value
And Voila!