To do some operation on the basis of rownumber we can use the RowNumber function of the SSRS
=iif(RowNumber(Nothing) Mod 2,”Green”,”Yellow”).
on the above line it will fill the line color as green adn yellow on the basis of odd even linbes
=iif(RowNumber(Nothing) = 1,”Yes”,”No”).
above line will visible only first line
nothing will consider the outer most group for filteration
=iif(RowNumber(Nothing) Mod 2,”Green”,”Yellow”).
on the above line it will fill the line color as green adn yellow on the basis of odd even linbes
=iif(RowNumber(Nothing) = 1,”Yes”,”No”).
above line will visible only first line
nothing will consider the outer most group for filteration
No comments:
Post a Comment