I've been playing about with some Crystal Reports for a few weeks now but can't seem to crack a problem:

I am using version 9.2.

I want to create a drop-down menu that allows the user to select a criteria (either employee ID or surname) to then sort the records shown on the report.

An example of this would be - a report showing a list of employees by sorted by employee number. It also shows their personal details (names, addresses, contact details, etc).

On running the report, the user should be able to select from a drop-down menu the option of showing the records sorted in employee number or surname alphabetical order.

I have tried to implement this using a parameter field to allow the selection (the easy bit- this works fine), and a formula to take the value of that selection, but here is where I get stuck - how to implement the actual sorting. I am assuming it is in the formula that this is done, but I can't figure out how to do it.


Any advice would be most helpful

Thanks

I've worked it out now!

assign the field in the recordset/database I'm reporting on in a formula. Then, insert a summary of this formula e.g. maximum of @sort. Stick this in the report body but hide (suppress) it (maybe run and check it first though for the values so they're coming out in the user selected order).

Izzy wizzy, let's get busy - it works!! :)

Answered by own question!