how to set table layout & no repeat header

i have two question:
1.how to set table layout that data(over gigabyte) can indent closely with table header?
this mean can not indent one by one column depends on header.

2.how to let table/crosstab header no repeat (red column is a label in the cell)?
this want be one value in one row.

understand what i requirement?

Find more posts tagged with

Comments

mwilliams

Hi kevin23_hy,

Can you explain number one a little further?

For number two, are you talking about the red text? You only want it to show once? Or something else? For a standard table, you can deselect the checkbox next to repeate header on the page break tab of the property editor.

kevin23_hy

no1 means the table has over 500 rows and dozens of columns so that the spacing interval is too much wide between columns,i set checkbox "can shrink" just indented column but not to align/justify with header? how to
set spacing interval flexible?

no2 is a crosstab that the column area has a number of levels of group,which has a label text(red) to expression. just you said i want show once each column whether can do that or not and how?

mwilliams

kevin23_hy,

For #1, can you create a sample with the sample database that shows your issue and let me know what you're wanting to see?

For #2, can you attach your report design so I can see how you have your crosstab set up so I can look into only displying the red text once? Thanks.

kevin23_hy

there is a no2 sample as attachment.
run on birt2.3.2.

no1,i set pagebreak(page Break interval=20 means 20 rows per page,right?) but not work, how set?

mwilliams

kevin23_hy,

For getting rid of the red text, in your initialize script for your report, set a variable for each red text to 0, i.e. curTO = 0, familyTO = 0, etc. Then, on each label, use a visibility expression something like:

if (occupationTO == 0){
occupationTO = 1;
false
}
else{
true
}

This will cause just the first one to show and the others to be hidden. Hope this helps with the one issue.

kevin23_hy

not understand clearly,if convenience wish you give a sample that will be appreciated.

mwilliams

kevin23_hy,

Here's the sample you sent with the changes I made to get it to only display once. You'll probably want to change the way the labels are set up in the cells to make it look better with the visibility change.

kevin23_hy

dear mwilliams,
thx for give a solution but it has a decination of my requirement that it not only the each red text show only once in the first cell but also cross each columns align to center(means merge cells in one row) like a header tittle, clear? so there is a way to accomplish that? i will try to figure out,waiting feedback!

mwilliams

kevin23_hy,

Ah, I see what you mean now. I don't think you'll be able to merge them like that because of the structure of the crosstab. If I think of a way, I'll let you know.