Re: Report Builder: ORA-00000 Error - Help

>So, if there are some similar (the same) columns in both groups, you
>can use group-to-group data link. In that case all those columns will
>be used in that data link. What's wrong with this in your case? You
>want just two columns but there are more?
Ehm... sorry! when you create a group-to-group data link, no columns are used at all (this happens in query-to-query and column-to-column data link)! Instead I need to specify in the where clause of the child query which field must join to the parent query with a where clause like this
> where childcolumn = :parentcolumn

[Quoted] If I don't do this, no join are created and so in the child query I obtain more records than needed.
[Quoted] In this way there are no difference among the 3 data-links, since the result is the same (also the error is the same). [Quoted] But I want to try to change the problem.... If I create a unique query, how can I create 1 master and two details at the same level? [Quoted] Initially, my report had a unique query and 1 master - 2 details configuration; but the first child was master of the second child... and this was not good. Both the childs must have the same master. [Quoted] Hope I am not too tedious.... Are you starting to hate me? :))) ;)
Bye
Gigio

• Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free!