Shifting Cell values up.

I have a case statement in birt where if the condition is met it will display the data values in that cell, else it will display a blank row.

However, when it displays a blank row, I want the cell values from below the blank row to shift up so as not to leave a large gap. Can this be done in BIRT and how?

Thanks.

Find more posts tagged with

Comments

mwilliams

Are there other values in the same row? So, this one column's values would be moving up independent of the other values in the row? Can you explain further?

rmendonsa

The case statement is as follows....
Case when Detail.description is not null and Detail.Detailtype = 'INSTRUCTION'
then Detail.description Else ' ' End as TailoringInstruction.

I have attached a screen print of the results showing a gap between the Label "Tailoring Instructions" and the data. This is because the first row in the cell is blank as it did not meet the above condition. I would like for the second row which is not blank, to move up in order to narrow that gap. This shifting of cell data needs to take place everytime there is a blank row. Is this possible?

Thanks for your help.

mwilliams

What is in the column to the right that that I can only see part of? Is there other data in the dataSet row associated? Or are these linked to different dataSets? Can you show me some of your dataSet data for all columns of the dataSet if more than just one and show me the layout of your report if more than once column in your table and where you're doing this case statement? Thanks.

rmendonsa

Hi Michael,

I have attached a pdf copy of the report.

Thanks.

-Raynah

mwilliams

Can you attach the actual report design? If you can't attach it in here because of company rules, you can email it to me at mwilliams@actuate.com.

rmendonsa

Hi Michael,

I just sent you the report design file via email.

Regards,

-Raynah