A non-linkable query is a detail query that contains column objects that prevent
the query from being linked to with a column-to-column link (when you create
a column-to-column link, Reports Builder adds a WHERE
clause to
your query). If you attempt to create such a link, a message dialog box displays,
which prompts you to choose whether to create a group-to-group query (using
the parent groups), or to cancel the operation. A non-linkable query displays
in
its title bar.
Instead, you can create a group-to-group link (when you create a group-to-group
link, Reports Builder does not add a WHERE
clause to your query)
between the two queries and add a WHERE
clause to the child query’s
SELECT
statement, using a bind variable to reference the parent
column.
For example, suppose you want to create a column-to-column link between the
ADDRESS.STREET
column in your child query and the LOC1
column in your parent query. You can create
a group-to-group link, and then modify the child query SQL statement to
say:
SELECT * FROM EMP E WHERE E.ADDRESS.STREET = :LOC1
See also
Copyright © 1984, 2005, Oracle. All rights reserved.