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.

Each page of crosstab data is rendered as a separate excel sheet - Please help :(

Respond
kiranvkiranv Member
edited December 31, 1969 in Designing reports
Hello all,<br />
<br />
I have designed a crosstab report (plz chk attached file) in BIRT 2.5.1 using the CLASSIC MOTORS database. It has 2 columns- Product Name and Quantity ordered where product name is grouped together to show the sum of quantity in column 2. It is showing the expected results. The output is a multipage report. However when I view report as XLS<strong class='bbc'> (which is my requirement) </strong>then each page is shown on a <strong class='bbc'>different Excel Sheet.</strong>I have kept all default properties of the crosstab. <br />
<br />
Plz, please,please help me in this. <strong class='bbc'>I want all the pages in the same excel sheet</strong>. What properties of the cross tab should I change? or is this a bug in Birt??<br />
<br />
Thanks in advance,<br />
Kiran<br />
<br />
PS: Page 560 of the book "BIRT-Aa field guide to reporting, 2nd Edition" states that <br />
"<em class='bbc'>By contrast, an XLS report appears on a single Excel worksheet; page breaks<br />
that you specify in the report design have no effect."</em><br />
<br />
However still each page of the report is on a separate excel sheet. Plz plz help to show all data on just on excel sheet.

Comments

  • JasonWJasonW
    edited December 31, 1969
    When I export your example to xls, I only get one sheet. Are you using the default xls emitter or the Tribix emitter?

    Jason
  • kiranvkiranv Member
    edited December 31, 1969
    Hello Jason,<br />
    <br />
    Thanks for the quick reply. I am using the tribix xls emitter 2.5.1 (org.uguess.birt.report.engine.emitter.xls_2.5.1.201001221050.jar) which i downloaded from <a class='bbc_url' href='http://sourceforge.net/projects/tribix/'>Tribix - Extended Emitters for BIRT | Get Tribix - Extended Emitters for BIRT at SourceForge.net</a>. I am using them since my requirement is also to display charts in excel. <br />
    <br />
    Any other way to generate them in one excel sheet with Tribix emitters??<br />
    <br />
    Thanks in advance.<br />
    <br />
    Regards,<br />
    Kiran
  • JasonWJasonW
    edited December 31, 1969
    If your xtab report does not have charts why not use both emitters. Export to Tribix when you have a chart, and the normal xls when you dont? The other option may be to look at the code for the emitter and disable the method that creates the new sheet.

    Jason
  • kiranvkiranv Member
    edited December 31, 1969
    I unzipped the birt-runtime-2_5_1 at another location and now the report is working fine :) .. thnx a lot..
    fortunately there are 2 different types of reports - one with only charts and the other ones with data.

    Thnx for ur prompt help.

    Enjoy ur weekend.

    Regards,
    Kiran
  • kiranvkiranv Member
    edited December 31, 1969
    Select Master page of the report. Go to properties-->General.
    Change Type to custom
    Then change Height to some Big number like 200 inches.

    Thats it :)

    if ur using a Table to display the data then u may also increase the page break interval
  • Krunal UmakKrunal Umak EM

    @kiranv increasing custom page height didn't solve my problem

  • Eric DavisEric Davis

    In the property editor, go to "General" and change the "Layout Preference" to Auto Layout

  • Krunal UmakKrunal Umak EM

    Hi Eric, thanks for quick reply. The layout is auto only.

  • Eric DavisEric Davis

    @Krunal Umak said:
    Hi Eric, thanks for quick reply. The layout is auto only.

    I just looked at the attachments, and they are not Auto Layout. Be sure you change it and this should fix your issue.

Sign In or Register to comment.