Skip to main content

Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Crosstab - Hide NULL dynamic column (also when exporting to Excel)
Crosstab - Hide NULL dynamic column (also when exporting to Excel) [message #1785754] Thu, 19 April 2018 10:59
Tomás Azevedo is currently offline Tomás AzevedoFriend
Messages: 1
Registered: April 2018
Junior Member

I've tried to find a solution to my problem on forums online, but with no luck.

I'm using BIRT 4.5.

I have the following dataset (example):

     1          |      ticket 1       |         os      |   windows 10
     1          |      ticket 1       |       RAM       |           8
     2          |      ticket 2       |       NULL      |        NULL

And I want to display the dataset in a table with the ATTR_DESC field as dynamic columns where the value is the ATTR_VALUE field.

I've managed to do this with a crosstab in the following format:

                                          |  dimension["AttrDescGroup"]["attr_desc"]
dimension["TicketIDGroup"]["ticketid"]    |  measure["attr_value"] (aggregate on: TicketIDGroup/ticketid,AttrDescGroup/attr_desc)

Now into the problem:

The table displays fine, but it displays an empty column of ATTR_DESC because this row in the dataset does not have any attributes (fields ATTR_DESC and ATTR_VALUE are NULL).

I have not managed to find a way to not display this empty row, to simply do not show the columns if the ATTR_DESC attribute is NULL.

If I don't add borders to the table this is fine, since the NULL column width is to small to notice. But when I export the report as XLSX, the empty column is there.

I'm sure people have faced this problem already, but I couldn't find an answer.

Can someone help me?

Tomás Azevedo
Previous Topic:Metadata for dataset
Next Topic:Aggregate values not appearing in excel
Goto Forum:

Current Time: Thu Nov 15 20:37:24 GMT 2018

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

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

Back to the top