Oracle Reports Query not linkable: REP-20147 error (group link)

24Apr/072

Oracle Reports Query not linkable: REP-20147 error (group link)

In Oracle Report you can not link query blocks on items when you see this No-Link Item:

Cannot implement column link for this detail SQL query. Converting to group link.

oracle reports query item not linkable picture

This means you can link block, but you can not link specific item as you would usually like to do.
It seems there's somethin special in this query. When trying to link two items:

oracle reports column link group picture

A Oracle REP-20147 error appears:

Cannot implement column link for this detail SQL query. Converting to group link.

Help Message:
REP-20147: Cannot implement column link for this detail SQL query. Converting to group link Cause: Reports can only insert column to column links into supported SQL. It defaults to a group to group link in this case. Action: Manually insert the required link clause into the detail SQL query.

The problem here is in the sql query!

ORDER BY something NULLS FIRST

Try removing the NULLS FIRST and the No-Link item disappears. Now you can link these two query on an item:

oracle reports column link no nulls first picture

Bookmark It

Tagged as: oracle, Oracle Report, Oracle Reports, Query Blocks, Somethin, Sql Query Leave a comment

Comments (2) Trackbacks (0) ( subscribe to comments on this post )

maria
March 21st, 2008 - 12:43

okay sou how to make them to link
because i don’t understand
and i hawe this problem
admin
March 23rd, 2008 - 16:55

Hi Maria
Linking is easy. Just use the toolbox on the left side.
There you choose “link block” or something like this.
Klick on a column on block 1 then move cursor to block 2 and “drop” your mouse on the linking column on block 2.

No trackbacks yet.

« Toad 9 default options which should be changed uml inheritance diagram: oracle numeric datatypes »

Error / Problem: select statement returns no rows – but result set contains about 3 rows (from CW_ALL_DB_LINKS / sys.link$ / Oracle9i) CAST Application Mining Error/Problem: Following select statement returns no rows - but result set...

Oracle SQL: Summarize a calculated column (like a count(*) column) with ROLLUP You have a simple sql statement like this: select machine, count(*) as users from v$session group...

Oracle SQL Error: ORA-04052 error occurred when looking up remote object (ora-604/ora-2019) Oracle: Trying to use a package via db-link ends in a ORA-04052 ! Deutsch/German ORA-04052 Error ORA-04052:...

Oracle and XML: works with Oracle9i, 10g, 11g and higher select xmlforest(name,vorname) as Employeedaten from emp where empno in (1,2) ; <NAME>Hilton</NAME><VORNAME>Paris</VORNAME> select...

Grab This Widget

Custom Search

SERPland Oracle, PL/SQL, PHP, Autos, Bungalow-Hotels and more …