iReport QA

Only part of the Axis Label Expression is displaying.  The attachment shows the value the Axis Label Expression set to and how only part of the expression appears on the graph. 

I've been using iReport for over 7 years to layout jasper reports and am very profient with the classic version.  I am extremely disappointed with what I've seen in the nb version so far.  There are so many subtle changes that dramatically decrease productivity, that it is a major step backwards.  I've attempted to report several issues as bugs, with most of them closed mentioning a an obscure but less efficient workaround.  The problems I'm having are so severe, I'm beginning to wonder whether or not I can continue to use iReport at all.

Among the problems I have with the new version:

1)  No support at all for barcodes.  This was extremely important in several of the postal and shipping reports I've created over the years.

2)  The new way of selecting multiple elements has several problems.  Previously you could hold down shift and quickly click around the screen to select multiple items.  If you accidently selected something you didn't want, you could simply click on it while holding shift again to de-select it.  If you tried to shift click on something and missed (eg clicked in an empty section), it wasn't a problem.  Now you have to double-click to de-select an item which is awkward.  Even worse, holding Ctrl and clicking an an empty area (easy to do with a complicated design, or when trying to click on a graphic line) clears out everything you've selected, forcing you to start over.

3)  copying and pasting is almost unusable now.  In the old version, you could select one or more elements then press ctrl C and Ctrl V to copy all of those elements.  The best thing about this under the classic designer was that as part of the paste, all of the copied elements were offset horizontally and vertically by 10 pixes and all of them were automatically selected.  This made it very easy to use the arrow keys + Shift to re-align an entire section to where it needed to be copied to.  Since many reports have similar graphic/text sections it reduced report design time. 

With the new product you can still select and copy multiple elements.  However, they are copied into the exact same x/y coordinates as the source and even worse they are not selected, which makes it really hard to reselect just the copies and move them to where they belong.  Instead of being able to copy 5 or 10 elements at the same time into correct position, it forces you copy each element one at a time, which really slows down the layout.

There also seems to be a limit on how many elements may be pasted at once.  I tried to select 62 elements from one report and copy them into the page of a different report.  For some reason only 7 elements were copied onto the other report.

4)  Under the classic version it was possible to manipulate the Z coordinate of graphic elements.  This was important when attempting to have text items in front of background image or background color filled graphic elements.  This was down by simply clicking on an element and choosing "send to back" or "bring to front".  That functionality seems to be lost in the nb version which makes it difficult to correctly layout reports with overlaid elements.

5)  Under the classic version it was possible to see whether or not a valid variable, field or parameter was being used in the popup properties editor by the color of text in the Text Field Expression section.  This was it was really easy to have the popup window open and click around the elements to check the variables being used.  Under the nb version the property sheet does not feature the same color highlighting for variable names.  To see it, you have to click on the elipse to open up the text field expression dialog.  This dialog has to be closed before choosing another element which again subtly slows down the editing process.

6)  having to confirm that I really want to delete something every time I press delete is annoying.  There should be a way to turn this confirmation/warning off for advanced users.

I would like to second (or n-th by this time) the comments by ddavis. I have only been using iR for about  a year. If I had not started on the classic, I would have simply thought the nb version was simply a lacking IDE for report generation. Having seen the potential in classic, I think it is important to add these features in the very near future. While there are several new and very useful features in nb (and 3.5.0 is an improvement), the lack of certain basic operations makes it very difficult to develop any sort of complex reports. I am glad that ddavis was able to take the time to carefully articulate the areas that are missing, many of which are what is keeping me from using the nb version to develop reports. One thing I would add to the object selection process is the ability to rubber band (click-hold) more than one area. In classic, you could rubber band while holding the shift key to select several discontiguous areas. This allows the user to select these areas and apply a common change (height, width, etc.). The nb version resets the previous selection once the mouse is clicked off an object (regardless of the key chords pressed).

Thanks,

Ed.

To help you understanding what we are doing:

We use iReport with a JasperReport custom server, filled by xml datasource.

We integrate iReport within a Python / Qt application.

Templates (jrxml) are stored / versioned in a database, and used directly by the server.

Our templates heavily rely on subreports, which are dynamically choosen from user data.

Now, some things I hate in ireport-nb:

 1) Property window, really hard to get for end users. Please give it back as in iReport-classic (left button on an element), it was fantastic :-)

 2) As said just before by someone: colors are a cool thing! Users are now use to thoses colors! (Green OK)

 3) Alignments are really cool things, Isn't it possible to get it like in the other version in the menubar ? (I've tried to create a new toolbar, no success)

 4) iReport-nb launcher do not understand files other than ".jrxml" files... So bad! Isn't it possible to add an extra argument in the command line to get thoses files opened as jrxml reports ? (Our users of iReport don't care of netbeans)

 5) Please give us the possibilty NOT to load previous opened files!!!! (Example: open a ".xml" file, Open a report, close iReport, launch iReport, the xml file is loaded!)

 6) Why drag & droping fields in the "display" between bands do not switch which band contains the element?

 7) Zoom / Page width was REALLY an amazing feature!

 8) Styles (Bold, italic, ...) in the designer view are hidden if the screen is not large enough, isn't it possible to get it back in the toolbar like "open, save, ..." ? (Like in office, openoffice, ...)

Things I love in iReport-nb:

 1) Customization, really amazing (but buggy :))

 2) It's fast, really! Good job!

 3) JR 3.5 full support

 4) Properties window can modify ALL things ! Really cool if it could be accessed with left button ;-))

Hope it'll help you improve this beautifull product.

Many thanks for that really good piece of code,

Best regards,

Laurent

I just wanted to come back and thank the development team for the many improvements included in the nb 3.5.1 release.  I dowloaded it the day it came out and am very pleased with the improved usability.  I created a multi-page report from scratch within one day with the new version, making heavy use of the new copy/paste functionality.  The quick turnaround has created some fans in our management team as well.

[6/1/09 10:09:24:821 SGT] 0000002e Digester E TRAS0014I: The following exception was logged org.xml.sax.SAXParseException: Element type "topPen" must be declared.

 Hi,

          I have installed iReport 3.0.1 in netbeans 6.5.How to start using iReport for Visual Web Pack components.

There isn't any documents available.Please suggest me ,how to proceed.

Thanks

Amarshi

Hi everybody,

I just began making reports in Ireport. Everything works just fine. However there are a couple of things that are not so easy (if you don't have any Java knowledge that is).

I am trying to make a hyperlink reference in a column. So far so good. But how do set up the link so that it references to another report that i have made.

hope someone can help me

Many  thanx in advance

I noticed that grouping is missing in netbeans:

1. in classic, you can select items that you want to group,  right click and then select 'Group selected element(s)'

2. if you add elementGroup tags in the code and then go to Report Inspector, the label 'Element group' is missing next to document structure item

Hi

I have a question about the input controls. I want to have three drop down boxes on my report. The first one should be a simple single select query. The second box should only show values dependent on the value given in box 1. same goes for box 3.

Is there anyway to do this?

Hi,

I create a main report with a subreport, but the subreport didn't compiled when I execute the main report, how can I set ireport can make them compiled together?

Thx & Best Regards!

Hi,

i am a ireport developer from Hong Kong, i would like to create an order sheet report.
Just simple show the order list with different sub total,
but i found that there is a problem on the sub total, please see the sample
user A have an order list

Lot No.    Colour      Size     Length           Qty
0001          B               S           32                100
0001          B               S           33                100
0001          B               M           34                100
0002          B               M           32                100
0002          B               M           33                100
0002          R               M           34                100

now the requirement want to group by Size, Colour, Lot No.
I expected the result will like this

Lot No.    Colour      Size     Length           Qty
0001          B               S           32                100
0001          B               S           33                100
------------------------------------------------------------
Size:                                                          200
0001          B               M           34                100
 ------------------------------------------------------------
Colour :                                                    300
0002          B               M           32                100
0002          B               M           33                100
 ------------------------------------------------------------
Lot No.:                                                     500
0002          R               M           34                100
 ------------------------------------------------------------
Size                                                          600
Colour                                                      600
Lot No.:                                                    600

But now the report become

Lot No.    Colour      Size     Length           Qty
0001          B               S           32                100
0001          B               S           33                100
------------------------------------------------------------
Lot No.:                                                    200
Colour                                                      200
Size                                                           200
0001          B               M           34                100
 ------------------------------------------------------------
Lot No.:                                                    300
Colour                                                      300
Size                                                           300
0002          B               M           32                100
0002          B               M           33                100
 ------------------------------------------------------------
Lot No.:                                                    500
Colour                                                      500
Size                                                           500
0002          R               M           34                100
 ------------------------------------------------------------
Lot No.:                                                    600
Colour                                                      600
Size                                                          600

 Seems the group have problem, either one value changed, all groups will be print out.
What do you think? i am using 3.6.0 (most updated version, same problem found)

,Choi
 

Hi,

i'm new to iReport.

i wonder if i need JasperReport if i already has the iReport? i've downloaded iReport for the NetBean plugin, i can design and compile the report

now what must i do to load the report in Java application? how to install JasperReport in Windows? 

Thank you!

Please disregard this message.

Hi,

Whilst I am new to iReports, I have been working with reporting tools for many years and I have issues with Jasper iReports V3.7 handling of Input Parameters and Patterns...

My problem is that I want to choose 2 dates each formatted as "yyyy-MM-dd HH:mm:ss.SSS" being 4 digit year, 2digit month, 2 digit day, 2 digit Hour, 2 digit minute, 2 digit seconds and 3 digit micro-seconds.  This is a mandatory requirement for our Systems Engineering guys to get this sort of fine grained reporting from our Database.

I have not had any success in getting this to work.  The xml snippets below is from one of our reports...

    <parameter name="StartDate" class="java.util.Date" isForPrompting="false" />
    <parameter name="EndDate" class="java.util.Date" isForPrompting="false" />
    <queryString>
        <![CDATA[SELECT
 FROM_UNIXTIME(WF_Timestamp) Req_Date_Time,
 SUBSTR(Request_URL,1,LOCATE("?",Request_URL)-1) Search_URL,
 REPLACE( SUBSTR( SUBSTR( Request_URL, LOCATE( "?",Request_URL ) +1 ),1),"+"," ") Search_Terms,
 User_Name,
 Source_IP_Address Client_IP
FROM REPORTING.WEBFILTER_REPORTING
WHERE (LOCATE('google',lower(Request_URL))>0 OR LOCATE('yahoo',lower(Request_URL))>0)
AND LOCATE('http://localhost/cgi-bin/utils/proxy/',Request_URL)=0
AND Flags < 64
AND (FROM_UNIXTIME(WF_Timestamp) BETWEEN $P{StartDate} AND  $P{EndDate})]]>
    </queryString>

Note: The WF_Timestamp above is a UNIX TIMESTAMP including Time to nano-seconds.

and

    <pageFooter>
        <band height="27">
            <textField>
                <reportElement mode="Opaque" x="0" y="4" width="734" height="13" backcolor="#E6E6E6"/>
                <textElement textAlignment="Right"/>
                <textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
            </textField>
            <textField evaluationTime="Report">
                <reportElement mode="Opaque" x="734" y="4" width="52" height="13" backcolor="#E6E6E6"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
            </textField>
            <textField pattern="yyyy-MM-dd HH:mm:ss">
                <reportElement x="0" y="4" width="120" height="13"/>
                <textElement/>
                <textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="130" y="4" width="118" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA["Date range between: "]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="248" y="4" width="135" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS").format($P{StartDate})]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="386" y="4" width="35" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[" and "]]></textFieldExpression>
            </textField>
            <textField>
                <reportElement x="424" y="4" width="139" height="13"/>
                <textElement/>
                <textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss.SSS").format($P{EndDate})]]></textFieldExpression>
            </textField>
        </band>
    </pageFooter>
 

Please advise how I can set up an Input Control which will present itself as a Date, Time , Microtime formatted as "yyyy-MM-dd HH:mm:ss.SSS"

I am not a Java Programmer, but can understand the use of the various classes ie: java.sql.Timestamp, java.util.Date and the methods they provide etc...

Please avoid the US Convention of "MM-dd-yyyy" as this is just plain confusing for our European and Australasian Clients.

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports <a href="http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"" target="_blank">http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"</a> name="SearchEngineRequests" language="groovy" pageWidth="842" pageHeight="595" orientation="Landscape" whenNoDataType="AllSectionsNoDetail" columnWidth="786" leftMargin="28" rightMargin="28" topMargin="28" bottomMargin="28">
	<parameter name="StartDate" class="java.util.Date" isForPrompting="false" />
	<parameter name="EndDate" class="java.util.Date" isForPrompting="false" />
	<queryString>
		<![CDATA[SELECT
 FROM_UNIXTIME(WF_Timestamp) Req_Date_Time,
 SUBSTR(Request_URL,1,LOCATE("?",Request_URL)-1) Search_URL,
 REPLACE( SUBSTR( SUBSTR( Request_URL, LOCATE( "?",Request_URL ) +1 ),1),"+"," ") Search_Terms,
 User_Name,
 Source_IP_Address Client_IP
FROM REPORTING.WEBFILTER_REPORTING
WHERE (LOCATE('google',lower(Request_URL))>0 OR LOCATE('yahoo',lower(Request_URL))>0)
AND LOCATE('http://localhost/cgi-bin/utils/proxy/',Request_URL)=0
AND Flags < 64
AND (FROM_UNIXTIME(WF_Timestamp) BETWEEN $P{StartDate} AND  $P{EndDate})]]>
	</queryString>
	<field name="Req_Date_Time" class="java.sql.Timestamp">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="Search_URL" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="Search_Terms" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="User_Name" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="Client_IP" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<background>
		<band/>
	</background>
	<pageHeader>
		<band height="103">
			<line>
				<reportElement x="0" y="102" width="786" height="1" forecolor="#000000"/>
			</line>
			<staticText>
				<reportElement x="383" y="34" width="403" height="35" forecolor="#0099CC"/>
				<textElement textAlignment="Right">
					<font size="24" isBold="true"/>
				</textElement>
				<text><![CDATA[Search Engine Keywords Report]]></text>
			</staticText>
			<image>
				<reportElement x="0" y="0" width="277" height="91"/>
				<imageExpression class="java.lang.String"><![CDATA["repo:EditureWebLogo.gif"]]></imageExpression>
			</image>
		</band>
	</pageHeader>
	<columnHeader>
		<band height="28">
			<line>
				<reportElement x="0" y="26" width="786" height="1" forecolor="#666666"/>
			</line>
			<staticText>
				<reportElement x="0" y="5" width="97" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Request Date]]></text>
			</staticText>
			<staticText>
				<reportElement x="370" y="5" width="239" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Request URL]]></text>
			</staticText>
			<staticText>
				<reportElement x="617" y="5" width="169" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Search Terms]]></text>
			</staticText>
			<staticText>
				<reportElement x="97" y="5" width="156" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[User Name]]></text>
			</staticText>
			<staticText>
				<reportElement x="266" y="5" width="103" height="20"/>
				<textElement markup="none">
					<font fontName="SansSerif" size="10" isBold="true"/>
				</textElement>
				<text><![CDATA[Client IP]]></text>
			</staticText>
		</band>
	</columnHeader>
	<detail>
		<band height="28">
			<textField>
				<reportElement x="0" y="4" width="97" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.sql.Timestamp"><![CDATA[$F{Req_Date_Time}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="97" y="4" width="156" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{User_Name}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="266" y="4" width="103" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{Client_IP}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="370" y="4" width="239" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{Search_URL}]]></textFieldExpression>
			</textField>
			<textField isStretchWithOverflow="true">
				<reportElement x="617" y="4" width="169" height="20"/>
				<textElement>
					<font fontName="SansSerif"/>
				</textElement>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{Search_Terms}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement positionType="FixRelativeToBottom" x="0" y="26" width="786" height="1"/>
			</line>
		</band>
	</detail>
	<columnFooter>
		<band/>
	</columnFooter>
	<pageFooter>
		<band height="27">
			<textField>
				<reportElement mode="Opaque" x="0" y="4" width="734" height="13" backcolor="#E6E6E6"/>
				<textElement textAlignment="Right"/>
				<textFieldExpression class="java.lang.String"><![CDATA["Page "+$V{PAGE_NUMBER}+" of"]]></textFieldExpression>
			</textField>
			<textField evaluationTime="Report">
				<reportElement mode="Opaque" x="734" y="4" width="52" height="13" backcolor="#E6E6E6"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[" " + $V{PAGE_NUMBER}]]></textFieldExpression>
			</textField>
			<textField pattern="yyyy-MM-dd HH:mm:ss">
				<reportElement x="0" y="4" width="120" height="13"/>
				<textElement/>
				<textFieldExpression class="java.util.Date"><![CDATA[new java.util.Date()]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="130" y="4" width="118" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA["Date range between: "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="248" y="4" width="135" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format($P{StartDate})]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="386" y="4" width="35" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[" and "]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="424" y="4" width="139" height="13"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[new java.text.SimpleDateFormat("yyyy-MM-dd HH:mm:ss").format($P{EndDate})]]></textFieldExpression>
			</textField>
		</band>
	</pageFooter>
	<summary>
		<band/>
	</summary>
</jasperReport>
</td></tr></tbody></table>

hi..........good morning.............

I'm Moncy Mathai..........i'm a fresher.......just joined a software company.............

i have been asked to work on iReport 3.5.2.............

i learned to desing jrxml file & create connection between jrxml file & database.

I got into a problem.

Problem is that only the first data from the table is executed.

i'm sending you the code of jrxml file which i created & also the jrxml file & jasper file is attached.

I'll be thank full to u if u can help me in this matter.

Thanks a lot in advance.

Attach : 1) bill_report.jrxml

2) bill_report.jasper

<?xml version="1.0" encoding="UTF-8"?>
<jasperReport xmlns="http://jasperreports.sourceforge.net/jasperreports" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://jasperreports.sourceforge.net/jasperreports <a href="http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"" target="_blank">http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"</a> name="report name" pageWidth="595" pageHeight="842" columnWidth="535" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20">
	<queryString>
		<![CDATA[SELECT
     billmaster.`BILLNUMBER` AS billmaster_BILLNUMBER,
     billmaster.`POID` AS billmaster_POID,
     billmaster.`BILLVALUE` AS billmaster_BILLVALUE
FROM
     `billmaster` billmaster]]>
	</queryString>
	<field name="billmaster_BILLNUMBER" class="java.lang.String">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="billmaster_POID" class="java.lang.Integer">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<field name="billmaster_BILLVALUE" class="java.lang.Float">
		<fieldDescription><![CDATA[]]></fieldDescription>
	</field>
	<background>
		<band splitType="Stretch"/>
	</background>
	<title>
		<band height="85" splitType="Stretch">
			<staticText>
				<reportElement x="20" y="26" width="126" height="39"/>
				<textElement>
					<font size="22"/>
				</textElement>
				<text><![CDATA[Bill Report]]></text>
			</staticText>
			<staticText>
				<reportElement x="184" y="47" width="41" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[From]]></text>
			</staticText>
			<line>
				<reportElement x="246" y="66" width="100" height="1"/>
			</line>
			<staticText>
				<reportElement x="366" y="47" width="37" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[To]]></text>
			</staticText>
			<line>
				<reportElement x="436" y="65" width="100" height="1"/>
			</line>
		</band>
	</title>
	<pageHeader>
		<band height="19" splitType="Stretch"/>
	</pageHeader>
	<columnHeader>
		<band height="85" splitType="Stretch">
			<rectangle>
				<reportElement x="20" y="9" width="516" height="76"/>
			</rectangle>
			<line>
				<reportElement x="77" y="9" width="1" height="76"/>
			</line>
			<line>
				<reportElement x="146" y="9" width="1" height="76"/>
			</line>
			<line>
				<reportElement x="443" y="10" width="1" height="75"/>
			</line>
			<staticText>
				<reportElement x="31" y="36" width="34" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[S.No]]></text>
			</staticText>
			<staticText>
				<reportElement x="84" y="36" width="45" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Bill No]]></text>
			</staticText>
			<staticText>
				<reportElement x="159" y="36" width="100" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Vendor Name]]></text>
			</staticText>
			<staticText>
				<reportElement x="361" y="36" width="75" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Submit Rate]]></text>
			</staticText>
			<staticText>
				<reportElement x="444" y="36" width="92" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Settled Amount]]></text>
			</staticText>
			<line>
				<reportElement x="355" y="9" width="1" height="76"/>
			</line>
		</band>
	</columnHeader>
	<detail>
		<band height="352" splitType="Stretch">
			<rectangle>
				<reportElement x="20" y="0" width="516" height="352"/>
			</rectangle>
			<textField>
				<reportElement x="84" y="9" width="58" height="58"/>
				<textElement/>
				<textFieldExpression class="java.lang.String"><![CDATA[$F{billmaster_BILLNUMBER}]]></textFieldExpression>
			</textField>
			<textField>
				<reportElement x="454" y="9" width="72" height="44"/>
				<textElement/>
				<textFieldExpression class="java.lang.Float"><![CDATA[$F{billmaster_BILLVALUE}]]></textFieldExpression>
			</textField>
			<line>
				<reportElement x="443" y="0" width="1" height="352"/>
			</line>
			<line>
				<reportElement x="355" y="0" width="1" height="352"/>
			</line>
			<line>
				<reportElement x="77" y="0" width="1" height="352"/>
			</line>
			<line>
				<reportElement x="146" y="0" width="1" height="352"/>
			</line>
		</band>
	</detail>
	<columnFooter>
		<band height="62" splitType="Stretch">
			<rectangle>
				<reportElement x="20" y="0" width="516" height="50"/>
			</rectangle>
			<staticText>
				<reportElement x="225" y="17" width="100" height="20"/>
				<textElement>
					<font size="12"/>
				</textElement>
				<text><![CDATA[Total]]></text>
			</staticText>
			<line>
				<reportElement x="77" y="0" width="1" height="50"/>
			</line>
			<line>
				<reportElement x="146" y="0" width="1" height="50"/>
			</line>
			<line>
				<reportElement x="355" y="0" width="1" height="50"/>
			</line>
			<line>
				<reportElement x="443" y="0" width="1" height="50"/>
			</line>
		</band>
	</columnFooter>
	<pageFooter>
		<band height="54" splitType="Stretch"/>
	</pageFooter>
	<summary>
		<band height="42" splitType="Stretch"/>
	</summary>
</jasperReport>
</td></tr></tbody></table>

hi rushit,

Since u had been using ireport for quite 2 years. can u able to guide us by creating an custom variable which contain our simple calculations (+ , - , x and division )  . How can make simple sql expression and store it in a vairable and display it.

I had been trying this for quite 3 months.

Hello,  I am new to iReport.  My company is using 3.0.0.  I want to create a crosstab report.  It does not give me a count in the detail boxes.  It just displays the last value encountered in the data source.  What am I doing wrong?  Thanks for your help.

Hi,

I have been using iReports for a period of over 2 weeks now and I must say that I like all the featues and I am almost able to do all the existing reports on it with much ease. (using variety of featues - subreports, scriptlets, graphs).

The only issue/question that I have is whether there is any feature on templates that allows me to do multiple templates for each report. The point is I always have to do an export to CSV, PDF, Text versions (and may be more depending on client's requirements) whenever I fire a report request from the website. Now the reports are quite complex and there are multiple groupings and sub-groupings on it. The PDF version that I get is lovely while the CSV version is rubbish. I have tried getting around this by printing different bands for CSV and PDF - it definitely works but is extremely tedious for complex reports - specially when CSV works best with cartesian data format (tabular) and PDF looks best when data is not arranged in a cartesian manner.

If there was a feature which would allow me to select which template to run for a given report(jrxml) i.e allowing multiple templates for the same report(.jrxml file) based on a parameter, I could easily define different templates for different expected formats rather than selecting different bands.

Can you please advise on whether any such feature is desirable or is selection of bands the only option going forward. I wouldn't want to do different jrxm files for the same report as wouldn't want the query to run twice (fairly complicated and time consuming queries)

Thanks & Regards,

Amit

 Hello there

I am having a problem with runing iReport.

I freshly installed the 3.7.6 version, and at the begining when I tried to open it, gave me the error:"Cannot find java.exe".

I created an environment variable JAVA_HOME which points to my JDeveloper java.exe file, and when I start the iReport application it doesn't do anything

Can you tell me what can I do?

Thank you

Angel

 Hi,

I want to show to a jasper-server logged-in user only reports he should see,  accoring to a mapping i have in the DB.

so i want to add his username to a 'WHERE' clause in the iReport main query to know if to allow him to see the report.

Is it  possible to get a username that logged in to the jasper server and use it in iReport query to display the relevant report according to the username.

or if there is another way, i would be glad to hear about it.

thanks!

hi there. i'm stuck with my java project regading integrating ireports. can anyone help me please on how to call an ireport 3.7.6 in java. i'm using netbeans ide version 6.9.1.

Hi!

I'm using jasper report 3.7.3. When displaying data in adempiere it's ok but if I export it to pdf the resutl is a blank pdf file.

It works fine if I export to Excel.

Do you know the reason?

Thanks for your help!

Hello,

 Is there a way to customize the ireport tool, means I need to hide option/functionality in the tool. How can I achieve that?

Thanks,

Anita

 Hello,

I'm using RunJasperReport to generate reports from the command-line.

I would like to add settings so I can set the correct Locale, I assume I have to set that with the '-params'  as a command-line option.

I tried  -params 'localereport:locale:DE-de' 

but I get error message: "Can't find bundle for base name localereport, locale en_US"

BTW: Setting/changing the default locale in  iReport (Preferences / Execution options) works.