India

ZestyBeanz Technologies Pvt Ltd 4th Floor, Nila, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171

   .

ZestyBeanz Technologies Pvt Ltd
61/3236, Manikkath Cross Road
Ravipuram, Kochi, India - 682016
Phone: +91 484 4063254

  UAE

Zesty Labs
Office # 2003, Millennium Plaza Building
Sheikh Zayed Rd, Dubai, UAE
Phone: +971 4333 2222​
Mobile: +971-52-7553466

  Germany​

ZestyBeanz Technologies GmbH
Reuterstraße 1
90408 Nürnberg
Fon: +49 911 4801 444
Fax: +49 911 4801 445

Home » Crosstab in iReport

Reply to comment

Contact Form


Prajul P T's picture

Hai,       Printing a XLS

Submitted by Prajul P T on Mon, 07/30/2012 - 14:22.

Hai,

      Printing a XLS report in multi sheet if you know how to create it in a single sheet is easy. Try to fetch the data in such a way that we will be able to group the data to be displayed in page one and two in to two groups. Create a new group in iReport to group the data fetched. Now select the group created and go to properties and check "Start on new page" option. Ensure that in page properties, "Ignore Pagination is not selected". Create a new property for the page as "net.sf.jasperreports.export.xls.one.page.per.sheet" and set it as "true". Now compile the iReport and print the report. The data in group 1 will be displayed in sheet 1 and data in group 2 will be in sheet 2.

Reply

The content of this field is kept private and will not be shown publicly.
  • Allowed HTML tags: <a> <em> <strong> <cite> <code> <ul> <ol> <li> <dl> <dt> <dd>
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.
  • You can enable syntax highlighting of source code with the following tags: <code>, <blockcode>, <c>, <cpp>, <drupal5>, <drupal6>, <java>, <javascript>, <php>, <python>, <ruby>. The supported tag styles are: <foo>, [foo], [[foo]]. PHP source code can also be enclosed in <?php ... ?> or <% ... %>.

More information about formatting options

CAPTCHA
This question is for testing whether you are a human visitor and to prevent automated spam submissions.
Image CAPTCHA
Enter the characters shown in the image. Ignore spaces and be careful about upper and lower case.