Printable View
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
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 ?
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.