Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » BIRT » Split combined cells in a crosstab
Split combined cells in a crosstab [message #1058900] Wed, 15 May 2013 15:32 Go to next message
Ivy Delaware is currently offline Ivy DelawareFriend
Messages: 2
Registered: May 2013
Junior Member
When I have a crosstab the cells that contain the same value are merged/ combined automatically.
It looks nice but when I export it in Excel and then want to filter/sort the columns Excel does not allow me to do so as the cells are merged.

Thus, I am looking for a way that the cells are NOT merged in the BIRT crosstab.
Is there any solution?

e.g.

2013 |2012
----------------------------- ...
05|04|03|02|01|12|11|10|09|08|...

should be


2013|2013|2013|2013|2013|2012|2012|2012|2012|2012|...
-----------------------------------------------------
05 |04 |03 |02 |01 |12 |11 |10 |09 |08 |...

Report message to a moderator

Re: Split combined cells in a crosstab [message #1058968 is a reply to message #1058900] Thu, 16 May 2013 04:52 Go to previous messageGo to next message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member
And you're wanting the output to be only like this in Excel, right? What is your BIRT version?

Michael

Developer Evangelist, Silanis

[Updated on: Thu, 16 May 2013 04:53]

Report message to a moderator

Re: Split combined cells in a crosstab [message #1058994 is a reply to message #1058968] Thu, 16 May 2013 07:30 Go to previous messageGo to next message
Ivy Delaware is currently offline Ivy DelawareFriend
Messages: 2
Registered: May 2013
Junior Member
Dear Michael,
we use BIRT Version 2.6.2.
The user requiremet is that they can save the export in Excel without any merged cells so that filtering and sorting in Excel works right away without having to adapt the Excel file manually every time.
If this means that the cells are also NOT merged in the online Version I think this would be accepted.

Ivy

Report message to a moderator

Re: Split combined cells in a crosstab [message #1059155 is a reply to message #1058900] Fri, 17 May 2013 03:38 Go to previous message
Michael Williams is currently offline Michael WilliamsFriend
Messages: 1925
Registered: July 2009
Senior Member
Take a look at this. I wrote a computed column to give the first day of the month of the date field, then created two cubes with the dataSet. One of them uses the original date field with Year and Month selected for the grouping options. The other uses the computed column. I use the field twice to replicate what your example looked like and formatted the top as the year and the bottom as the month. Finally, I named both crosstabs, so that in the beforeFactory, I could check the output format and drop the appropriate crosstab from the report and switch the layout preference to auto for XLS as well.

Hope this helps.

Michael

Developer Evangelist, Silanis

Report message to a moderator

Previous Topic:how-to-get-a-x-axis-label-value-by-parameter-in-bar-chart
Next Topic:BiRT with big dataset->viewing the report during creating the report document
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 02:52:41 GMT 2024

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

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

Back to the top

Sign up to our Newsletter

A fresh new issue delivered monthly