Home Analytics Designing reports
The community of Analytics developers are invited to follow and participate in the developer network.
OpenText technical experts collaborate with supported customers and partners in the Magellan product area.

Grouping has a prolem in export to PDF and Excel

edited December 31, 1969 in Designing reports
Hi All,
One serious issu i am facing in my Web-Development project for BIRT report. I am using BIRT 2.5.1 version. When i generate report on BIRT viewer having Grouping on columns. On GUI no issue but when i export to PDF and Excel one extra row per group is coming and that should not come as per my requirement. Please any body help me out in the serious problem. I

I am attaching three snapshot
1) GUI Output
2) Export to pdf
3) Export to Excel

Thanks & Regards
Bokya

Comments

  • Hans_vdHans_vd Junior Member
    edited December 31, 1969
  • edited December 31, 1969
    No,
    I am not using drop property. What is the benifit of using drop property? Why to use drop property? How to use drop propert? Please provide me any sample example for BIRT version "Eclipse BIRT Designer Version 2.5.1.v20090903 Build"
  • Hans_vdHans_vd Junior Member
    edited December 31, 1969
    Hi Bokya,

    I'm not saying you should use the drop property.
    I was only asking because I know that the same kind of output issues occur when it is used.

    In your GUI output you have the grouping values next to the values of the first detail row. How did you do that?
  • edited December 31, 1969
    Hi,

    That values are the output of another group. I have used two groups. Also used drop property as 'ALL', Vertical alignment as 'Middle'. Please help me for the same.
  • edited December 31, 1969
    Please reply to aboove post
  • Hans_vdHans_vd Junior Member
    edited December 31, 1969

    I am not using drop property


    Also used drop property as 'ALL'




    So you do use the drop property!

    Did you check the links in my first comment? Is it not helping?
  • edited December 31, 1969
    Thanks for your reply,
    I used drop property too but same problem is coming. Please you also create one sample report and check at yuor side also has the same problem. Because when i use drop property group data will be applied to group of data and thh grouping row is extra row.

    on design we put a group element on a row and that is the row it showing extra. but as i have used drop property so i dont want this extra row.

    Also i have saw your link but there also same case.
  • Hans_vdHans_vd Junior Member
    edited December 31, 1969
    Hi,



    I am very much aware of what your problem is.

    I had the same issues.

    And when I finally solved the issues I wrote this article about it.



    So, no more drop property

    And the solution may not be too elegant - the grouping headers are gone the grouping data is scripted in the detail rows- but it does what you want.



    Did you try what is described in the article? add the aggregation fields.. set the borders.. write the scripts.. set the visibility expressions?



    Or am I completely misunderstanding what your problem is?



    Regards

    Hans
  • I have tried this solution it is working in doc type but not in the pdf format

Sign In or Register to comment.