honeyani

Hi All, How to set color change for rows using iReport tool. For eg .I want even rows to hold 1 color and odd rows to hold other color. Please guide. Thanks in advance. Ani

Hi, Using iReport 3.0.0 i generated Excel and PDF report till now ,in report properties i have set landscape option,the same is seen in orientation attribute of jrxml. My report gets printed in landcape view when i print these two format. With the same jrxml which i use for pdf,when i try to generate html report and give it for printing it prints in portrait format. Is it possible to set Pageset up property during print to landscape instead of potrait that exists for html report? Please guide me to fix this. In Excel report,print setup property is set to landscape as its set in design and print also happens in landscape as required.But for pdf it prints in landscape but page set up proeprty that can be found during print shows portrait only.( i ahev a doubt ehre too why is property for page set up is nto updated to landscape).With html report now the print setting for page set up property exists as portrait and prints in portrait format ..required is landscape..Why this issue? Please find below table to udnerstand the issue faced...any solution for this in iReport?I want to print my HTML report in landscape format... output | Excel | PDF | HTML Printer property -page set up shown | Landscape | Portrait | Portrait Gets printed in document as | Landscape| Lanscape | Portrait hope i made my doubt clear... Thanks, Anitha

Hi friends... The option works..the printed document is in landscape format..but in print properties it shows portrait... If we get the o/p in landscape thts fine for us as of now..thx Ani

Hi friends... The option works..the printed document is in landscape format..but in print properties it shows portrait... If we get the o/p in landscape thts fine for us as of now..thx Ani

Hi friends... The option works..the printed document is in landscape format..but in print properties it shows portrait... If we get the o/p in landscape thts fine for us as of now..thx Ani

Hi friends... The option works..the printed document is in landscape format..but in print properties it shows portrait... If we get the o/p in landscape thts fine for us as of now..thx Ani

honeyani Wrote: Hi kris, How to use JasperExportManager.. I just replaced exporter.exportReport() with the code you have mentioned "JasperExportManager (exporter.exportReport()); " I get excpetion - Generated servlet error: The method JasperExportManager(void) is undefined for the type myreport_jsp Can you please guide on how to use this method? any packahe to import? am i going on the right track.. please help to fix this.. i want to set landscape option during print...have set it in ireport properties,thru jsp code jasperPrint.setOrientation(..),also tried changing widht and height..still the problem is not resolved... waiting for your reply at the earliest.. thx, Ani To overcome the exception i updated code as below JasperExportManager.exportReportToPdfFile(jasperPrint,"C:/myreport.pdf"); response.setContentType("application/pdf"); But still when i open the generated report and view the print properties..it shows portrait...still...but it should be set to landscape ...does iReport support this?

Hi kris, How to use JasperExportManager.. I just replaced exporter.exportReport() with the code you have mentioned "JasperExportManager (exporter.exportReport()); " I get excpetion - Generated servlet error: The method JasperExportManager(void) is undefined for the type myreport_jsp Can you please guide on how to use this method? any packahe to import? am i going on the right track.. please help to fix this.. i want to set landscape option during print...have set it in ireport properties,thru jsp code jasperPrint.setOrientation(..),also tried changing widht and height..still the problem is not resolved... waiting for your reply at the earliest.. thx, Ani

honeyani Wrote: honeyani Wrote: Hi Teo, I'm using iReport 3.0.0 version. In report properties have set Landscape option,but still in my pdf generated report i find portrait option checked by default in print properties..why? Can you please guide to fix this issue. I tried using jasper.setOrientation code in jsp too. I tried modifyinf the width and height values..still i face this issue. I use a master and sub report both the report properties set as landscape. waiting for your reply, Thx, Ani My master report jrxml header, <jasperReport name="XXX_General" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="1472" pageHeight="1471" columnWidth="1436" columnSpacing="0" leftMargin="8" rightMargin="28" topMargin="28" bottomMargin="28" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> sub report jrxml header <jasperReport name="YYY_General_Detail" columnCount="1" printOrder="Horizontal" orientation="Landscape" pageWidth="1474" pageHeight="1474" columnWidth="1474" columnSpacing="0" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> what mistake i have commited (to fix landscape orientation)? PageWidth and Height values i tried with 842 & 595 on both reports...still i get potriat only...any inputs?

honeyani Wrote: Hi Teo, I'm using iReport 3.0.0 version. In report properties have set Landscape option,but still in my pdf generated report i find portrait option checked by default in print properties..why? Can you please guide to fix this issue. I tried using jasper.setOrientation code in jsp too. I tried modifyinf the width and height values..still i face this issue. I use a master and sub report both the report properties set as landscape. waiting for your reply, Thx, Ani My master report jrxml header, <jasperReport name="XXX_General" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="1472" pageHeight="1471" columnWidth="1436" columnSpacing="0" leftMargin="8" rightMargin="28" topMargin="28" bottomMargin="28" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> sub report jrxml header <jasperReport name="YYY_General_Detail" columnCount="1" printOrder="Horizontal" orientation="Landscape" pageWidth="1474" pageHeight="1474" columnWidth="1474" columnSpacing="0" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" whenNoDataType="NoPages" isTitleNewPage="false" isSummaryNewPage="false"> what mistake i have commited (to fix landscape orientation)?

Hi Teo, I'm using iReport 3.0.0 version. In report properties have set Landscape option,but still in my pdf generated report i find portrait option checked by default in print properties..why? Can you please guide to fix this issue. I tried using jasper.setOrientation code in jsp too. I tried modifyinf the width and height values..still i face this issue. I use a master and sub report both the report properties set as landscape. waiting for your reply, Thx, Ani

Hi yelena, can you guide how you fixed this issue.. Is it possible to display the report in Landscape instead of Portrait? Have done this with report properties of iReport as well coded in jsp as jasperPrint.setOrientation(JasperReport.ORIENTATION_LANDSCAPE) But still in print properties it shows portrait option any idea on how to resolve this issue? Considered as an urgent issue..waiting for reply ASAP.. thx in advance, Ani

Hi In iReport report properties Orientation value set in drop down in 'Landscape'. In jrxml jasper report header is like this : <jasperReport name="My_report_Name" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="1472" pageHeight="1471" columnWidth="1436" columnSpacing="0" leftMargin="8" rightMargin="28" topMargin="28" bottomMargin="28" whenNoDataType="NoPages" scriptletClass="AccountHistory_GeneralScriptlet" isTitleNewPage="false" isSummaryNewPage="false"> which shows orientation landscpae as well in jsp code i've updated as below for japser print properties.. jasperPrint.setOrientation(JasperReport.ORIENTATION_LANDSCAPE); Still on the generated PDF report ,print page set up option shows 'portrait' option highlighted. Anyother way to set landscape option during print ?how to resolve this issue. ITs an urgent issue,can anyone help out to solve this ASAP. waiting for ur reply.. Regds, Ani

Hi In iReport report properties Orientation value set in drop down as 'Landscape'. In jrxml jasper report header is like this : <jasperReport name="My_report_Name" columnCount="1" printOrder="Vertical" orientation="Landscape" pageWidth="1472" pageHeight="1471" columnWidth="1436" columnSpacing="0" leftMargin="8" rightMargin="28" topMargin="28" bottomMargin="28" whenNoDataType="NoPages" scriptletClass="AccountHistory_GeneralScriptlet" isTitleNewPage="false" isSummaryNewPage="false"> which shows orientation landscape... As well in jsp code i've updated as below for jasper print properties.. jasperPrint.setOrientation(JasperReport.ORIENTATION_LANDSCAPE); Still on the generated PDF report ,print page set up option shows 'portrait' option highlighted. Any other way to set landscape option during print ?how to resolve this issue. ITs an urgent issue,can anyone help out to solve this ASAP. waiting for ur reply.. Regds, Ani Post Edited by Anitha R at 11/19/08 05:32 Post Edited by Anitha R at 11/19/08 05:33

Hi , I use iReport version 3.0.0 ,Detect cell type works fine in this version.Can you update the tool version and check this out. Thanks, Ani

Hi All, I'm trying to learn Sub report usage on iReport tool uisng XML data source. I had XML content with a sub tag element missing in few tags and present in rest of the tags element. Hence in my report tags without that sub tag elemtns were not displayed to overcome this issue solution i found as sub report. 1. created 1 master report with 1 field account number. 2.Created sub report with 2 fields account no and type which is present only under detail tag.This detail tag exists for few account number and it doesn't exists for rest. When i run the two reports individually i get the output in Excel sheet as required. Next i tried to place the sub report on master report ,while executing i get null as sub report field values .why? Master report query set as : /______ACCOUNT_HISTORY/______ACCOUNT_HISTORY_REPORT/ORGANIZATION/DATE_RANGE/ACCOUNT_INFO Sub report query set as : /______ACCOUNT_HISTORY/______ACCOUNT_HISTORY_REPORT/ORGANIZATION/DATE_RANGE/ACCOUNT_INFO/DETAIL Sub report property includes sub report expression "C:/iReport_output/Sub report.jasper" sub report uses data source expression and the expresison is as follows (net.sf.jasperreports.engine.data.JRXmlDataSource)$P{REPORT_DATA_SOURCE}).subDataSource("/ACCOUNT_INFO/DETAIL") Please find attachment with screen shot of the report design i 'm trying out.. As i am new to sub report usage using XML Data Source ,if anyone can help me out to fix this issue will be really grateful. Thx, Ani

Hi .. can you provide some inouts on how to work around with sub reports... Thanks in advance, Ani

Hi All, Using XML data source can anyone provide example for usage of sub dataset in iReport and an explanation on how it works. Thanks in advance, Ani

hi all, I'm using XML data source..can anyone provide example for sub dataset using XML data source. I created 1 sub data set and placed two fields on design and tested,it says field not found exception.. I don't find any resource which talks about this ..Can anyone provide resource for sub dataset usage for XMl Data source... Waiting for reply.. Thx, Ani

Hi All, Urgent requirement.. Please suggest a link to learn about sub dataset on iReport tool.. Thx in advance, Ani

honeyani Wrote: Hi All, I'm trying to use sub dataset . My XML doc structure is as below -sub tag 'sample' present in 1 element will not be available in other element. 1. <xx> <yy> <zz> <sample no=" " date =" "> </sample> </zz> </yy> </xx> 2. <xx> <yy> <zz> </zz> </yy> </xx> Created data set with XPATH till zz and created subdataset with xpath zz/sample In jrxml detail band i placed the field element in subdataset no and date ,when i try to execute the jrml i get the below exception "Field not found" why the fields in sub dataset are not recognized?Do we need to do anyother setting ? what is the mistake i'm commiting.? Can anyone please guide us to fix this major issue. waiting for reply .. Thx, Ani Error as below : (actual field name and xml differes frm the sample i have provided here) net.sf.jasperreports.engine.design.JRValidationFault@10dcf55 Field not found : ACCTNUM Line: 150, Column: 53 JRXML Element: /jasperReport/detail[1]/band[1]/textField[3]/textFieldExpression[1] net.sf.jasperreports.engine.design.JRValidationFault@1a6d80a Field not found : ACCTTYPE Line: 163, Column: 53 JRXML Element: /jasperReport/detail[1]/band[1]/textField[4]/textFieldExpression[1] Any idea why this exception is thrown?

Hi All, I'm trying to use sub dataset . My XML doc structure is as below -sub tag 'sample' present in 1 element will not be available in other element. 1. <xx> <yy> <zz> <sample no=" " date =" "> </sample> </zz> </yy> </xx> 2. <xx> <yy> <zz> </zz> </yy> </xx> Created data set with XPATH till zz and created subdataset with xpath zz/sample In jrxml detail band i placed the field element in subdataset no and date ,when i try to execute the jrml i get the below exception "Field not found" why the fields in sub dataset are not recognized?Do we need to do anyother setting ? what is the mistake i'm commiting.? Can anyone please guide us to fix this major issue. waiting for reply .. Thx, Ani

Solution need to use subdataset. will start a seperate thread to discuss on subdataset..

PDF Export is not done..verfiy your jsp code whether export code is done properly..

Is the option to remove empty space between rows is enabled?