Sorting Crosstab matrix Dimensions

rbuser

Hi,

I want to sort Cross tab Matrix Dimension in a custom way. By default it
sorts in ascending order. SortType property of TppDimension does not provide
such an option. Is there any way that I can sort a dimension in a custom
way?

Thanks

Asif Muhammad

nicocizik

Hi Asif,

By definition the crosstab component will sort your data in ascending or
descending order based on the master key field in your datset. One way to
work around this restriction would be to create another field in your
dataset which contains "dummy" values in sequential order. Then you can
re-arrange the existing data to work with this order. This new field will
need to then be made the master key field.

--