Re: Reports 6i: showing data from another query

From: Joost Bataille <j.r.l.m.bataille_at_removethis.uva.nl>
Date: Wed, 3 Oct 2001 18:40:39 +0200
Message-ID: <9pff25$po8$2_at_mail.ic.uva.nl>


Hello Noah, you wrote

> It has 2 queries with a link between them; Query A is the
> parent and Query B is the child.
>
> One of the pieces of information I select in Query A, I'd
> like to show along with the information shown from Query
> B.
>
> I've tried using both a placeholder and a summary column
> in the Query B group to select the value from Query A and
> display it in a field, but both cause errors when I try to run
> them.
>
> The only other way I could think of doing it would be to
> move the selected column to Query B, but that'd be
> defeating the purpose of how the queries are currently
> set up.

You can create a field in the layout editor in the repeating frame of query [Quoted] B. Then you set the source of this field to the item that you want 'copied'.

[Quoted] Hope this helps, good luck.
Joost Received on Wed Oct 03 2001 - 18:40:39 CEST

Original text of this message