BusinessObjects Board

Break between two tables.

building reports desktopintelligence
#1

Hello
I have a report that has two tables on on the top of the page and the other on the bottom of the page. The top table brings in data based on what the user entered in the prompt and the bottom table brings in data from the Warehouse with some numbers. The top table has a wrap in one of the cells to wrap the data to a different line.

Now what happens is if the user selects lot of values in the prompt then the top table because of the wrap gets pushed down and overlaps the bottom table and the user is not able to see the numbers in the bottom table. How do I put a page break or something so that the data does not get overlaped.

Hope I am clear about this,

Thanks

ddsrini (BOB member since 2004-06-23)

#2

Does this post help?

Andreas :de: (BOB member since 2002-06-20)

#3

I found the answer when I changed the search words.

Thanks

ddsrini (BOB member since 2004-06-23)

#4

Please, share the answer you found to your problem :wink:

Andreas :de: (BOB member since 2002-06-20)

#5

This is where I found it.

Now I have another issue. One of the cells has lot of data. The table overlap is taken care of but the cell is not growing to show all the data. What ever size I set for the cell, only that much of data is showing up. The other data is not visible at all.

Any workaround for that???

Thanks

ddsrini (BOB member since 2004-06-23)

#6

Have you set the format for that text - on the Alignment tab - to Wrap Text and to Row by Row Autofit?

Anita Craig :us: (BOB member since 2002-06-17)

#7

Thanks Anita. I did that and it worked.

ddsrini (BOB member since 2004-06-23)