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

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.

Find more posts tagged with

Comments

mwilliams

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

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

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

francisco

Hi jgisler, mwilliams,

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

Thanks.

mwilliams

Hi francisco,

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

francisco

I'm using BIRT 2.3.1. 
 
Thanks. 
 
<blockquote class='ipsBlockquote' data-author="'mwilliams'" data-cid="66115" data-time="1278086734" data-date="02 July 2010 - 09:05 AM">
Hi francisco, 
 
What is your BIRT version? I'll make a quick example of what I was talking about. </blockquote>

mwilliams

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

francisco

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

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

@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

@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

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.

crosstab.png

crosstab result.png

group.png

jfranken

Posted response on the other thread.