BIRT Cross Tab - Having details in each line (no group row)

Louis Paret · 2015-07-27T10:38:49+00:00

Hello, I use the latest version of BIRT and i have a problem with a crosstab created for Excel. I explain my problem : I have that : Cat1 Act1 Them1 Sub1 Sub2 Them2 Sub1 Act2…

Louis Paret

Hello, 
 
I use the latest version of BIRT and i have a problem with a crosstab created for Excel.
 
I explain my problem : 
 
I have that : 
 
Cat1 Act1 Them1 Sub1
 Sub2
 Them2 Sub1
 Act2 Them1 Sub1
 Act3 Them1 Sub1
Cat2 Act1 Them1 Sub1
 
 
 
And i want : 
 
Cat1 Act1 Them1 Sub1
Cat1 Act1 Them1 Sub2
Cat1 Act2 Them2 Sub1
Cat1 Act3 Them1 Sub1
Cat2 Act1 Them1 Sub1
 
In fact, i want all details by line. I don't find this option in the crossTab or in dimensions of my crosstab.
 
I can't use a simple table because i need to use totals.
 
If you have any questions, i'm here.
 
Thank you very much and sorry for my english.

Find more posts tagged with

Comments

pricher

Hi,
 
What you can do is concatenate the grouping columns into one computed column, use that column to group in the crosstab, then split the computed column to display the grouping columns separately. I have attached an example based on fields Country, City and CustomerName in Classic Models. Here's how it goes:
 
1. Create the computed column in the data set:

Louis Paret

Hello pricher,
 
thank you for you complete response. But i have a problem with your result.
 
In fact, i want this for using "Autofilter" in Excel. And for that, it's necessary to have 1 data in 1 cell... 
 
I don't know if you have already used Autofilter in Excel but with dimensions like my exemple, it doesn't work because the text in only in the first cell of the groupement of cell. 
 
Moreover, when i have tested you manipulation, my Eclipse crashed at the moment where i created the Data Cube with the concatenation, i don't know why...
 
So, if somebody have any idea for have the same result than pricher but in different cell... Or any other idea.
 
Sorry for my english.
 
Thank you yet pricher !

pricher

Hi,
 
I am not sure you can get away from using a grid to flatten the groups for export into Excel. However, after second thought, you don't need the concatenation technique. Here's a revised version of the sample report.
 
1. In the data cube, create groups for each level you need, not just one group with sub-levels:

Louis Paret

Hello pricher, 
 
Thank you for your responce ! It's very complete and explicated.
 
But I have a problem, your solution is the best way to do i think but the result is not the same on my computer. When I run your design, i have only one column with all the text.
 
Have you got other details ? (Advanced, ...)
 
I test with my design and the result is the same. And i test on Libre Office and Microsift Office... 
 
Filters and Cross Tab are not compatible

Thank you yet !

Louis Paret

I attach a screenshot of the result of your design on my computer

pricher

Hi,
 
I forgot to mention that you have to use the Excel emitter, not the XLSX emitter to get the correct results.