I'm using Crystal IX with a SQL server database. I want to give the users an ordered list to select from on a report. I created a command object with the following SQL code:
select location_id, description from location_mstr order by description
I select this command object for a static parameter, but when I fill the list it is filled UNordered. How do I get it to give me a sorted list?
On a related note, I have the parameter set to use description only. The parameter screen shows both the list and the selected key field. The key is a guid which I don't want the users to see. How do I get it to show only the list?
IP Logged
