Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Cross Tab, hidden column appears in Excel
Cross Tab, hidden column appears in Excel [message #1792190] Thu, 12 July 2018 12:48 Go to next message
Alexander Scott is currently offline Alexander ScottFriend
Messages: 6
Registered: July 2018
Junior Member
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 12:49 Go to previous messageGo to next message
Alexander Scott is currently offline Alexander ScottFriend
Messages: 6
Registered: July 2018
Junior Member
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 09:52 Go to previous message
Alexander Scott is currently offline Alexander ScottFriend
Messages: 6
Registered: July 2018
Junior Member
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:
  


Current Time: Fri Mar 29 11:30:01 GMT 2024

Powered by FUDForum. Page generated in 0.02733 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top