Column value suppression in the middle columns in report

Question

Hi friends,

Im in obiee 11g. I have a report where im getting the column value suppression issue. Find the below screenshot

In the above report on the 3rd row, you can see that the customer name and invoice date column values are suppressed and then u can see line number 1 and 2 which is different and that is fine. After this line number column you can see the organization and the currency column which has the same value has to suppress since in the column properties i specified it as suppress but it is not happening and it is repeating. And also the measure columns total invoice amount and remaining invoice amount column also needs to suppress. How can i achieve this in the report. Is there a possible way.

Thanks in advance.

Regards,

Saro

Saro · Answer

Thanks Gianni, for the right explanation;-)

Regards,

Saro

Gianni Ceresa · Answer

Suppression is a left to right thing, it suppress as much as configured from left to right, but when your "Line number" column is reached it can't suppress and merge the cells of "Organisation" as they are related to different "Line number". So "Line number" stop the suppression of other columns and any other column on the right can only be suppressed by "Line number" (so if many rows with same "line number" and same "Organisation" it will suppress it again).

Saro · Answer

Dear Thomas,

Thanks for the reply. If that so, then my attribute column organization and invoice currency is repeating, even though i marked it as a suppress under column properties.

Is it possible to suppress them.

If i move my attribute column organization and invoice currency before my line number columns means, then the values of organization and invoice currency column is suppressing. But i need these columns organization and invoice currency to be placed after my line number column only as per the layout of my report.

What could be the possible solution for this?

Regards,

Saro