[JasperViewer.viewReport(...)]

Thank you!!!!!!!!!!!

[About string query and parameter]

Hi,

How can I connect parameter as string sql to the queryString ??

Code:

strSql = " AND tasks.watch_date IS NULL ";

 

Code:

[code] <parameter name="strSql" isForPrompting="true" class="java.lang.String"/> <parameter name="owner_id" isForPrompting="true" class="java.lang.Integer"/> <queryString><![CDATA[sELECT * FROM tasks WHERE owner_id = $P{owner_id} $P{strDateSql}

[Problem with view report]

Hi,

I'm running viewReport from my java application.

Code:

JasperPrint jasperPrint = JasperFillManager.fillReport(
					jasperReport, parameters, conn);
			JasperViewer.viewReport(jasperPrint, true);

My problem is when I'm closing the view report, my java aplication closing twe!

I think it's because the view frame sel exit(0)?

and one more question, if I run this viewReport from JButton in a JDIalog, the view location is under my dialog, how can I set this view to be allways on top??

Thanks alot :)

Post edited by: yael, at: 2007/02/15 07:48

[About Logo]

Hi, thanks!!!

if I click on:

menu>edit>insert>image It's work, I can see the image on the report, but I get runtime error:

This error about if I add new Date() to the title, but I get the same error if I add Image..

 

 

net.sf.jasperreports.engine.JRException:ÂReportÂdesignÂnotÂvalidÂ:Â ÂÂÂÂÂ1.ÂFieldÂnotÂfoundÂ:ÂField ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:267) ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144) ÂÂÂÂatÂnet.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:127) ÂÂÂÂatÂnet.sf.jasperreports.engine.JasperCompileManager.compileReportToFile(JasperCompileManager.java:109) ÂÂÂÂatÂit.businesslogic.ireport.IReportCompiler.run(IReportCompiler.java:529) ÂÂÂÂatÂjava.lang.Thread.run(UnknownÂSource)

Post edited by: yael, at: 2007/02/15 06:56

[About Logo]

Yes,

I can't find a browser to my icom/image file..

If you can tell me where is it.

I whant to add with iReport or edit with my self, do you have an example for me? (code)

[xml / jrxml general question]

How can I check in the xml file this:

If( $P{status_id} != 0)

then to add WHERE filter.

else

don't use the WHERE

Code:

<parameter name="status_id" class="java.lang.Integer" />
 
<queryString>
<![CDATA[sELECT task_id,status_id FROM tasks WHERE status_id = $P{status_id}]]>
</queryString>

:whistle:

[About Logo]

Could you please give me an example for that?

I'm new in xml issue, If you can past for me some code I'll be happy :kiss:

[About Logo]

Hi,

How can I add Logo company into the pageHeader??

I can't find nothing about this issue, is it possible??

Thanks.

[JasperViewer.viewReport(...)]

How to set JasperViewer.viewReport(...) to be Always On Top?

I whant that the viewReport will behaver like a dialog, How can I set this? (from java will be greate!!!)

Thanks

Post edited by: yael, at: 2007/02/13 11:12

[How to set iReport to be Always On Top?]

I whant that the iReport will behaver like a dialog, How can I set this? (from java will be greate!!!)

Thanks.;)

[I need help please with java + xml]

Hi,

1)How can I set an Icone/Image to a pageHeader?

2)How can I creat dinamic queryString parameters, I'm using JasperReport

I mean something like this

Code:

public class Report {
	public Report() {
		// TODO Auto-generated constructor stub
 
		try {
			Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"«»);
			Connection conn = DriverManager.getConnection(
					"jdbc:«»sqlserver://matarotsrv:1111;databaseName=qm6", "aa",
					"aa"«»);
 
			// load JasperDesign from XML and compile it into JasperReport
			JasperDesign jasperDesign = JRXmlLoader.load("task1.jrxml"«»);
			JasperReport jasperReport = JasperCompileManager
					.compileReport(jasperDesign);
 
HashMap parameters = new HashMap();
if(ownerId!= 0){
parameters.put("owner_id", new Integer(ownerId));
}
if(!(ownerName.equals(null))){
parameters.put("owner_name", new String(ownerName));
})
JasperPrint jasperPrint = JasperFillManager.fillReport(
jasperReport, parameters, conn);
			JasperViewer.viewReport(jasperPrint, true);
 
		} catch (Exception e) {
			e.printStackTrace();
		}
	}

Then, in the xml file - How can I connect to the WHERE statment only if this properties is full with data??

Code:

[code] <parameter name="owner_id" class="java.lang.Integer" /> <parameter name="owner_name" class="java.lang.String" /> ... Where tasks.owner_id = $P{owner_id} AND tasks.owner_name = $P{owner_name}

Thanks,

Yael. ;)

[How can I edit report from java?]

I found the solution,

Thanks anyway.

[iReport error: not fined the main class]

Hi,

I whant to run the iReport from my java application.

I think I'm missing somethimg..

I get this error:

Java virtual machine launcher

Could not fined the main class, program will exit.

Code:

public class runApp {
	Process proc;
	runApp() {
		String str = "C:\MyJava\iReport-1.3.0\iReport.exe";
		try {
			proc = Runtime.getRuntime().exec(str);
			if (proc.waitFor() != 0) {
				System.err.println("Program did not finish properly"«»);
			}
		} catch (Exception e1) {
			// TODO Auto-generated catch block
			e1.printStackTrace();
		}
	}
 
	public static void main(String[] argz) {
		new runApp();
	}
}

I'm thinking that I'm missing some file to complite iReport running. (with this code I get the same error).

maybe I need add to this code more files to run the iReport?

I get this error when I'm running this code, and I was try to check if it is about my code (not attached to java):

If I coppy to some place in the computer only the iReport.exe file - then click on it to run this program, I get this error to.

but if I'm running from the shortcut desctop or from the exe that located in the iReport directory (whit no attached to java) it's running good.

so, I think this error dialog attached to iReport program.

 

Post edited by: yael, at: 2007/02/13 06:20

Post edited by: yael, at: 2007/02/13 07:12

[How can I edit report from java?]

I mean, how to create jrxml file from java?

I whant to open editor like iReport, is it possible?

Thanks.:huh:

To show this file I'm using white JasperViewer..

but I can't find nothing about edin jrxml file in my program (the user could edit jrxml).

[It it possible to run iReport]

Do you have an example for that?

I don't fully understan.

In my program I'm useing with JasperReports and show the report with JasperViewer.

I whant to be able to edit a new report from my java program, I mean: if I clicked on the JButton, for example - I whant that the iReport will open to me :whistle:

Thanks,

Yael.

[How can I set the JasperViewer to the front]

I have JDialog with JButton to open jrxml with JasperViewer, but the Viewer under my dialog.

Can I set this view to behaver like a dialog?

Thanks :huh:

[It it possible to run iReport]

from java application?

I whant to open in my java program report generator like iReport..

How cuold I do this??

I'll be happy for code example :kiss:

[Bigginer question]

Hi,

I'm try to create a jrxml for my java project (with JasperReport).

I whant to write a title but I don't have '+' in the document structure:

-- []Document

----- []background|

----- []title

----- []pageHeader

It's sopose to look like this yep?

-- +[]Document

----- +[]background|

----- +[]title

----- +[]pageHeader

 

I don't anderstand why:whistle:

In the main console I get this(maybe it's relation this)

iReportÂhomeÂ(ireport.homeÂsystemÂproperty):Â.

UserÂhomeÂ(user.homeÂsystemÂproperty):ÂC:DocumentsÂandÂSettingsOwner.ireport

iReportÂdefaultÂcompileÂdirectory:Â.

iReportÂuserÂhomeÂdirectoryÂ(iReportÂcompilesÂhereÂifÂthereÂareÂnoÂsettingsÂorÂifÂiReportÂisntÂcomilingÂtoÂtheÂreportÂdirectory):Â{0}

iReportÂconfigurationÂfileÂC:DocumentsÂandÂSettingsOwner.ireportconfig.xmlÂsuccessfullyÂupdated.

iReportÂfileÂC:DocumentsÂandÂSettingsOwner.ireportrecentFiles.xmlÂsuccessfullyÂupdated.

Renamed C:Documents and SettingsOwnerMy DocumentsUntitled_report_1.jrxml to C:Documents and SettingsOwnerMy DocumentsUntitled_report_1.bak

[Problem with save PDF (or other type)]

Thanks,

Why I have to download Ant to running the example?

If I'm running this example now I get in the console this:

UnicodeApp usage:

java UnicodeApp -Ttask -Ffile

Tasks : fill | print | pdf | xml | xmlEmbed | html | rtf | xls | jxl | csv | run

[Problem with save PDF (or other type)]

Hi,

I have problem with hebrew data.

The JasperViewer display is good but if I'm save from ther to csv I get gibbrish data =(??????).

in pdf I get an empty file.

(if the data in english - it's save good).

Thanks.:whistle:

[Element not opens in ireport]

I'm new in iReport..

I whant to build a XML File for JasperReports.

I'm runing the exe file but I can't see an access to the elements tree (thay with no '+')

and in the console I get this message:

iReportÂhomeÂ(ireport.homeÂsystemÂproperty):Â.

UserÂhomeÂ(user.homeÂsystemÂproperty):ÂC:DocumentsÂandÂSettingsOwner.ireport

iReportÂdefaultÂcompileÂdirectory:Â.

iReportÂuserÂhomeÂdirectoryÂ(iReportÂcompilesÂhereÂifÂthereÂareÂnoÂsettingsÂorÂifÂiReportÂisntÂcomilingÂtoÂtheÂreportÂdirectory):Â{0}

Post edited by: yael, at: 2007/02/07 10:45

[How to display the query]

Hi,

How can I display the result of a query as a table in JasperViewe??

Code:

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE jasperReport
PUBLIC "-//JasperReports//DTD Report Design//EN"
"http://jasperreports.sourceforge.net/dtds/jasperreport.dtd">
<jasperReport name="example1">
<reportFont name="Arial_Normal" isDefault="true" fontName="Arial" size="12" 
		isBold="false" isItalic="false" isUnderline="false" isStrikeThrough="false" 
		pdfFontName="Helvetica" pdfEncoding="Cp1252" isPdfEmbedded="false" />
	<reportFont name="Arial_Bold" isDefault="false" fontName="Arial" size="12" 
		isBold="true" isItalic="false" isUnderline="false" isStrikeThrough="false" 
		pdfFontName="Helvetica-Bold" pdfEncoding="Cp1252" isPdfEmbedded="false" />
	<reportFont name="Arial_Italic" isDefault="false" fontName="Arial" size="12" 
		isBold="false" isItalic="true" isUnderline="false" isStrikeThrough="false" 
		pdfFontName="Helvetica-Oblique" pdfEncoding="Cp1252" isPdfEmbedded="false" />
<parameter name="Title"/>	
<queryString language="sql">
<![CDATA[ SELECT first_name,last_name,contact_id FROM contacts
  ]]> 
  </queryString>
  <field name="first_name" class="java.lang.String" />
<field name="last_name" class="java.lang.String" /> 
<field name="contact_id" class="java.lang.Integer" /> 

<title>
		<band height="35">
			<textField isBlankWhenNull="true">
				 <reportElement mode="Transparent" x="0" y="0" width="520" height="30" forecolor="#FF3300" backcolor="#FFFFFF" key="staticText-1" stretchType="NoStretch" positionType="FixRelativeToTop" isPrintRepeatedValues="true" isRemoveLineWhenBlank="false" isPrintInFirstWholeBand="false" isPrintWhenDetailOverflows="false" /> 
  <box topBorder="None" topBorderColor="#000000" leftBorder="None" leftBorderColor="#000000" rightBorder="None" rightBorderColor="#000000" bottomBorder="None" bottomBorderColor="#000000" /> 
<textElement textAlignment="Center" verticalAlignment="Top" rotation="None" lineSpacing="Single">
  <font fontName="Arial" pdfFontName="Helvetica-Bold" size="24" isBold="true" isItalic="false" isUnderline="false" isPdfEmbedded="false" pdfEncoding="Cp1252" isStrikeThrough="false" /> 
  </textElement>
				<textFieldExpression class="java.lang.String">
				$P{Title}
				</textFieldExpression>
			</textField>
			<line>
				<reportElement x="0" y="30" width="520" height="1" />
				<graphicElement />
			</line>
		</band>
	</title>

<pageHeader>
		<band></band>
	</pageHeader>

<columnHeader>
    <band height="20">
      <staticText>
        <reportElement x="10" y="0" width="180" height="20"/>
        <textElement textAlignment="Center">
        <font fontName="Arial" isBold="true" isUnderline="true"/> 
        </textElement>
        <text><![CDATA[First Name]]></text>
      </staticText>
      <staticText>
        <reportElement x="90" y="0" width="180" height="20"/>
        <textElement textAlignment="Center">
       <font fontName="Arial" isBold="true" isUnderline="true"/> 
        </textElement>
        <text><![CDATA[Last Name]]></text>
      </staticText>
      <staticText>
        <reportElement x="180" y="0" width="180" height="20"/>
        <textElement textAlignment="Center">
      <font fontName="Arial" isBold="true" isUnderline="true"/> 
        </textElement>
        <text><![CDATA[iD]]></text>
      </staticText>
    </band>
  </columnHeader>
  

<detail>
<band height="20">
<textField>
<reportElement x="10" y="0" width="180" height="20" />
<textElement textAlignment="Center">
      <font fontName="Arial"/> 
</textElement>
<textFieldExpression class="java.lang.String">
<![CDATA[$F{first_name}]]>
</textFieldExpression>
</textField>
<textField>
<reportElement x="90" y="0" width="180" height="20" />
<textElement textAlignment="Center">
      <font fontName="Arial"/> 
</textElement>
<textFieldExpression class="java.lang.String">
<![CDATA[$F{last_name}]]>
</textFieldExpression>
</textField>
<textField>
<reportElement x="180" y="0" width="180" height="20" />
<textElement textAlignment="Center">
      <font fontName="Arial"/> 
</textElement>
<textFieldExpression class="java.lang.Integer">
<![CDATA[$F{contact_id}]]>
</textFieldExpression>
</textField>
</band>
</detail>

<pageFooter>
		<band height="40">
			<line>
				<reportElement x="0" y="10" width="515" height="1" />
				<graphicElement />
			</line>
			<textField>
				<reportElement x="200" y="20" width="80" height="15" />
				<textElement textAlignment="Right" />
				<textFieldExpression class="java.lang.String">
					<![CDATA["Page "]]>
				</textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement x="280" y="20" width="75" height="15" />
				<textElement />
				<textFieldExpression class="java.lang.String">
					<![CDATA[" of "]]>
				</textFieldExpression>
			</textField>
		</band>
	</pageFooter>

</jasperReport>

[Error: Parameter not found : Title]

Thanks, It's work!!!:silly:

[Error: Parameter not found : Title]

I'm tring to set title from java to a xml file with parameter, but I get this error:

Code:

net.sf.jasperreports.engine.JRException: Report design not valid : 
	 1. Parameter not found : Title
	at net.sf.jasperreports.engine.design.JRAbstractCompiler.verifyDesign(JRAbstractCompiler.java:267)
	at net.sf.jasperreports.engine.design.JRAbstractCompiler.compileReport(JRAbstractCompiler.java:144)
	at net.sf.jasperreports.engine.design.JRDefaultCompiler.compileReport(JRDefaultCompiler.java:105)
	at net.sf.jasperreports.engine.JasperCompileManager.compileReport(JasperCompileManager.java:211)
	at XmlAndSql.main(XmlAndSql.java:38)

In java code:

Code:

[code] import java.io.File; import java.sql.Connection; import java.sql.DriverManager; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import java.util.HashMap; import java.util.Map; import net.sf.jasperreports.engine.JRDataSource; import net.sf.jasperreports.engine.JREmptyDataSource; import net.sf.jasperreports.engine.JRResultSetDataSource; import net.sf.jasperreports.engine.JasperCompileManager; import net.sf.jasperreports.engine.JasperExportManager; import net.sf.jasperreports.engine.JasperFillManager; import net.sf.jasperreports.engine.JasperPrint; import net.sf.jasperreports.engine.JasperReport; import net.sf.jasperreports.engine.JasperRunManager; import net.sf.jasperreports.engine.design.JasperDesign; import net.sf.jasperreports.engine.util.JRLoader; import net.sf.jasperreports.engine.xml.JRXmlLoader; import net.sf.jasperreports.view.JasperViewer; public class XmlAndSql { public static void main(String[] args) throws SQLException { try { Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"«»); Connection conn = DriverManager .getConnection( "jdbc:«»sqlserver://matarotsrv:1433;databaseName=qm6", "sa", "sa"«»); // load JasperDesign from XML and compile it into JasperReport JasperDesign jasperDesign = JRXmlLoader.load("example2.xml"«»); // *** this is the line error!!! *** JasperReport jasperReport = JasperCompileManager.compileReport(jasperDesign); // create a map of parameters to pass to the report. Map<String,String> parameters = new HashMap<String,String>(); parameters.put("Title", "Customer List"«»); // create JasperPrint using fillReport() method JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, parameters, conn); // You can use JasperPrint to create PDF JasperExportManager.exportReportToPdfFile(jasperPrint, "example2.pdf"«»); // Or to view report in the JasperViewer JasperViewer.viewReport(jasperPrint, true); } catch (Exception e) { e.printStackTrace(); } } }

In xml:

Code:

[code] <title> <band height="50"> <textField> <reportElement x="0" y="0" width="200" height="50" /> <textFieldExpression class="java.lang.String">$P{Title}</textFieldExpression> </textField> </band> </title>

Please help me with that, I'm biginerr in xml & reports..:unsure:

[Problem with hebrew save file with JasperViewer]

Hi,

1)I have problem with hebrew data.

if I'm saving to pdf, csv.. I get gibbrish data.

(if the data in english - it's save good).

In my xml file:

Code:

<?xml version="1.0" encoding="UTF-8"?>
 

 

2)How can I "include" xml file to another xml file?

I want to different in one xml file some header reports...for once!!!

then to call (include) from all athers xml files to this header.

(instead all the time to write the same rows.. :))

Thanks.

I'm new in xml topic.