Created attachment 59185 [details]
Database with the issue.

Problem description: 

Report in Database does not sort by the groupings. 


Steps to reproduce:

I have a database of recipes. I have setup fields such as ID (Primary Key), Cookbook (name), Recipe Name, Number of Servings, Calories Per Serving, From the Kitchen of, Ingredients, Instructions, and Note. 

I then created a query to select only certain cookbook entries and then sort by recipe name. The query sorts correctly. The SQL for the Query is:

SELECT "ID" AS "ID", "cookbook" AS "cookbook", "Recipe Name" AS "Recipe Name", "Number of Servings" AS "Number of Servings", "Calories Per Serving" AS "Calories Per Serving", "From the Kitchen of" AS "From the Kitchen of", "Ingredients" AS "Ingredients", "Instructions" AS "Instructions", "Note" AS "Note" FROM "Appetizer" WHERE ( "cookbook" = 'Creech' OR "cookbook" = 'Patterson' OR "cookbook" = 'Pampered Chef' ) ORDER BY "Recipe Name" ASC, "From the Kitchen of" ASC


Current behavior:

Then I created a report, using the report wizard on the query. I setup groupings for "Recipe Name", "Ingredients", "Instructions", and "Note". The groupings are sorted by ascending, in the order listed above. the fields "From the Kitchen of", Number of Servings", and Calories per Servings" are also included in the report. 


Expected behavior: 

Report should sort the database by recipe name so that they are all in alphabetical order. 

Platform (if different from the browser): Linux Mint 12
              
Browser: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:11.0) Gecko/20100101 Firefox/11.0