Crosstabs: How to force data to repeat in the dimension columns

jgisler · June 24, 2010

My crosstab is suppressing duplicate row data for data in the same column. I would like BIRT to not suppress the duplicates but always print out the Term name

See the attached screen shot for example.

mwilliams · June 25, 2010

Hi jgisler,

Is "Grade" a dimension as well? If so, you can move the Term dimension element over into the grade elements cell and put both values inside a grid. This would cause the "term" value to not be suppressed. Let me know if this is not the case.

jgisler · June 25, 2010

Thanks for your reply. I ended up pulling two sorting attributes (gradeDisplayOrder and termDisplayOrder) attached as attributes to a dimension higher up in the hierarchy into the hierarchy itself. This "fooled" the crosstab into thinking the Term was not a duplicate. Now I get all the Terms duplicated or not and the sorting is still correct.

Thanks.

mwilliams · June 25, 2010

Glad you got a solution. Let us know whenever you have questions!

francisco · July 2, 2010

Hi jgisler, mwilliams,

I have the same problem and I would appreciate a more detailed explanation of both solutions.

Thanks.

mwilliams · July 2, 2010

Hi francisco,

What is your BIRT version? I'll make a quick example of what I was talking about.

francisco · July 5, 2010

I'm using BIRT 2.3.1.

Thanks.

Hi francisco,

What is your BIRT version? I'll make a quick example of what I was talking about.

mwilliams · July 6, 2010

Take a look at the attached report. Let me know if you have questions.

francisco · July 7, 2010

Thank you mwilliams! This is what I was looking for.
Nevertheless, I can see a problem when exporting to excel. Sometimes, elements of one row appear in two rows.
The attached picture shows what I'm trying to explain. Is there any way to solve this problem?

mwilliams · July 7, 2010

This must be an issue with the XLS emitter in 2.3.1 as it does not happen in the newest version, 2.6.0. Upgrading may be your best bet here.

prince_iam · April 3, 2019

@jgisler said:
Thanks for your reply. I ended up pulling two sorting attributes (gradeDisplayOrder and termDisplayOrder) attached as attributes to a dimension higher up in the hierarchy into the hierarchy itself. This "fooled" the crosstab into thinking the Term was not a duplicate. Now I get all the Terms duplicated or not and the sorting is still correct.

Thanks.

I am facing the similar problem for one of my user requirement to repeat group dimension for each record of crosstab in birt. Could you please hlep me in fixing this problem. I will be grateful.

prince_iam · April 3, 2019

@mwilliams said:
Take a look at the attached report. Let me know if you have questions.

Dear William,

I just joined this discussion, could you please share the report you just quoted in this reply as I am also facing the similar problem to repeat one of group dimension in birt crosstab.

prince_iam · April 3, 2019

Dear Fellows,

I am also facing the similar problem, I want to repeat value of group dimension for each row as my client wants to export data into excel and apply some filters. Since, crosstab automatically merge the group dimension and displays summarized data that is not intuitively required by my client. Could you guys help me to resolve this issue at earliest. Thank you in anticipation.

I have attached the screenshot of generated crosstab report in result of created group dimensions.

jfranken · April 4, 2019

Posted response on the other thread.

Crosstabs: How to force data to repeat in the dimension columns

Comments