ReportViewer local - Add a line number to the .rdlc textbox

//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!

Print | posted on Sunday, September 13, 2009 7:03 PM

Feedback

# re: ReportViewer local - Add a line number to the .rdlc textbox

Left by bing at 9/13/2012 7:31 PM
Gravatar It helps tnx for your post..

# re: ReportViewer local - Add a line number to the .rdlc textbox

Left by lin at 2/4/2013 9:12 PM
Gravatar Thanx!!! very helpful

Your comment:





 
 

Copyright © intermark

Design by Bartosz Brzezinski

Design by Phil Haack Based On A Design By Bartosz Brzezinski