Odd Crosstab Preformance

Greetings,

I have been in the process of hiding rows from crosstabs, and it has been working thus far. However I have ran into an interesting problem.

One of our reports has 14 crosstabs, and in 10 of the 14, we have to hide rows. I have been using the following to hide each cell in a row:

function hideCell()
{
cellInst.getStyle().setDisplay("none");
cellInst.getStyle().setMarginTop("0");
cellInst.getStyle().setMarginBottom("0");
cellInst.getStyle().setMarginLeft("0");
cellInst.getStyle().setMarginRight("0");
cellInst.getStyle().setPaddingTop("0");
cellInst.getStyle().setPaddingBottom("0");
cellInst.getStyle().setPaddingLeft("0");
cellInst.getStyle().setPaddingRight("0");
cellInst.getStyle().setBorderBottomStyle("LINE_STYLE_NONE");
cellInst.getStyle().setBorderBottomColor("#000000");
cellInst.getStyle().setBorderBottomWidth("0px");
cellInst.getStyle().setBorderTopStyle("LINE_STYLE_NONE");
cellInst.getStyle().setBorderTopColor("#000000");
cellInst.getStyle().setBorderTopWidth("0px");
cellInst.getStyle().setBorderLeftStyle("LINE_STYLE_NONE");
cellInst.getStyle().setBorderLeftColor("#000000");
cellInst.getStyle().setBorderLeftWidth("0px");
cellInst.getStyle().setBorderRightStyle("LINE_STYLE_NONE");
cellInst.getStyle().setBorderRightColor("#000000");
cellInst.getStyle().setBorderRightWidth("0px");
}

It has worked so far, but on the last two crosstabs, crosstab #11 and #12, they appear to partially hide the rows, but not entirely. I have attached a image of what is happening.

This is also happening in another report using the same function in crosstab #4 out of 4. We use this function in all 4 crosstabs on this report, and on 10 of the 14 on the other one.

So far, I have seen no pattern as to why this would be happening.

We are using BIRT 2.5.0.

If it helps, the way we have the report formatted goes like this: Grid -> Table -> Crosstabs for the report with 4 crosstabs. In the report with 14 crosstabs, there are two tables in the grid, and in the first table, there are 10 crosstabs with the remaining 4 being in the second table.

Any assistance would be very much appreciated.

Thank you,

Jordan Trulen

Find more posts tagged with

Comments

mwilliams

Hi Jordan,

Can you recreate the issue with the sample database?

Lianite

Never mind, I was going through the function to hide the cells and verifying every line, and found that I had made a mistake in the function.

Instead of the function that I had posted earlier, I replaced it with the following:

function hideCell()
{
cellInst.getStyle().setDisplay("DISPLAY_NONE");
}

So far that has been working. I'll give you an update once I finish testing everything.

Thank you.

mwilliams

Jordan,

Sounds good. Just let me know!

Lianite

I have completed about 75% of the testing and everything is as it should be now.

Thank you,

Jordan Trulen

mwilliams

Perfect!