alvintkl

before this i using postgres 8.4 to run the report i save in the database but after i change to postgres 9.1 then the same report can not run already show me error not in GZIP format can any one help me on this

how the jasper server function? i have no ideal how it work. can some one give me some hits thank

can any one teach how to using PHP to call a ireport

Hi Carl i try ur drill1 and drill2 report, both can run but when i try to run the drill1 and then link the drill2, it nothing come out what should i do? i'm using ireport3.7.4 and i save the file under c:\test can you help me? is this because i not have jasperserver? Code:<band height="20" splitType="Stretch"> <textField hyperlinkType="ReportExecution"> <reportElement style="BandedTable" mode="Opaque" x="0" y="0" width="53" height="20"/> <textElement/> <textFieldExpression class="java.lang.String"><![CDATA[$F{STATEABBR}]]></textFieldExpression> <hyperlinkParameter name="_report"> <hyperlinkParameterExpression><![CDATA["C:/test/drill2"]]></hyperlinkParameterExpression> </hyperlinkParameter> <hyperlinkParameter name="TargetStateAbbr"> <hyperlinkParameterExpression><![CDATA[$F{STATEABBR}]]></hyperlinkParameterExpression> </hyperlinkParameter> <hyperlinkParameter name="TargetStateName"> <hyperlinkParameterExpression><![CDATA[$F{STATENAME}]]></hyperlinkParameterExpression> </hyperlinkParameter> </textField>

Carl the drill1 and drill2 can run individualy but i try to run drill1 and link the drill2 it can not work what is the problem i using ireport 3.7.4 only

can any one answer me drill down report can run in ireport 3.7.4 or not?? if not how i going to do??

i have try to create this two file and save in my c:/test attach is my file but when i run the drill1 report in the ireport and the report can be previewed but can not preview the drill2 report Code:<textFieldExpression class="java.lang.String"><![CDATA[$F{STATEABBR}]]></textFieldExpression> <hyperlinkParameter name="_report"> <hyperlinkParameterExpression><![CDATA["C://test/Drill2"]]></hyperlinkParameterExpression> </hyperlinkParameter>

How to do a drill drop report in ireport

Can any one help??

i have 2 table table 1 stock_nbr , cont_id, qty_order 001 A001 10 002 A002 20 002 A001 20 Table 2 Stock_nbr Total Order 001 10 002 40 How to join this two table and show in ireport in below format Stock_nbr, A001,A002 ,Total_Order 001, 10, 0 ,10 002, 20, 20,40

hi every one is it possible to have to detail section?

hi i using postgres database and ireport 3.7.1 i need to convert amount to word i know it need to created function in the database but i have no idea to do it can any expert guide me

thank a lot

Hi all How to return a value calculated at subreport and return back to main report to use

any one can help? urgent

but what i do is i compiler the report and save it into a table and give the report a report name

i using postgres8.1 and ireport 3.7.1 and using java to develop software i compiler the report and put into the database but i got the problem to get the path for subreport in java any one can help urgent

thank slow i use second method it work , but it got limit on the level have to add according to the data this is my sql look like SELECT ts1.bommst_code,st1.stock_name as stockname1,1.00 as qty_req1, ts1.subbom_code AS lev1,st2.stock_name as stockname2,bd1.qty_req as qty_req2,ts2.subbom_code as lev2,st3.stock_name as stockname3,bd2.qty_req as qty_req3,ts3.subbom_code as lev3,st4.stock_name as stockname4,bd3.qty_req as qty_req4,ts4.subbom_code as lev4,st5.stock_name as stockname5,bd4.qty_req as qty_req5 FROM bom_detail ts1 Left join stockitem st1 on ts1.bommst_code=st1.stock_nbr and ts1.co_id=st1.co_id LEFT JOIN bom_detail ts2 ON ts2.bommst_code = ts1.subbom_code Left join stockitem st2 on ts1.subbom_code=st2.stock_nbr and ts1.co_id=st2.co_id Left join bom_detail bd1 on bd1.subbom_code=ts1.subbom_code and bd1.co_id=ts1.co_id LEFT JOIN bom_detail ts3 ON ts3.bommst_code = ts2.subbom_code Left join stockitem st3 on ts2.subbom_code=st3.stock_nbr and ts2.co_id=st3.co_id Left join bom_detail bd2 on bd2.subbom_code=ts2.subbom_code and bd2.co_id=ts2.co_id LEFT JOIN bom_detail ts4 ON ts4.bommst_code = ts3.subbom_code Left join stockitem st4 on ts3.subbom_code=st4.stock_nbr and ts3.co_id=st4.co_id Left join bom_detail bd3 on bd3.subbom_code=ts3.subbom_code and bd3.co_id=ts3.co_id LEFT JOIN bom_detail ts5 ON ts5.bommst_code = ts4.subbom_code Left join stockitem st5 on ts4.subbom_code=st5.stock_nbr and ts4.co_id=st5.co_id Left join bom_detail bd4 on bd4.subbom_code=ts4.subbom_code and bd4.co_id=ts4.co_id WHERE ts1.bommst_code not in (select distinct t.subbom_code from bom_detail t) and ts1.bommst_code=$P{stock_nbr} order by 1,2,3,4,5

i using postgres8.1 and using ireport3.7.1 to do the report

i need help i want to do a BOM report(Build of Material) i have two table call bom_mst and bom_detail in bom_mst will have data like below bommst_code 2110000000000150 2110230000025220 2110230000025210 in bom_detail have data below bommst_code subbom_code 2110000000000150 2110230000025220 2110000000000150 2110230000028850 2110230000025220 2110230000025210 2110230000025220 2110230000025270 2110230000025210 2110010000012450 2110230000025210 2110010000012850 2110230000025210 2110010000013250 how to do the report so it will print out like 2110000000000150 2110230000025220 2110230000025210 2110010000012450 2110010000012850 2110010000013250 2110230000025270 2110230000028850

Code:how to print out the picture store in the database table

Code:java.lang.ExceptionInInitializerError at org.codehaus.groovy.runtime.InvokerHelper.<clinit>(InvokerHelper.java:46) at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeStaticMethodN(ScriptBytecodeAdapter.java

i have jre1.5.0.07 in my server when i compiler the jxml i get this error : Error were encountered when compiling report expression class file: 1.The type java.lang.Object cannot be resolved.It is indirectly referenced from required.class files /* ^ 1 errors any one can help me what is the wrong

what you mean by "All companies" in the expression ("%".equals($P{Company})? "All Companies" : $P{Company}) can give more detail

can please let me know more detail, where to put this code?