problem with cross tab width

Hi,

I've got another problem with my report...

It consists of multiple charts and cross tabs. Some of the cross tabs have >5 columns and leads to cross tabs that are wider than the size of the report. I found an thread which mentions a "fittopage"-option, but I cannot find that option somewhere.

As an alternative, it would also be possible to have every column seperated (in the example attached it would be seperated by Server1, Server2, etc)

Attached is a screenshot, which might help to understand my problem:

Edit:

I "solved" that problem by taking an page-break-interval of e.g. three columns, works so far.

But is there a possibility to have some space between these columns? Playing around with margin and padding did not lead to the expected result...

Find more posts tagged with

Comments

mwilliams

So, you've added a page break interval so that there is not a cut off? Where are you wanting the space? Between the sub groups or between the "server" groups?

h3llraid3r

Hi Michael,
thanks for your reply.

The space should be between the server groups, right. But there is no option like "column spacing"...

Any idea how to achieve that?

mwilliams

You might be able to add a dummy "derived measure" on the last column of each group and use that to space them out. Let me know if you have questions or if this doesn't work.

h3llraid3r

That's what I already tried, but I'm not able to add another vertical element in the cross tab.
If I add one, eclipse positions that above or below the "server" column.

I thought about an additional table, but that would just lead to a mottled "server" column.

mwilliams

Oh. So the space isn't what you want unless it shows a "space" cell between the headers as well? Could you put a grid in the server column header space and size it to coincide with the space below the header, so that there appeared to be a space?

h3llraid3r

I tried that, but there are two problems:

1) the border of the crosstab is visible in the "free area" (see image birt_crosstab_false.JPG )
2) the time column isn't displayed within every server part

To make it more clearly, I attached a sample image that shows how the report should look like (see birt_crosstab.JPG )

mwilliams

For the "border" line, you could "remove" the "border" by adding a border to the cell on the line you want to not show of the background color. This should hide the "border" lines of the cells.

As for repeating the row header information, you might try doing the same idea I said in my last post for the first measure field and add the time info in the first cell. Haven't tried it, but you might give it a go. If you have issues, let me know, I'll give it a try.