Sorting in Crystal Reports

[Markus H]

To sort at runtime you must code the following:

CrystalReport1.Sortfields(0) = "+{Tablename.Fieldname1}"
CrystalReport1.Sortfields(1) = "+{Tablename.Fieldname2}"

and so on.

This order is ASC for the fields. If you want to sort by DESC change '+' to '-'.

Good luck

[bontyboy]

Thanks Markus H!!

It works. I was playing with this last night for about 2 hrs trying to figure out how to sort at runtime.

Do you know of any sites that has tips on using crystal with VB ?

[Markus H]

There are some VB examples in your Crystal Reports installation directory. You can read the helpfiles too; developr.hlp shows the use of the Crystal OCX.
Or go to Seagate directly.
http://community.seagatesoftware.com/homepage
Then follow the link 'Download Files and Updates'. You can find many examples.