Eclipse Community Forums: BIRT » Cross Tab, hidden column appears in Excel

Home » Archived » BIRT » Cross Tab, hidden column appears in Excel

Cross Tab, hidden column appears in Excel [message #1792190]

Thu, 12 July 2018 08:48

Eclipse User

I have tried hiding the cross tab columns by setting the cell visibility, the style to 'display: none', the width and height to 0.

All these techniques work perfectly for HTML, but when I export to Excel I get a blank column.

How can I get around this?

Re: Cross Tab, hidden column appears in Excel [message #1792191 is a reply to message #1792190]

Thu, 12 July 2018 08:49

Eclipse User

Using Report Designer 4.4.2.

Re: Cross Tab, hidden column appears in Excel [message #1792343 is a reply to message #1792191]

Mon, 16 July 2018 05:52

Eclipse User

My solution to the problem;

Add a concatenated column to the result set (a || b). Created a grouping based on the concatenated column. Set the width of the column to 0 (and make sure the report layout is 'fixed layout').

Previous Topic:	Datacube: average values
Next Topic:	Last cell value depends on previous Cells

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jul 20 03:36:01 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter