I am fairly new to the Database world, and I have a problem sorting when trying to run a report. I want to be able to sort via a dropdown list. The client software that uses the database generates the reports as .pdf files. They want to keep it like that because they email the reports to their customers. I have learned to interactive sort, but you're not able to sort after the .pdf's are created.
I have the dropdown list created, and I can add fields to the list, but it does not sort the report. It does not matter which field that you sort by.
Any help would be appreciated, and thanks in advance.