Dynamic Sorting in Crosstab

[batkosta]

Dear Experts,

I have a crosstab with rows and summarised fields (no columns). I would like to be able to sort the crosstab by any field based on a parameter. I have a command parameter {?Sort} that passes a dynamic string to sort the query and I know that the recordset is ordered according to the parameter selected. But i see no way to implement this in a crosstab unless i do a manual crosstab which requires a lot of formating.


Any help appreciated.

Mr. K

 

[Madawc]

You can create a group that will use several alternative fields, depending on the parameter entry. This should also be usable in a Crosstab, though it varies for Crystal versions.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[batkosta]

Thanks for the quick reply Madawc, i'll give it a go later on and let you know if i have any luck.

Mr. K