Hi
capemayal,
In your case expression you use the WHEN keyword. You should have a THEN
keyword to match. If the two dates in your expression match THEN what
happens ?
Hank
On Sat, Jan 26, 2013 at 10:52 AM, capemayal <capema...@gmail.com> wrote:
> 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] <ml-node+s969070n4031515...@n3.nabble.com> 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: users+h...@global.libreoffice.org
> 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
>
>
--
For unsubscribe instructions e-mail to: users+h...@global.libreoffice.org
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
