Yes, thank you Dan.
I upgraded to 3.6.4, and the problem went away.
Perhaps you can add assistance with another query?
I have created a parameter query with a case when statement :
case when dateadd('dd', 365, "originaldate") <= dateadd('dd', 90,
current_date) else '' end
Problem is that instead of showing just the records that satisfy the
parameter, it shows all records.
If I solve that part, then the query will run exactly as I want it to.
Thanks again,
Al
On Thu, Jan 24, 2013 at 12:23 PM, Dan Lewis [via Document Foundation Mail
Archive] <[email protected]> wrote:
> On 01/23/2013 04:22 PM, capemayal wrote:
>
> > LibreOffice 3.5.4.2
> > Build ID: 350m1(Build:2)
> >
> > I have created a query from one table. In the query design grid I sort,
> > ascending, on a 'name' field.
> >
> > The query works as expected with results sorted on the 'name' field.
> >
> > When creating a report, using the wizard, with the query as the source,
> no
> > matter what I do the query sort does not carry over to the report.
> >
> > It appears that no matter what field the query is sorted on, the report
> > always sorts via the ID field, which is also the primary key.
> >
> > I have tried using the query sort, then using the same field in the
> report's
> > sort option; I've tried using the report control to change SQL Command
> as
> > source to the query, and order by 'name' in the report control.
> >
> > All of this makes no change. The report does not sort the way the query
> is
> > made.
> >
> > Any help would be appreciated.
> >
> > Thanks.
> > --
> > View this message in context:
> http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350.html
> > Sent from the Users mailing list archive at Nabble.com.
> Have you been able to correct your query and report? Where did
> you get your version of LO 3.5.4? Did it come with a Linux distribution?
> If so, which one?
> I ask these questions because I have not been able to duplicate
> your problem using LO 3.5.7 from the LibreOffice website.
>
> --Dan
>
> --
> For unsubscribe instructions e-mail to: [hidden
> email]<http://user/SendEmail.jtp?type=node&node=4031515&i=0>
> Problems?
> http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
> Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
> List archive: http://listarchives.libreoffice.org/global/users/
> All messages sent to this list will be publicly archived and cannot be
> deleted
>
>
>
> ------------------------------
> If you reply to this email, your message will be added to the discussion
> below:
>
> http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350p4031515.html
> To unsubscribe from Base Query Sort and Reports, click
> here<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=unsubscribe_by_code&node=4031350&code=Y2FwZW1heWFsQGdtYWlsLmNvbXw0MDMxMzUwfDkzNzY1NjE0>
> .
> NAML<http://nabble.documentfoundation.org/template/NamlServlet.jtp?macro=macro_viewer&id=instant_html%21nabble%3Aemail.naml&base=nabble.naml.namespaces.BasicNamespace-nabble.view.web.template.NabbleNamespace-nabble.view.web.template.NodeNamespace&breadcrumbs=notify_subscribers%21nabble%3Aemail.naml-instant_emails%21nabble%3Aemail.naml-send_instant_email%21nabble%3Aemail.naml>
>
--
View this message in context:
http://nabble.documentfoundation.org/Base-Query-Sort-and-Reports-tp4031350p4032025.html
Sent from the Users mailing list archive at Nabble.com.
--
For unsubscribe instructions e-mail to: [email protected]
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted
