Re: Report Builder: ORA-00000 Error - Help

Helo Gigio,

Gigio wrote:
>
> >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

If you want to use only ONE common column shared between the two groups, you should use column-to-column data link.

But you should understand that if you use group-to-group data link, your data link will use ALL COMMON COLUMNS shared between the two groups... And you won't be able to see the list of them in the Property Palette of that link...

> If I don't do this, no join are created and so in the child query I
> obtain more records than needed.

If you use link, for each record in the master group the detail query is executed based on the master record...

> In this way there are no difference among the 3 data-links, since the
> result is the same (also the error is the same).

The result shouldn't be the same... There are exact differences among 3 types of data links...

The result will be the same only if you have only one common column shared between the two queries and if it is foregn key too... :-)

> 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?

Just draw two data links between master and each details:

   master
   / \
detail detail

Hope that helps.

> 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.
> Hope I am not too tedious....

> Are you starting to hate me? :)))

Not at all :-) Perhaps my English is problem...

Bye
Valeri

> ;)
> 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!

-- 
Valeri Sorokine
Oracle Certified Application Developer, Rel.2
ProSoft, Russia, Moscow, Information Systems Division
Phone: +7 (095) 234 0636 ; FAX: +7 (095) 234 0640
E-mail: vsorokin_at_dd.ru   ; http://www.dd.ru