What is the equivalent for ColumnNumber as like RowNumber in SSRS?
Hi i am using the expression "=Fields!ClientDisplayname.Value(RowNumber("DatasetName")+ 1)" i want it for column so is there any equivalent to refer a column(like RowNumber) , as i m trying to get the next value of a field i.e. in column. Any help will be highly appreciated! Thanks
May 29th, 2008 10:13am
Hi, Because the cell on the column has the different name, there is no function like ColumnNumber. Please just refer the textbox name, such as textbox1. Hopefully this helps.
June 3rd, 2008 2:21pm
There is nothing like RowNumber, but the following expression may help for the column that has been column groupd, you can use it anyway you want to get the column number for a distinct row. =RunningValue(Fields!FieldName.Value, COUNTDISTINCT, "RowGroup")
October 15th, 2011 2:10pm