Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Eclipse Projects » BIRT » Split combined cells in a crosstab
Split combined cells in a crosstab [message #1058900] Wed, 15 May 2013 11:32 Go to next message
Ivy Delaware is currently offline Ivy Delaware
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 00:52 Go to previous messageGo to next message
Michael Williams is currently offline Michael Williams
Messages: 828
Registered: July 2009
Senior Member
And you're wanting the output to be only like this in Excel, right? What is your BIRT version?

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

[Updated on: Thu, 16 May 2013 00: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 03:30 Go to previous messageGo to next message
Ivy Delaware is currently offline Ivy Delaware
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] Thu, 16 May 2013 23:38 Go to previous message
Michael Williams is currently offline Michael Williams
Messages: 828
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.

Regards,

Michael Williams
BIRT Exchange
Michael's BIRT Blog

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: Tue May 28 22:36:04 EDT 2013

Powered by FUDForum. Page generated in 0.01590 seconds