Sunday, 5 June 2016

RowGroup properties for ASC and Desc order

yes, Pervisously we seen SaleTerritory Region as asc order, now we will make as desc for this.


then


we want to provide as a parameter to enduser then need to create parameter (sortorder)



Then
based on enduser selection of "Ascending" or "Descnding" sorting will be performed.

Asc :expression=IIf(Parameters!SortOrder.Value="Asc",Fields!SalesTerritoryRegion.Value,1)
Desc  : expression = IIf(Parameters!SortOrder.Value="Desc",Fields!SalesTerritoryRegion.Value,1)




No comments:

Post a Comment