Monday, March 19, 2012

interactive sorting in sql reporting 2000

hi all

how can i get interactive sorting in sql reporting 2000 that is available in sql reporting 2005

plz suggest me the solution for same.

Most people approximated this behavior by using a series of parameters which allowed a user to select which columns to sort on. Then, you'd use the parameter values and inject their values into a custom built expression and/or expressions behind a data region. For example:

= "SELECT MyField, MyField1, MyField2 FROM MyTable ORDER BY " & Parameters!SortParameter.Value

...which would resolve to Select....From MyTable ORDER BY SomeColumn.

The example above is very simple...you'd have to make it fancier and use IIF statemetns to check for empty values, etc. etc..

No comments:

Post a Comment