This content has been marked as final. Show 2 replies
Looks like we don't currently support this.
It looks like we're looking for the :BIND in the SELECT and the WHERE but not in the FROM
I doubt that you can get dynamic from clause for Child Report if its style is table.
But you can get dynamic one in child with style script:
Say you have :
Master report for list tables which select owner and table name by some condition (I omit this):
So Child Report
select owner, table_name from all_tables ..
SQL is follow:
Hope it help.
COLUMN TN NEW_VALUE TNAME ; select :OWNER||'.'||:TABLE_NAME as TN from dual; select '&&TNAME' as tab_NAME, count(1) from &&TNAME;
Edited by: K_Serge on Jan 5, 2013 5:10 AM
Edited by: K_Serge on Jan 5, 2013 5:20 AM