Sorting records dynamically from VB5

[Beaner5434]

I am developing an app in VB5 that uses an interface to determine which records will appear on the report. All the records are in a single table. I want to give the user the option to sort the records on one of five fields: Date Entered, Date Due, Date of Service, Date Received, or Patient Name. I have the report producing the correct records by passing a string to the SelectionFormula aspect of the VB5 Crystal control, but I cannot figure out how to set the Sort order. I tried including ORDER BY {field name} in the SQL string, but that crashed and burned, something like {ReportInfo.CaseGroup}=1 ORDER BY {ReportInfo.DateRecd}. I'm thinking it's something simple, and I'm just not seeing it. Any suggestions or guidance you can offer would be greatly appreciated!

 

[kenhamady]

You can put a formula field into the report with the contents of {DueDate}, sort on that formula field, and then pass the formula the appropriate field name from your app. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[kenhamady]

You can also set the sort field directly with a command from the app, but the command varies with the integration method you are using. Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.