Cannot select fields to sort

[1dergirl]

When selecting the Sort Order command, I cannot add a database field to the "Add" or "Remove" portion of the form. Thus. fields cannot be sorted. Error, or bad sp?

 

[pelajhia]

I think what you are doing when you sort is changing the 'order by' clause in the select statment. If you are using a stored procedure, it would make sense that you would not be able to affect the order by. Just a supposition on my part, have not been able to confirm this.

 

[chelseatech]

Earlier versions of CR could only sort by fields in the report. Later versions let you sort by any field.

To use a field for sorting if it's not in the report:
1) Place the field on the page
2) You should now be able to sort by the field
3) Remove the field from the page Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm