Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Birt 4.3.1 - Crosstab - Hiding default empty rows
Birt 4.3.1 - Crosstab - Hiding default empty rows [message #1622501] Wed, 18 February 2015 14:45 Go to next message
Mihnea Lazar is currently offline Mihnea LazarFriend
Messages: 6
Registered: February 2015
Junior Member
I have two crosstabs which I want to export in Excel format. Each crosstab has a minimum of 2 rows and 2 column, for aggregating data.

I only need 1 row for each crosstab.

How could I eliminate 1 of the default row in the crosstab?

Note: setting the height to 0 or 1 pixels did not work. Right now, I'm looking into scripts for this.
Re: Birt 4.3.1 - Crosstab - Hiding default empty rows [message #1622778 is a reply to message #1622501] Wed, 18 February 2015 18:49 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

So, your crosstab only returns a single result, but it's taking multiple rows and columns for each cell in the Excel output? Am I understanding correctly? Let me know.

Michael

Developer Evangelist, Silanis
Re: Birt 4.3.1 - Crosstab - Hiding default empty rows [message #1623565 is a reply to message #1622778] Thu, 19 February 2015 07:01 Go to previous messageGo to next message
Mihnea Lazar is currently offline Mihnea LazarFriend
Messages: 6
Registered: February 2015
Junior Member
I have included a screenshot of the rpt design and of the xls output.

Here on the .rptdesign, I have marked with red the area that I want to eliminate from appearing on the output.
index.php/fa/20904/0/

And here, on the .xls file, I have also marked with red the rows that appear and should not appear there.
index.php/fa/20906/0/

Can this be done via a script? If so, I'd like to know how to write that and where exactly, on which function to place it. I have researched sure scripts, but haven't been able to successfully implement a functional one.

[Updated on: Thu, 19 February 2015 07:03]

Report message to a moderator

Re: Birt 4.3.1 - Crosstab - Hiding default empty rows [message #1624193 is a reply to message #1623565] Thu, 19 February 2015 16:25 Go to previous messageGo to next message
Mihnea Lazar is currently offline Mihnea LazarFriend
Messages: 6
Registered: February 2015
Junior Member
Found solution: I selected each cell of the crosstab, went to its Property Editor -> Advanced -> Section -> Display -> set display to "No Display"
Re: Birt 4.3.1 - Crosstab - Hiding default empty rows [message #1624245 is a reply to message #1624193] Thu, 19 February 2015 17:07 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member

The screenshots helped a lot in letting me see what you were meaning. You have the solution I would have suggested after seeing those. Glad you found it. Smile Let us know if you run into any other issues.

Michael

Developer Evangelist, Silanis
Previous Topic:Birt 4.3.1 - Different output on XLS and XLSX for crosstab
Next Topic:BIRT-Designer: Adding custom plugins
Goto Forum:
  


Current Time: Mon Nov 19 17:24:30 GMT 2018

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

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

Back to the top