Crosstab - Hide NULL dynamic column (also when exporting to Excel) [message #1785754] |
Thu, 19 April 2018 10:59 |
Tomás Azevedo Messages: 1 Registered: April 2018 |
Junior Member |
|
|
Hello,
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):
TICKETID | DESCRIPTION | ATTR_DESC | ATTR_VALUE
----------------------------------------------------------------------------
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?
Thanks,
Tomás Azevedo
|
|
|
Powered by
FUDForum. Page generated in 0.03867 seconds