[postgres 9.1]

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

[dril down report run in ireport]

how the jasper server function?

i have no ideal how it work.

can some one give me some hits

thank

[PHP and ireport]

can any one teach

how to using PHP to call a ireport

[Hyperlink to a Drilldown Report]

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>

[Hyperlink to a Drilldown Report]

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

[dril down report run in ireport]

can any one answer me

drill down report can run in ireport 3.7.4 or not??

if not how i going to do??

[How to do a drill drop report]

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]

How to do a drill drop report in ireport

[Help]

Can any one help??

[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      

  

[to have to detail section]

hi every one

is it possible to have to detail section?

[how to convert amount to word in ireport]

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

[how to return value from the subreport]

thank a lot

[how to return value from the subreport]

Hi all

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

[how to get subreport path in java]

any one can help? urgent

[how to get subreport path in java]

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

[how to get subreport path in java]

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

[recursive report]

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

[recursive report]

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

[recursive 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

[how to print out the picture which store in table]

Code:

how to print out the picture store in the database table

[error when print preview]

Code:

java.lang.ExceptionInInitializerError



	at org.codehaus.groovy.runtime.InvokerHelper.<clinit>(InvokerHelper.java:46)



	at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.invokeStaticMethodN(ScriptBytecodeAdapter.java

[ireport can not compiler]

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

[Print if...]

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

can give more detail

[how to set the width for the bar in barchat]

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