https://bugs.freedesktop.org/show_bug.cgi?id=48018
Bug #: 48018
Summary: : Report Does Not Sort by Groupings
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.6 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Status Whiteboard: BSA
Severity: normal
Priority: medium
Component: Database
AssignedTo: libreoffice-bugs@lists.freedesktop.org
ReportedBy: acreech2...@gmail.com
Created attachment 59185
--> https://bugs.freedesktop.org/attachment.cgi?id=59185
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
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
