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