From ooo-users-return-614-apmail-incubator-ooo-users-archive=incubator.apache.org@incubator.apache.org Mon Feb 6 22:34:08 2012 Return-Path: X-Original-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Delivered-To: apmail-incubator-ooo-users-archive@minotaur.apache.org Received: from mail.apache.org (hermes.apache.org [140.211.11.3]) by minotaur.apache.org (Postfix) with SMTP id 6ADEB9C28 for ; Mon, 6 Feb 2012 22:34:08 +0000 (UTC) Received: (qmail 64375 invoked by uid 500); 6 Feb 2012 22:34:08 -0000 Delivered-To: apmail-incubator-ooo-users-archive@incubator.apache.org Received: (qmail 64207 invoked by uid 500); 6 Feb 2012 22:34:07 -0000 Mailing-List: contact ooo-users-help@incubator.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: ooo-users@incubator.apache.org Delivered-To: mailing list ooo-users@incubator.apache.org Received: (qmail 64199 invoked by uid 99); 6 Feb 2012 22:34:06 -0000 Received: from nike.apache.org (HELO nike.apache.org) (192.87.106.230) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Feb 2012 22:34:06 +0000 X-ASF-Spam-Status: No, hits=-0.7 required=5.0 tests=RCVD_IN_DNSWL_LOW,SPF_PASS X-Spam-Check-By: apache.org Received-SPF: pass (nike.apache.org: domain of reich.mikey@gmail.com designates 209.85.161.175 as permitted sender) Received: from [209.85.161.175] (HELO mail-gx0-f175.google.com) (209.85.161.175) by apache.org (qpsmtpd/0.29) with ESMTP; Mon, 06 Feb 2012 22:33:57 +0000 Received: by ggeq1 with SMTP id q1so3197913gge.6 for ; Mon, 06 Feb 2012 14:33:36 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=message-id:date:from:user-agent:mime-version:to:subject :content-type:content-transfer-encoding; bh=T50LKZYFHLoIk6QU0wbG6nxMYkHn3hQqMg+RKgYo3Ao=; b=C56MIjhSWpt2ZLVoCHTOcef2LMkUy91VOCU9Dms4xYWnMlkwJH4a72JwM1PP9+09Xe ZceGNraS2s3RMsLetsM/kouNZyMCu6kjUG+fRCpJPWEC2qToDGTcixklUMOfgQq0sqBn 142Zavhy20xbqMhLhLb4mOMP+krijgsmWlHzk= Received: by 10.50.153.133 with SMTP id vg5mr12652344igb.8.1328567616686; Mon, 06 Feb 2012 14:33:36 -0800 (PST) Received: from Boris.local (d53-64-81-141.nap.wideopenwest.com. [64.53.141.81]) by mx.google.com with ESMTPS id r18sm29083397ibh.4.2012.02.06.14.33.34 (version=TLSv1/SSLv3 cipher=OTHER); Mon, 06 Feb 2012 14:33:35 -0800 (PST) Message-ID: <4F30553C.5000708@gmail.com> Date: Mon, 06 Feb 2012 16:33:32 -0600 From: Michael Reich User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.7; rv:9.0) Gecko/20111222 Thunderbird/9.0.1 MIME-Version: 1.0 To: ooo-users@incubator.apache.org Subject: Where Do Base Reports Store The Desired Query? Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org 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