URGENT: Sorting using Crystal

[SmileyFace]

Hi. Need help with the following as soon as possible. Thanks in advance for any help offered.

I have a crystal report which connects to a 'View' in a SQL database and retrieves records from there. The view doesn't have any 'Order By' in the statement. Yet the records appear sorted by this one 'NumOrder' column. The report is designed to have 2 groups. I looked into the 'Sorting' in the report and it appears to be in Descending order for each group, but the sort is performed on an entirely different column...'Title'.

My question is, is there any other way a sort can be performed? Also, I tried adding a sort into the view along with an additional field. However this is not refreshed in my report. How do I refresh the 'view' from the database inside of Crystal?

 

[synapsevampire]

To refresh your report, use:

Database->Verify Database.

Does your View have groupings in it? If so, that will be the first level of sortation, as will any groups placed in Crystal.

You'll be better served to post sample data and expected output.

-k

 

[JohnEck]

If you need to group on one field and sort on another it is easiest to accomplish this with a stored procedure that performs the grouping then a CR report that performs the sorting.