borugadda007

Hi .I am using a cross tab in a report.i have 2 row group are job description and name. The cross tab automatically sorts the rows either ascending or descending, which in normal circumstances is very useful default behaviour. However, my data has a particular order which is from sql In the iReport designer, I can specify either ascending or descending order for my bucket expression.But i need to hide this sorting.Add my sal_grade desc order to ireportDesign In my sql ,I written sal_grade descending order and name ascending order.But because of row sorting ,iam getting data order by job_descriptin and name. How to add "Custom Comparator Expression " or "order by expression " for sal_grade order by Thanks Giri

Hi All Iam new to cross tab.I implimented alternate row color for non crosstab Reports. I structed to impliment alternate color.I created style but i dont know where i have to add.I have 3 row groups , 1 column group and 1 measurement

Hi Iam using crosstab.Its working fine in my local. if i deployed war in Unix environment,iam getting error like "net.sf.jasperreports.engine.JRException: Unknown column name : 'NOW'" Attached are jrxml and output pdf Please give your ideas and solutions Thanks Giri

When I do a crosstab with multiple pages of data, and I place it in a summary band, the report shows up but only starting on the second page . The height of the other bands is 0,the report data starts on the second page, not the first. Any ideas on what to check?

Hi Thanks for your reply. But iam new to crosstab.Can You explain how to set the incrementer

Hi Iam new to crosstab.Iam getting following data from database ________________________________________________________________________________________________ Empno readiness employeename ___________________________________________________________________________________________________ 001184900 emergency CHRISTOPHER FAY 001184900 lessthan2 EDWARD BASTIAN 001184900 lessthan2 ROBERT KIGHT 001184900 morethan2 001184900 now DANIEL LESKUSKY 001184900 now MICHAEL MEDEIROS 002309200 emergency 002309200 lessthan2 002309200morethan2 002309200 now _______________________________________________________________________________ I want to generate pdf following format eMPNO emergency lessthan2 morethan2 now 001184900 CHRISTO EDWARD ------ DANIEL ROBERT MICHAEL 002309200 ----- -------- ----- ------ i CAN GENERATE PDF USING CROSSTAB. I SUPPOSE TO GET 2 EMPNAME UNDER NOW AND LESSTHAN2.BUT IAM GETTING ONE EMPLOYEE. attached is jrxml amd pdf generated, Thanks for ur help Giri

Hi Attached is Jrxml.Please give solution

Hi Attached is jrxml. i need out put emergency lessthan2 morethan2 now 001184900 CHRISTO ROBERT MICHAEL DANIEL 002309200

Hi Iam working on cross tab for following data 001184900-emergency -CHRISTOPHER FAY 001184900-lessthan2- EDWARD BASTIAN 001184900-lessthan2- ROBERT KIGHT 001184900-morethan2 - 001184900 -now- DANIEL LESKUSKY 001184900- now- MICHAEL MEDEIROS But in cross tab iam getting only one row for "now". i need out put emergency lessthan2 morethan2 now 001184900 CHRISTO ROBERT MICHAEL DANIEL 002309200 Attached is generated Pdf and jrxml please help me in this issue... Thanks Giri

HI Iam using eclipse 3.1,tomcat 5.5.if iam trying to generate Jasper report (PDF)from servlet.My jasper code in another calss.Iam trying to call that method from servlet.i can generate PDF from main methd.from servlet ...... iam getting this error. ************************* java.lang.NoClassDefFoundError: net/sf/jasperreports/engine/JRExporterParameter at com.time.osp.servlets.JasperTestServlet.doPost(JasperTestServlet.java:111) at javax.servlet.http.HttpServlet.service(HttpServlet.java:710) at javax.servlet.http.HttpServlet.service(HttpServlet.java:803) at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269) at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188) at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213) at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174) at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127) at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117) at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108) at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:174) at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:874) at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:665) at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:528) at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:81) at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:689) at java.lang.Thread.run(Unknown Source) java.lang.NoClassDefFoundError *********************** PLZ Help me>>>>>>>>> Thanks MY code Is **************************** JasperDesign jasperDesign = JRXmlLoader.load("samplereport.jrxml"); JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign); Map parameters = new HashMap(); JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters,conn); JRPdfExporter exporter = new JRPdfExporter(); exporter.setParameter(JRExporterParameter.JASPER_PRINT, jasperPrint); exporter.setParameter(JRExporterParameter.OUTPUT_FILE_NAME, "samplereport.pdf"); exporter.setParameter(JRXlsExporterParameter.IS_ONE_PAGE_PER_SHEET, Boolean.FALSE); exporter.setParameter(JRXlsExporterParameter.IS_AUTO_DETECT_CELL_TYPE, Boolean.FALSE); exporter.setParameter(JRXlsExporterParameter.IS_WHITE_PAGE_BACKGROUND, Boolean.FALSE); exporter.setParameter(JRXlsExporterParameter.IS_REMOVE_EMPTY_SPACE_BETWEEN_ROWS, Boolean.TRUE); exporter.exportReport(); **************************************************** Post edited by: borugadda007, at: 2008/06/07 07:52 Post edited by: borugadda007, at: 2008/06/07 10:53