Re: Reports 2.5 Master Detail Problem

Steve,
In Object Navigator, expand the Layout node by clicking on it's (+). Then expand the Layout Body the same way. This will show you all your frames and field hierarchies. Select frames in the Object Navigator and then click on the Layout Editor header to make that the active window (don't click within the layout editor because that would deselect the frame you just selected in the Object Navigator). Using the Object Navigator is helpful so you know you have the intended frame selected. It's difficult to distinguish between frames in the Layout Editor. Change the frame's fill color. Do different fill colors for all frames and fields in question and you will see when one frame is overlapping another.

REP-1213 Field <> references column <> at a frequency below its group.

This error occurs when a field has been put in a layer somewhere behind it's group's repeating frame. This could have unintentionally happened when you were moving fields around.

Say you have 2 groups: G_MASTER and G_DETAIL and G_DETAIL

The frame for G_MASTER should be BEHIND the frame for G_DETAIL. You will see this layering when you fill color the frames. Fill color the field in question as well. You will should see that the field does not show up on top of it's repeating frame as it should. To move it to the proper layer, use the ARRANGE option and use Bring Forward until you see the field(s) on top of their group frame.

Hope this helps,
Kris Kuhl  

In article <335F81A4.470A_at_mitchells.demon.co.uk>, steve_at_mitchells.demon.co.uk says...
>
>
>I would like to produce a Master-Detail report where each master
>record can have one detail record from one and only one of
>four detail tables.
>
>On the page layout the master record occupies the top third of the
>page, and the subsequent detail record will occupy the remaining
>page.
>
>I put each detail frame one below the other, expected reports to
>collapse the frames that were not relevant to the master record and
>show the relevant detail frame below the master.
>
>This failed because the detail frames collectively are larger the page
>boundary, and reports fails to run with:
>
> REP-1212 Object < > is not fully enclosed by its
> enclosing body.
>
>I then stacked the detail frames on top of each other (creates a real
>mess in the layout editor). Reports complains with the following
>messages:
>
> REP-1305 Warning frame < > intersects but does not
> enclose object < >.
>
> REP-1213 Field < > references column < > at a frequency
> below its group.
>
>I would be grateful for any help on how to overcome this problem.
>
>Reports 2.5.5.2.7
>Server 7.2.3
>Client NT 3.51
>
>Steve
Received on Fri Apr 25 1997 - 00:00:00 CEST