Additional comment: If you do not see the General nor Data tab, you do not have the Properties dialog open. Use the F4 key to open or close the Properties dialog.
--Dan On Wed, 2012-02-08 at 10:54 -0600, Michael Reich wrote: > I have a field in the database which equals year (YYYY) and the query > selects records for a designated year. The report should use that > value. I got a more useful response on the old openoffice.org user > list which explained: > > Right click on the report name in the main window. Chose "edit". > > When the report editing window comes up, left click somewhere in the > > center window, not on an object, just the background will do. > > In the right pane, you should see tabs with "General" and "Data" > > names. Click on "Data". > > Edit the "Content" field to your new query name. > > That should do it, after you save the report. Don't forget to click > > on the save icon in the main window also. Both saves must be done to > > properly save the changes. > The "Content" tab has buried in it the reference to the proper query. > That's what I hadn't found previously. > > On 2/7/12 7:34 AM, [email protected] wrote: > > Subject: > > Re: Where Do Base Reports Store The Desired Query? > > From: > > Dan Lewis <[email protected]> > > Date: > > 2/6/12 6:00 PM > > > > To: > > [email protected] > > > > > > 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: [email protected] For additional commands, e-mail: [email protected]
