sijaria

Hi, just wanted to know does ireport support "Pert chart" and "gantt chart".. can we create these chart using ireport is yes then please tell me how to create it... and if no then please tell me if want top create these two chart how i can create it if i have my all data in excel sheet.?? Thanks, Harringbone.

Thanks augarte.... i got the idea about it....

Hi, I want to print label in ireport of 8cm * 4cm of dimension ....so for that.... i created a report having dimension 8*4 and remove all margins and band...only a detail band i am using...but when i tried to compile it gives me error related to "Style".......... ----------------------------- "net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. The detail section, the page and column headers and footers and the margins do not fit the page height." ------------------------------ i tried to resolve it up to my level but .i can't understand..... i am writing .jrxml code below . of this report... If any one understand what is the mistake i have done..please tell..me... and how to solve it...please do let me know..... Thanks.., Code:<?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 http://jasperreports.sourceforge.net/xsd/jasperreport.xsd"; name="binning label 2" language="groovy" pageWidth="226" pageHeight="113" columnWidth="226" leftMargin="0" rightMargin="0" topMargin="0" bottomMargin="0" isIgnorePagination="true"> <parameter name="m_inout_id" class="java.math.BigDecimal"/> <queryString> <![CDATA[select miol.M_InOutLine_ID, mw.value as warehouselocation,ml.value as locatorvalue,miol.m_locator_id,ml.m_warehouse_id,miol.qtyentered,miol.m_product_id,mp.value as item,mp.name as description,miol.C_OrderLine_ID, col.c_order_id, co.documentno,miol.line,mio.C_BPartner_ID,mio.documentno as maindocumentno,cbp.name as dealername,mp.upc,mio.m_inout_id,mio.issotrx,mio.ad_client_id,mio.ad_org_id,mio.c_order_id,mpo.c_orderline_id, mpo.c_invoiceline_id, invl.c_invoice_id,inv.documentno as invNOfrom m_inoutline miolinner join m_locator ml on (ml.m_locator_id=miol.m_locator_id)inner join m_warehouse mw on (mw.m_warehouse_id=ml.m_warehouse_id)inner join m_product mp on (mp.m_product_id=miol.m_product_id)inner join c_orderline col on (col.C_OrderLine_ID=miol.C_OrderLine_ID)inner join c_order co on (co.c_order_id=col.c_order_id)inner join m_inout mio on (miol.m_inout_id=mio.m_inout_id)inner join c_bpartner cbp on (cbp.C_BPartner_ID=mio.C_BPartner_ID)inner join M_MatchPO mpo on (col.C_OrderLine_ID=mpo.C_OrderLine_ID)inner join c_invoiceline invl on (invl.c_invoiceline_id=mpo.c_invoiceline_id)inner join c_invoice inv on (inv.c_invoice_id=invl.c_invoice_id)where mio.issotrx = 'N' and mio.m_inout_id = 1000847 order by locatorvalue asc]]> </queryString> <field name="M_INOUTLINE_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="WAREHOUSELOCATION" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="LOCATORVALUE" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="M_LOCATOR_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="M_WAREHOUSE_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="QTYENTERED" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="M_PRODUCT_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ITEM" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DESCRIPTION" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="C_ORDERLINE_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="C_ORDER_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DOCUMENTNO" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="LINE" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="C_BPARTNER_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="MAINDOCUMENTNO" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="DEALERNAME" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="UPC" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="M_INOUT_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="ISSOTRX" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="AD_CLIENT_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="AD_ORG_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="C_INVOICELINE_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="C_INVOICE_ID" class="java.math.BigDecimal"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <field name="INVNO" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field> <detail> <band height="125" splitType="Stretch"/> </detail></jasperReport>

Thanks for your reply.. I have deleted all margins even all bands except detail band...but still above error is coming ... i am not able to understand what is the problem... i need only detail band of 8*4 cm dimension... please let me know...where i am doing mistake... Regard's..

I want to create a label from the ireport which is having width 8cm and height 4cm . How to do that.. I tried it..but getting error "net.sf.jasperreports.engine.design.JRValidationException: Report design not valid : 1. The detail section, the page and column headers and footers and the margins do not fit the page height." If any one know the solution please let me know.... Actually i deleted all band's except detail band and the page size is given 8*4 cm...but i am getting above error.... Please give me the solution.... Thanks...

In my jasper report...i want to print.same.row. multiple times...depending up on a qty which comes from that row...which is to be printed multiple times...? How i can do this.....please tell me..its...really very helpful for me..? Thank's..

I'm facing problem regarding jasper report's.... In Application Dictionary level..In report's and Process Screen...In Path field... We have to enter complete path to the war file which contain's all the .jrxml file's like.. "http://SystemName:webport:/WarfileName/.JRXMLfilename"...... but every time when create a new server i have to change the "SystemName" for that Machine on which i am creating server.....it is becoming problem for me..... If i want to give a Generic SystemName in Report path filed ..so that when ever i create a new server i don't have to change SystemName every time....???.. like localhost ...!!!.. I tried writing localhost instead of SystemName but it was not working...because of i think it is some thing related to jnp.!! Please let me know the solution for this... Regard's..

When i run my jasper report from Adempiere i got a problem that the ".jrxml file was coming from the temp folder of the computer...i deleted all .jrxml file from the temp folder again when i run report .jrxml file was again created in temp folder and coming from there...." When saw the error value storing in AbsolutePath of that particular .jrxml file is the path of the temp folder of that system...and this problem occuring with only two of my .jrxml file , the other file was working fine.... Please...if any one know the solution let me know ..... I can not able to understand why this file coming from temp folder why not from the .war file which i deployed in deploy folder of jboss in Adempiere home..?? For integrating these .jrxml file with Adempierre...I zip all my .jrxml file in to a .war file named: CustomReports.war and deployed it in deploy folder of jboss in Adempiere home.. and in Application dictionary ...level i give the path to the .war file in path filed of every report.. like "http://computername:webport/CustomReports/.jrxmlfile name" it is working properly .... in my system but when i did it in client system its give the above error.. that "AbsolutePath is the path of the temp folder" Please give me the solution...of this problem.... Regards...

Hi, I got stuck in a new problem to me... ...I want to print vertical lines in each page of my report...from the column header band to page footer band... for this currently i am using..background band....as well as detail band for printing vertical lines..but when report goes to new page and if details band get end in start of that page then blank space is coming from the end of detail band to start of the vertical lines that is on background band...That is creating big problem for me.. So if any one know to solve it..please let me know.... I am attaching my report with this.... Regards..

Thank's a lot.. your suggestion help me ..finally i got the solution..I have made a background band having vertical lines which has height related to detail band..and i got the desired output... thank's a lot...

I am trying to create an invoice document but getting blank space between detail band column footer band.. actually the data coming on the detail band is not enough to fill completely the detail band.. but i still want to print at least.. vertical lines in detail band... i have tried to to set column footer variable "true" but the size of the page reduced vertically..i want the page size remain.. A4.. so i got stuck with this problem can any one know the solution... i am attaching a pdf file having blank space in detail band... please let me know.. thanks..