Print out data in Landscape format and Auto-fit

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

	<borderlayout height="100%">
		<north maxsize="24" size="24" border="0">
			<panel>
				<panelchildren>
					<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" />
						</listbox>
					</div>
					<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 {
									doReport(chosenReport.getSelectedItemApi().value);
								}
							</attribute>
						</button>
						<space spacing="15px" orient="horizontal" />
					</div>
				</panelchildren>
			</panel>
		</north>
		<center border="none" flex="true">
			<iframe id="report" />
		</center>
	</borderlayout>
	
	<zscript>
	
		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
				report.setContent(amedia);
			} catch (Exception ex) {
				throw new RuntimeException(ex);
			} finally {
				if (is != null) {
					is.close();
				}
			}
		}
		private static Connection getConnection() throws ClassNotFoundException, SQLException {
			static Connection connection;

			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver");
			connection = DriverManager.getConnection("jdbc:sqlserver://999.99.99.9;user=dbuser;password=dbpassword");			
		}
	</zscript>
</window>