SERPland Flugverkehr/Airtraffic Zürich – Auto Direktimport Dänemark – Disneyland Paris – Legoland Deutschland

24Apr/073

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

Related Posts:

Comments (3) Trackbacks (0)
  1. okay sou how to make them to link
    because i don’t understand
    and i hawe this problem

  2. 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.

  3. good demo


Leave a comment

No trackbacks yet.