Eclipse Community Forums: BIRT » Split combined cells in a crosstab

Home » Archived » BIRT » Split combined cells in a crosstab

Split combined cells in a crosstab [message #1058900]

Wed, 15 May 2013 11:32

Eclipse User

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 |...

Re: Split combined cells in a crosstab [message #1058968 is a reply to message #1058900]

Thu, 16 May 2013 00:52

Eclipse User

And you're wanting the output to be only like this in Excel, right? What is your BIRT version?

[Updated on: Thu, 16 May 2013 00:53] by Moderator

Re: Split combined cells in a crosstab [message #1058994 is a reply to message #1058968]

Thu, 16 May 2013 03:30

Eclipse User

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

Re: Split combined cells in a crosstab [message #1059155 is a reply to message #1058900]

Thu, 16 May 2013 23:38

Eclipse User

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.

Attachment: DontMergeCrosstabDimensionsForXLS.rptdesign
(Size: 31.20KB, Downloaded 746 times)

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:

-=] Back to Top [=-

Current Time: Sat Jul 19 09:35:21 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter