Sorting by a Formula in VB

[kab555]

Hi,
I'm using CR8 within VB6 via the RDC. I have an option screen where the user can select the sort order for the report. One of these sort options is using a formula. I'm having trouble passing formula to the sort equation. The other options work because they are database table fields.

For the table fields sorting, I use the following formula

Set crxDatabaseField = Report.Database.Tables.Item(1).Fields.Item(1)

Is there a similar statment for using a formual rather than a table field?

 

[kenhamady]

try:
.... = Report.FormulaFields(1) Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Guide to using Crystal in VB

http://www.kenhamady.com/

tek@kenhamady.com