[libreoffice-users] Re: Base Query Sort and Reports

My last message should have said the case statement is


case when dateadd('dd', 365, "originaldate") <= dateadd('dd', 90,
current_date) THEN 'Expired' else '' end AS "Message"


On Sun, Jan 27, 2013 at 12:34 AM, Hank Alper [via Document Foundation Mail
Archive] <ml-node+s969070n4032140h2@n3.nabble.com> wrote:

> 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 <[hidden 
> email]<http://user/SendEmail.jtp?type=node&node=4032140&i=0>>
> 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] <[hidden email]<http://user/SendEmail.jtp?type=node&node=4032140&i=1>>
> 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<
> >
> >
> > > .
> > > 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: [hidden 
> > email]<http://user/SendEmail.jtp?type=node&node=4032140&i=2>
> > 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: [hidden 
> email]<http://user/SendEmail.jtp?type=node&node=4032140&i=3>
> 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-tp4031350p4032140.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-tp4031350p4032142.html
Sent from the Users mailing list archive at Nabble.com.
-- 
For unsubscribe instructions e-mail to: users+help@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