Eclipse Community Forums: BIRT » Birt 4.3.1 - Crosstab

Home » Archived » 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 09:45

Eclipse User

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 13:49

Eclipse User

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.

Re: Birt 4.3.1 - Crosstab - Hiding default empty rows [message #1623565 is a reply to message #1622778]

Thu, 19 February 2015 02:01

Eclipse User

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.

Attachment: rptdesign.png
(Size: 25.79KB, Downloaded 954 times)
Attachment: xlsoutput.png
(Size: 14.28KB, Downloaded 959 times)

[Updated on: Thu, 19 February 2015 02:03] by Moderator

Re: Birt 4.3.1 - Crosstab - Hiding default empty rows [message #1624193 is a reply to message #1623565]

Thu, 19 February 2015 11:25

Eclipse User

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 12:07

Eclipse User

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.

Previous Topic:	Birt 4.3.1 - Different output on XLS and XLSX for crosstab
Next Topic:	BIRT-Designer: Adding custom plugins

Goto Forum:

-=] Back to Top [=-

Current Time: Tue Jul 08 21:15:30 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter