Some Eclipse Foundation services are deprecated, or will be soon. Please ensure you've read this important communication.

Bug 343167

Summary:	Column which Display has been set to No Display still shows up in xls produced by xls emitter
Product:	z_Archived	Reporter:	Low Kian Seong <kianseong>
Component:	BIRT	Assignee:	Birt-ReportEngine-inbox <Birt-ReportEngine-inbox>
Status:	RESOLVED INVALID	QA Contact:	Xiaoying Gu <bluesoldier>
Severity:	major
Priority:	P3	CC:	bluesoldier, kianseong
Version:	2.6.2
Target Milestone:	3.7.0
Hardware:	PC
OS:	Linux
Whiteboard:	Obsolete

Description Low Kian Seong

2011-04-18 11:35:00 EDT

I have a report which I want to hide one of the columns in the column side's Grand Total. Following a guide online I have set the whole column's (each cell in the column) Display in Section->Display as "No Display". When I preview my report, I see an empty column at the end of my Cross Tab and when I generate the report using the xls emitter, an empty column without any data shows up.

Comment 1 Xiaoying Gu

2011-04-19 05:48:23 EDT

There seems to be some error in the description.
No display is not supported in xls emitter now, so the grand total data will be show up in the xls, while it will be hide in html preview. 

But for crosstab, the grandtotal column will not be hide, only the data will. This is different from normal table. Since the grandtotal column is not actually not a complete column.

Comment 2 Low Kian Seong

2011-04-19 06:05:39 EDT

(In reply to comment #1)
> There seems to be some error in the description.
> No display is not supported in xls emitter now, so the grand total data will be
> show up in the xls, while it will be hide in html preview. 
> 
> But for crosstab, the grandtotal column will not be hide, only the data will.
> This is different from normal table. Since the grandtotal column is not
> actually not a complete column.

How would I go about truly hiding a column in the grandTotal area then? Is there a way to do it ? I don't even want an empty column appearing.

Comment 3 Xiaoying Gu

2011-04-19 20:59:40 EDT

(In reply to comment #2)
> (In reply to comment #1)
> > There seems to be some error in the description.
> > No display is not supported in xls emitter now, so the grand total data will be
> > show up in the xls, while it will be hide in html preview. 
> > 
> > But for crosstab, the grandtotal column will not be hide, only the data will.
> > This is different from normal table. Since the grandtotal column is not
> > actually not a complete column.
> 
> How would I go about truly hiding a column in the grandTotal area then? Is
> there a way to do it ? I don't even want an empty column appearing.

Is there any reason that you want to hide the grandtotal other than removing it from the design directly?

Comment 4 Low Kian Seong

2011-04-19 21:40:09 EDT

(In reply to comment #3)
> (In reply to comment #2)
> > (In reply to comment #1)
> > > There seems to be some error in the description.
> > > No display is not supported in xls emitter now, so the grand total data will be
> > > show up in the xls, while it will be hide in html preview. 
> > > 
> > > But for crosstab, the grandtotal column will not be hide, only the data will.
> > > This is different from normal table. Since the grandtotal column is not
> > > actually not a complete column.
> > 
> > How would I go about truly hiding a column in the grandTotal area then? Is
> > there a way to do it ? I don't even want an empty column appearing.
> 
> Is there any reason that you want to hide the grandtotal other than removing it
> from the design directly?

I just need the values in the column for calculations not for display, but I need the values from the grandTotal column

Comment 5 Xiaoying Gu

2011-04-20 01:49:20 EDT

In such case, you should create aggregation in the binding page of crosstab instead of creating the grand total in layout.

Comment 6 Low Kian Seong

2011-04-20 21:52:24 EDT

Okay. The suggestion works. going to close it.