Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    Mexico City
    Posts
    3

    Unanswered: Please HELP AGAIN !!!

    I need to create a report where I have to reference a table that is not related to the already linked tables, even if I make this table invisible, as soon as I try to insert a formula field that references a field from this independent table I get an error message ORA-01007 Variable not in select list.
    Is this problem fixable ? how can I reference a field in an independent table ?

    Please help !!!

  2. #2
    Join Date
    Apr 2004
    Location
    Germany
    Posts
    23
    There is no way to show the data of that unlinked table.
    The reason is, that if you use an independent table, for every row of a result multiplied by every row of the unlinked table has to be returned.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •