You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@openoffice.apache.org by Michael Reich <re...@gmail.com> on 2012/02/06 23:33:32 UTC
Where Do Base Reports Store The Desired Query?
I've been using a Base database for my stamp collection and each year, I
copy the previous year's report structure to a new object for the
current year. At the same time, I copy/edit the previous year's Query
to a current year query, and edit it to reflect selection of the current
year (YYYY) for the query. The query then selects the right records.
However, each year I struggle with updating the report format so it
knows to use the most current query to produce the report. I have no
idea how I managed to edit the previous report structures to do what I
want, but I did. Unfortunately, I'm stuck this year and can't get the
report for 2012 to show the 2012 records (it shows the 2011 records,
because the 2012 query was a copy of the 2011 query).
I don't know why OO has to be as obtuse as it is in making such a basic
edit in a report definition, but I can't find it. How do you edit a
report to change the query it should use (where is this setting
hidden)? Can someone point me in the right direction to make this
edit? Thanks for any help!
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: WRITER: Odd conversion of footnotes
Posted by Michelle Miller <Mi...@speedconnect.com>.
Terry, thank you for your kindness in responding. I appreciate it very
much...
----- Original Message -----
From: "Terry" <te...@yahoo.com.au>
To: <oo...@incubator.apache.org>
Sent: Tuesday, February 07, 2012 5:32 PM
Subject: Re: WRITER: Odd conversion of footnotes
>I don't know Writer well enough. If you do not get an answer here, I
>suggest you try the forums:
>
> http://user.services.openoffice.org/en/forum/
>
>
>
> ----- Original Message -----
>> From: Michelle Miller <Mi...@speedconnect.com>
>> To: ooo-users@incubator.apache.org
>> Cc:
>> Sent: Tuesday, 7 February 2012 12:43 PM
>> Subject: WRITER: Odd conversion of footnotes
>>
>> May I ask a question? When I opened a Word document in OO Writer (the
>> eighth
>> document I've worked with, and only the first time this has happened), OO
>> turned all the footnotes in the original into endnotes. Is there a way to
>> convert them back easily? I see how to reformat either footnotes or
>> endnotes,
>> but not how to switch from one to the other. Any ideas? 131 endnotes is a
>> lot
>> to cut-and-paste by hand...
>> Thanks,
>> Michelle MIller
>>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: WRITER: Odd conversion of footnotes
Posted by Terry <te...@yahoo.com.au>.
I don't know Writer well enough. If you do not get an answer here, I suggest you try the forums:
http://user.services.openoffice.org/en/forum/
----- Original Message -----
> From: Michelle Miller <Mi...@speedconnect.com>
> To: ooo-users@incubator.apache.org
> Cc:
> Sent: Tuesday, 7 February 2012 12:43 PM
> Subject: WRITER: Odd conversion of footnotes
>
> May I ask a question? When I opened a Word document in OO Writer (the eighth
> document I've worked with, and only the first time this has happened), OO
> turned all the footnotes in the original into endnotes. Is there a way to
> convert them back easily? I see how to reformat either footnotes or endnotes,
> but not how to switch from one to the other. Any ideas? 131 endnotes is a lot
> to cut-and-paste by hand...
> Thanks,
> Michelle MIller
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
WRITER: Odd conversion of footnotes
Posted by Michelle Miller <Mi...@speedconnect.com>.
May I ask a question? When I opened a Word document in OO Writer (the
eighth document I've worked with, and only the first time this has
happened), OO turned all the footnotes in the original into endnotes. Is
there a way to convert them back easily? I see how to reformat either
footnotes or endnotes, but not how to switch from one to the other. Any
ideas? 131 endnotes is a lot to cut-and-paste by hand...
Thanks,
Michelle MIller
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
> For additional commands, e-mail: ooo-users-help@incubator.apache.org
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Where Do Base Reports Store The Desired Query?
Posted by Dan Lewis <el...@gmail.com>.
On Mon, 2012-02-06 at 16:33 -0600, Michael Reich wrote:
> I've been using a Base database for my stamp collection and each year, I
> copy the previous year's report structure to a new object for the
> current year. At the same time, I copy/edit the previous year's Query
> to a current year query, and edit it to reflect selection of the current
> year (YYYY) for the query. The query then selects the right records.
>
> However, each year I struggle with updating the report format so it
> knows to use the most current query to produce the report. I have no
> idea how I managed to edit the previous report structures to do what I
> want, but I did. Unfortunately, I'm stuck this year and can't get the
> report for 2012 to show the 2012 records (it shows the 2011 records,
> because the 2012 query was a copy of the 2011 query).
>
> I don't know why OO has to be as obtuse as it is in making such a basic
> edit in a report definition, but I can't find it. How do you edit a
> report to change the query it should use (where is this setting
> hidden)? Can someone point me in the right direction to make this
> edit? Thanks for any help!
Your description is too general in nature to understand what your
are trying to do. You speak of creating a query each year. What are the
differences in these queries for year to year? Do you use the same
fields? Do you use the same criterion, or is the beginning and ending
dates the only difference? Did you select a static or dynamic report?
Base is likely obtuse because you changed the underlying query in
someway or you selected static report rather then dynamic as the type of
report you wanted.
If the only difference between a query of one year and a query from
another year was the beginning dates, there should be no problem. If
there are other differences, then you have a different problem.
For this I am going to assume that you are using the same query,
but only changing the dates in the date field. Or, create a query that
contains all the information you want including the date field of when
this information applied to your stamp collection. Open the query in the
Query design dialog. In the Criterion row enter the following in the
Date field (best would be to copy this and paste it there).
BETWEEN :Begin_date AND :End_date
Once you have done this, create a report using this query. Any time you
run the report, you will get a pop-up window asking you for End_date and
then Begin_date. Format for this is what date format you use in your
locale. This one query could be used to get information for any period
of time you wish depending upon what you enter into the window.
--Dan
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org
Re: Where Do Base Reports Store The Desired Query?
Posted by Andreas Säger <vi...@t-online.de>.
It is a bug with a work-around.
http://www.openoffice.org/issues/show_bug.cgi?id=98163
---------------------------------------------------------------------
To unsubscribe, e-mail: ooo-users-unsubscribe@incubator.apache.org
For additional commands, e-mail: ooo-users-help@incubator.apache.org