[color change for alternative rows?]

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

[Html report landscape printing!]

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

 

[To set print option 'landscape'.]

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

[Displaying Report in Landscape (PDF)]

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

[Landscape printing]

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

[Landscape reports with Jasper]

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

 

 

[Landscape reports with Jasper]

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?

 

[Landscape reports with Jasper]

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

 

[Landscape printing]

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?

[Landscape printing]

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)?

 

[Landscape printing]

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

[Displaying Report in Landscape (PDF)]

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

[to set print orientation landscape?]

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

[To set print option 'landscape'.]

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

[xls cell format not according to format in ireport]

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

[New to sub-report]

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

 

[using subreport variables in variable expressions]

Hi ..

 

can you provide some inouts on how to work around with sub reports...

Thanks in advance,

Ani

[Sub dataset..]

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

[JavaBeanDataSource in sub report]

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

 

 

 

[sub dataset doc]

Hi All,

Urgent requirement..

Please suggest a link to learn about sub dataset on iReport tool..

Thx in advance,

Ani

 

 

[sub dataset field not found exception]

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?

[sub dataset field not found exception]

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

 

 

[Doubt with XPATH setting?]

Solution need to use subdataset.

 

will start a seperate thread to discuss on subdataset..

[Need Help in Jasper report..]

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

[Extra line in the pdf report in b/w alternate rows]

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