report
I’ve created a report with 3 tables. Each was the result of a different query on the same universe. When the document is refreshed, the table created from the 1st query overlays the tables from the 2nd and 3rd tables. It appears to do this because the query for the 1st table is returning more rows than when it was originally created. Is there anyway to get the 2nd
and
3rd tables to dynamically reposition themselves based on the results of the 1st query?
Yes, it is possible to do this and it works well. Select the table and go to Format/Table. Choose the Appearance tab. The Vertical Position Relative To is the option to set. If you name all the tables then you should be able to select the name of the table that you wish the table to start after. I’m not sure if this is only possible if the tables are in the same section since this is the situation I have always used but I would assume you have that situation anyway.
Louise Priest
Fraser Williams Pharma Systems
lpriest@pharma.fraser-williams.com
Listserv Archives (BOB member since 2002-06-25)