Re: Reports 6i: showing data from another query

From: Joost Bataille <j.r.l.m.bataille_at_uva.nl>
Date: Thu, 4 Oct 2001 14:31:25 +0200
Message-ID: <9phkqs$arp$1_at_mail.ic.uva.nl>


Noah wrote
> Won't doing it just cause "referencing at a frequency below its
group" -type
> errors?

That error ocurs when you've moved an item beyond the repeating frame it belongs to. If you move items in the layout editor you've got to take care about that.
If I have to do things like that I start with enlarging all the frames, starting with the outer frame. That can be done by pressing the 'select parent frame' button repeatedly till I've reached the most outer frame. I enlarge that frame and then try to find the next 'most outer' frame. That I [Quoted] also enlarge. I repeat this till I have a clear picture of which frame is in [Quoted] which other frame. The report should still run, of course, though the layout will be changed.
[Quoted] Then I do the fiddling with items of fields and check if the report still runs. Once it's OK I reduce the size of the frames again.

Another thing came to mind: can't you rewrite Query B to incorporate the information from Query A you need to see? That would make things a lot easier...

Good luck, Joost Received on Thu Oct 04 2001 - 14:31:25 CEST

Original text of this message