Sort parm in queries not reappearing when reopened

Getting your data onto paper - or the web - Discussing the reports features of Base
Post Reply
paparon
Posts: 6
Joined: Mon Feb 11, 2013 5:21 pm

Sort parm in queries not reappearing when reopened

Post by paparon »

Hello. I'm new to the product so its probably me.
I am using oo 3.4.1 on a mac osx 10.7.5.
When i create a query in design mode and add a sort parameter and run the query the data is sorted properly.
After saving the query and re-running it the data still seems to be sorted properly.
When I re-open the query in design mode however the sort parm is NOT showing.

Also if I use this query in a report it seems to be ignoring the sort parameter from the query.
I am running the report in dynamic mode with no other grouping or sorting parms.
thanks in advance for any insight. :crazy:
OpenOffice 3.4.1 on MacOSX 10.7.5
paparon
Posts: 6
Joined: Mon Feb 11, 2013 5:21 pm

Re: Sort parm in queries not reappearing when reopened

Post by paparon »

This is the first screenshot of the process described in my original post: see attachment
Attachments
shows a sort parm placed in the query
shows a sort parm placed in the query
OpenOffice 3.4.1 on MacOSX 10.7.5
paparon
Posts: 6
Joined: Mon Feb 11, 2013 5:21 pm

Re: Sort parm in queries not reappearing when reopened

Post by paparon »

This is the second screenshot: see attachment
Attachments
After reopening query in edit mode - sort parm is gone.
After reopening query in edit mode - sort parm is gone.
OpenOffice 3.4.1 on MacOSX 10.7.5
paparon
Posts: 6
Joined: Mon Feb 11, 2013 5:21 pm

Re: Sort parm in queries not reappearing when reopened

Post by paparon »

third screenshot: ran query and data is still in sort order.
if I used this now in a report it would ignore the sort.
Attachments
showing data after running query. data still sorted even tho sort parameter is no longer showing
showing data after running query. data still sorted even tho sort parameter is no longer showing
OpenOffice 3.4.1 on MacOSX 10.7.5
User avatar
DACM
Volunteer
Posts: 1138
Joined: Tue Nov 03, 2009 7:24 am

Re: Sort parm in queries not reappearing when reopened

Post by DACM »

This is a bug.
AOO 4.1.x; LO 4.2.x; Windows 7/8 64-bit
Warning: Avoid embedded databases --> Solution: Adopt a portable 'split database' folder
Soli Deo gloria
Post Reply