Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » BIRT EXCEL OUTPUT(Delete the last row)
BIRT EXCEL OUTPUT [message #657978] Fri, 04 March 2011 19:04 Go to next message
Adrian  is currently offline Adrian Friend
Messages: 4
Registered: March 2011
Junior Member
Hi,

I was wondering if anyone knows how to delete the last blank row in an Excel file. I'm running a simple report but when I open the Excel file I found 2 rows below my data. 1 row is blank and the other is showing the date.

I deleted the date by removing it in the Master Page but I need to remove the blank row also and I haven't found a way to do that.

Thanks
Re: BIRT EXCEL OUTPUT [message #657990 is a reply to message #657978] Fri, 04 March 2011 20:07 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 199
Registered: July 2009
Location: Houston TX
Senior Member

That date element should have been sitting inside a grid element. Delete the grid element as well and you should be good.
Re: BIRT EXCEL OUTPUT [message #657992 is a reply to message #657990] Fri, 04 March 2011 20:53 Go to previous messageGo to next message
Adrian  is currently offline Adrian Friend
Messages: 4
Registered: March 2011
Junior Member
Hi,

I already deleted the grid and the blank row was showing up. However I did find a way to delete that row. In the master page properties I set the Footer height to 0 in.

Thanks
Re: BIRT EXCEL OUTPUT [message #657995 is a reply to message #657992] Fri, 04 March 2011 21:09 Go to previous messageGo to next message
Adrian  is currently offline Adrian Friend
Messages: 4
Registered: March 2011
Junior Member
Sorry but setting the footer height to 0 it's not working. I also set the bottom margin to 0 and I still have that annoying blank row.
Re: BIRT EXCEL OUTPUT [message #657996 is a reply to message #657978] Fri, 04 March 2011 21:10 Go to previous messageGo to next message
Richard A. Polunsky is currently offline Richard A. PolunskyFriend
Messages: 199
Registered: July 2009
Location: Houston TX
Senior Member

in your simple report is the table footer suppressed?

Re: BIRT EXCEL OUTPUT [message #657998 is a reply to message #657995] Fri, 04 March 2011 21:27 Go to previous message
Adrian  is currently offline Adrian Friend
Messages: 4
Registered: March 2011
Junior Member
Now I do solve it. The report is very simple. It's just a table that I need to export to XLS in order to manipulate the data using a pivot table. In the table I just needed to delete the footer Row.

Thanks
Previous Topic:IncompatibleClassChangeError when upgrading to 2.6.2
Next Topic:Automatically extracted BIRT FAQs
Goto Forum:
  


Current Time: Fri Dec 19 00:36:38 GMT 2014

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

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