Microsoft KB Archive/164269

Mac Works 4.0: Draw Objects Disappear in Filtered Report

PSS ID Number: Q164269 Article last modified on 10-22-1998

4.00 4.00a 4.00b 4.00c 4.5

MACINTOSH

=
=========================================================

= SYMPTOMS =

When you insert a Draw object into a Database report, if you filter and group the report, the Draw object may disappear.

= CAUSE =

When you create a report with groups, if you also apply a filter, the filter may void the grouping option and this causes the Draw object to disappear.

For example, if your report is grouped by teacher your report will display a list of students for each teacher. However, if you then apply a filter that filters only Dr. Smith’s class, then the group element has been voided.

= RESOLUTION =

Create two reports. Set up the first report to group your information. Set up the second report if you want to apply a filter that may void the grouping option.

= MORE INFORMATION =

In the following example, this problem only occurs when the filter voids the group option. If your filter includes Name begins with B or Name begins with D, the draw object will not disappear.

Steps to Reproduce the Behavior
  Create a database with the following information: Field Name: Name Data: Bob Barbara Denise Edward Adam Amy   Create a report with the following criteria: Report Name: TEST 1 Report Fields: Add all fields Display Options: Show Field Names At Top Of Each Page Display Options: Show Data Report Sorting: Sort By NAME A to Z Report Grouping: Group NAME With Same First Letter Report Filter: Show all Report Summary: No summary information. Click Done.   On the Format menu point to Report Options then slide to Layout.   Drag the horizontal bar labeled “Group Title: name” down.   In the gap between “Page Heading” and “Group Title: name” insert a Draw object. For example on your tool palette click the circle tool and draw a circle in the gap.   On the Format menu point to Report Options then slide to Layout so you can view your data. You will see your data is grouped and the Draw object you created in step 5 above is visible.   To make the Draw object disappear, on the Format menu point to Report Options then slide to Layout.   On the Format menu point to Report Options then slide over to Filter. </li>  Click Create New Filter. </li>  Name the filter: Name Starts with B </li>  Under the Field heading choose “name”. </li>  Under the Comparison heading choose “begins with”. </li>  Under the Compare to heading type in “b” (without the quotation marks). </li>  Click OK. </li>  Click Done. </li>  On the Format menu point to Report Options then slide to over to Layout. You will be viewing your filtered data. Only Bob and Barbara will appear. Also, note the draw object is visible here. </li>  On the File menu click Print Preview. The draw object disappears. </li>  Click Cancel to return to report view. The draw object is missing from this view as well. </li></ol>

When you change to Layout view, the draw object will be present above the Group Title line. However because nothing is being grouped (based on the present filter) all the information above the Group Title bar will disappear.

KBCategory: kbdisplay KBSubcategory: Additional reference words: 4.00 4.00a 4.00b 4.00c gone missing lost ====================================================================== Version : 4.00 4.00a 4.00b 4.00c 4.5 Platform : MACINTOSH ============================================================================= Copyright Microsoft Corporation 1998.