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

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