Space between two crosstabs

building reports desktopintelligence
1

Hi,
Attached sheet is the structure of the report.
There is a space between two crosstabs. If I remove the space, place the second crosstab just below the first one and go back to view the report, the first crosstab data overlaps over the second crosstab. So I have to assign a space between the two crosstabs.
If the data in the first crosstab is less, then there is a space between the two, which I don’t want. I want it to adjust automatically.

Is ther any setttings I need to do?
Any Suggestions?

Please help.

Thanks in advance!
crosstab.doc (30.0 KB)

sam_dabs (BOB member since 2008-09-25)

2

Have you tried positioning the top of the second crosstab relative to the bottom of the first?

Damocles :uk: (BOB member since 2006-10-05)

3

I tried but still no luck…

sam_dabs (BOB member since 2008-09-25)

4

Hi :slight_smile:

It should work. May be you are missing something.
Is this what you are doing - setting the relative position in Format -> Table -> Appearance

Prashu :india: (BOB member since 2005-08-17)

5

Nope. I am just picking up the crosstab and placing it below the first crosstab.
Am I missing something or do I have to do in some other way?

Thanks!

sam_dabs (BOB member since 2008-09-25)

6

Hi,

As suggested by Prashu, go to Format -> Crosstab -> Appearance,
In Vertical Position Relative to - select Crosstab1

soni_ak :india: (BOB member since 2008-09-15)

7

Hey Hey It worked.

Thanks Soni, Prashu, and Damocles for your contibution. I really mean it.

sam_dabs (BOB member since 2008-09-25)