Monday, 23 November 2015

Filteration on Rownumber in SSRS

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

No comments:

Post a Comment