Re: Reports 6i: showing data from another query

From: Noah Arc <bowed_zombie_drone.spam.begone_at_zombie.co.uk>
Date: Thu, 4 Oct 2001 15:09:46 +0100
Message-ID: <L4_u7.34053$uM2.4924535_at_monolith.news.easynet.net>


Thanks for that information.

[Quoted] In a query, can you reference a column from another query? So, in my example, could I select a column from Query A in Query B?

--
Noah Arc
Remove ".spam.begone"

Joost Bataille <j.r.l.m.bataille_at_uva.nl> wrote in message
news: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
> also enlarge. I repeat this till I have a clear picture of which frame is
in
> which other frame. The report should still run, of course, though the
layout
> will be changed.
> 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 - 16:09:46 CEST

Original text of this message