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

jgislerjgisler Junior Member
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.

Comments

  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    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.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • jgislerjgisler Junior Member
    edited December 1969
    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.
  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    Glad you got a solution. Let us know whenever you have questions! :)

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • edited December 1969
    Hi jgisler, mwilliams,

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

    Thanks.
  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    Hi francisco,

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

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • edited December 1969
    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.

  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    Take a look at the attached report. Let me know if you have questions.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • edited December 1969
    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?
  • mwilliamsmwilliams BIRT Guru
    edited December 1969
    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.

    Regards,

    Michael Williams

    eSignLive Evangelism & Community Manager | eSignLive by VASCO
     
    Find me on:
    Twitter
    Facebook
    Blog

    LinkedIn

    eSignLive Developer Community
     
    Email me:
    Google: [email protected]

  • prince_iamprince_iam Oracle Developer

    @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_iamprince_iam Oracle Developer

    @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_iamprince_iam Oracle Developer

    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.

  • Posted response on the other thread.

    Jeff F.
    Customer Support Engineer I
    OpenText
Sign In or Register to comment.