Print out data in Landscape format and Auto-fit

asked 2010-07-27 21:59:52 +0800

zknewbie1 gravatar image zknewbie1
370 4

updated 2010-07-28 15:19:10 +0800

Hi, I'd like to create a Print button that will print out a data table to the printer. Since the table has quite a few columns, is there a way to auto configure the page layout to "Landscape" instead of "Portrait"; and then auto-shrink the font size to prevent those right-most columns from "spilling" over to the next page? I'm using ZK 5.0.3 Community Edition and IE7 browser. Any insight is greatly appreciated. Thanks...


<!--  ==== My Data Grid ==== -->
<grid id='myGrid1'>
  <columns sizable="true">
    <column label="Type" sort="auto"/>
    <column label="Content"/>
    .... (~15 - 20 columns)
<!-- ==== My Print Button ==== -->
<button id='printMyGrid1'  label='Print Table'  onClick='....'  />

delete flag offensive retag edit

7 Replies

Sort by ยป oldest newest

answered 2010-08-02 01:42:29 +0800

iantsai gravatar image iantsai
2755 1


Do you have any Idea of how to control OS through Browser to do the Printer configuration? I'm not sure even it is possible.

If you can give some links, maybe I can find some possible solutions.

link publish delete flag offensive edit

answered 2010-08-03 20:31:22 +0800

PeterKuo gravatar image PeterKuo
481 2

you can use javascript to ask browser to print a certain page.
But I'm wondering if javascript support so sophisticate manipulation like landscape.
The function maybe provided by printer driver.

One usual way to print,
is render the content in a new browser tab.

link publish delete flag offensive edit

answered 2010-08-03 22:53:10 +0800

zknewbie1 gravatar image zknewbie1
370 4

Thanks Peter and Iantsai. I'll try google it a bit more for any javascript trick that could help me do it. If you find any, please forward the link. Thanks gents..

link publish delete flag offensive edit

answered 2010-08-10 01:52:46 +0800

iantsai gravatar image iantsai
2755 1

updated 2010-08-10 01:54:09 +0800

I think a better way to do this is to show your result in a PDF rather than an HTML.

this can gives you layout consistency, modern browser's evolution has no effort put on printing, no telling the "standard of print" that browser should follow.

link publish delete flag offensive edit

answered 2010-08-11 07:52:46 +0800

zknewbie1 gravatar image zknewbie1
370 4

Thanks Iantsai, I heard one has to use Jasperreport to create PDF. I've never used it and so will have to learn it. If you know any good tutorial links about it, please let me know. Thanks.

link publish delete flag offensive edit

answered 2010-08-11 13:01:17 +0800

twiegand gravatar image twiegand
1807 3

updated 2010-08-11 13:02:59 +0800


I'd recommend starting with iReport. You can see more information and download it from http://jasperforge.org/projects/ireport. You might also begin with the Quick Start Tutorial.

Assuming you already have a database that contains the data from which you want to generate reports, use iReport's design tools to create some simple reports. Once complete, simply copy the compiled .jasper files to the server where you run ZK. Be sure they are in a location that is in your classpath. For example, you could copy them into your ../WEB-INF/classes folder (although this probably isn't the most appropriate location).

Next, you can write a ZUL page to display the report. The following example will give you a head start:

<window width="100%" height="100%">

	<borderlayout height="100%">
		<north maxsize="24" size="24" border="0">
					<div align="center" style="padding-top: 15px;">
						<cell align="right"><label style="font-weight: bold; color: #003E7E;" value="Report:  "/></cell>
						<listbox id="chosenReport" mold="select" >
							<listitem label="-- Please Select --" selected="true" />
							<listitem label="Assets by Assignment" value="Assets by Assignment.jasper"/>
							<listitem label="Assets by Owner" value="Assets by Owner.jasper"/>
							<listitem label="Assets by Department" value="Assets by Department.jasper" />
							<listitem label="Pending Services" value="Pending Services.jasper" />
					<div align="center" style="padding-top: 15px;">
						<button label="Generate Report">
							<attribute name="onClick">
								if (chosenReport.getSelectedItemApi().label.equals("-- Please Select --")) {
									Messagebox.show("Please Choose A Report", "Error", Messagebox.OK, Messagebox.ERROR);
								} else {
						<space spacing="15px" orient="horizontal" />
		<center border="none" flex="true">
			<iframe id="report" />
		import java.io.*;
		import java.sql.*;
		import org.zkoss.util.media.AMedia;
		import net.sf.jasperreports.engine.JasperRunManager;
		void doReport(reportName) {
			InputStream is = null;
			try {
				//generate report pdf stream
				is = Thread.currentThread().getContextClassLoader().getResourceAsStream(reportName);
				final byte[] buf = 
					JasperRunManager.runReportToPdf(is, params, getConnection());
				//prepare the AMedia for iframe
				final InputStream mediais = new ByteArrayInputStream(buf);
				final AMedia amedia = 
					new AMedia("MyReport.pdf", "pdf", "application/pdf", mediais);
				//set iframe content
			} catch (Exception ex) {
				throw new RuntimeException(ex);
			} finally {
				if (is != null) {
		private static Connection getConnection() throws ClassNotFoundException, SQLException {
			static Connection connection;

			connection = DriverManager.getConnection("jdbc:sqlserver://999.99.99.9;user=dbuser;password=dbpassword");			

You'll notice that there is a listbox that contains a list of reports that can be run. In each name/value pairing, the name of the compiled jasper report is contained (that you copied to the server in the previous steps). The selected value gets passed to the doReport function, generating a PDF file and displaying it in the iframe called "report". From there, the user can save it, print it, etc...

The only other thing you have to do is modify the connection string to match your database. We use SQL Server so that is what I've included here.

I think you'll find it very easy to generate PDF reports from Jasper in ZK.

Hope that helps,


link publish delete flag offensive edit

answered 2010-08-11 14:57:54 +0800

zknewbie1 gravatar image zknewbie1
370 4

Thanks a lot Todd. Since I'm new to ZK, Jasper and iReport, I'll make sure I spend enough time to learn them. Thanks so much.

link publish delete flag offensive edit
Your reply
Please start posting your answer anonymously - your answer will be saved within the current session and published after you log in or create a new account. Please try to give a substantial answer, for discussions, please use comments and please do remember to vote (after you log in)!

[hide preview]

Question tools




Asked: 2010-07-27 21:59:52 +0800

Seen: 910 times

Last updated: Aug 11 '10

Support Options
  • Email Support
  • Training
  • Consulting
  • Outsourcing
Learn More