i have to place two tables one below the other in a report. report data varies based on the input parameter and hence the two tables are always overlapping. is it possible to make the second table appear below the first table without overlapping?
Muna 
(BOB member since 2008-08-05)
right click on the lower table and then click Format Table -> then go to appearnce tab and set the Horiozontal position and vertical position relative to first table.
BO_Stuffed (BOB member since 2008-03-29)
Adjust the alignment from Format Table - > Appearance and adjust the vertical position with respect to table 1.
I am sorry. I think BO_Stuffed and me gave the same answer more or less at the same time.
So to add up something, I would suggest you to align all the tables in that way, so that you could avoid such problems later on other tables as well.
Jansi (BOB member since 2008-05-12)
Hi Nish
To achieve the presentation youÂ’re looking for youÂ’ll need to follow these steps:
[list]Right-Click the second table and select the ‘Format Table’ option
On the ‘Appearance’ tab change the ‘Vertical Position Relative to’ to be the name of the first table (probably Table 1).
Change the ‘Top’ value to control the amount of space between your first and second table[/list]
Run the report with a few different parameters to change the row count in table 1 just be to sure the presentation is as you would expect 
Cheers
ShaneB 
(BOB member since 2005-02-25)
it works… 
thanks all. 
Muna (BOB member since 2008-08-05)
Hi
We do have a Best Practice document to keep the standard information related to the report formating. It covers the font size of the report header, column header, alignment of tables, data, and the relative position between the tables if the document contains multiple table, Page number format etc.etc…
Naaz, you can also try to create such a generic document and share with your team… This is very helpful for the people who’s new to your team 
Regards
Siva.M
looksmee 
(BOB member since 2006-02-08)
hi all…
i selected horizontal position relative to left margin and
vertical position relative to table 1.
now the two tables look one below the other in the report. however, when i export it to excel sheet, the two tables are not coming one below the other as in the report. excel sheet shows two tables diagonally as shown in the attachment.
any clues??
Muna 
(BOB member since 2008-08-05)
I too had such an issue once. Later it got solved but again by working around those options. See this thread as well as the thread given inside it.
Jansi (BOB member since 2008-05-12)
Hi
Format all your Table by selecting “Centre Across the Page” or Left Align/Right Align.
Regards
Siva.M
looksmee (BOB member since 2006-02-08)
it is working fine now. the problem was due to improper formatting. thanks all for your suggestions…
Muna (BOB member since 2008-08-05)