I Need to get symbol column from symbols table using symbol id, while i select the input parameter like symbol_name, There are 2 files used for single report. In Main.jrxml using join query to acheive it. but its getting null value. Is there any possible solution for this issue?

MainQuery:

Select * from sales_depart LEFT JOIN symbols on symbols.symbol_id = sales_depart.symbol_id

<field name="symbol" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field>

<textField> <textFieldExpression><![CDATA[$F{store_name}+ ":"+ $F{currency}]]></textFieldExpression> </textField>

I Need to get symbol column from symbols table using symbol id, while i select the input parameter like symbol_name, There are 2 files used for single report. In Main.jrxml using join query to acheive it. but its getting null value. Is there any possible solution for this issue?

MainQuery:

Select * from sales_depart LEFT JOIN symbols on symbols.symbol_id = sales_depart.symbol_id

<field name="symbol" class="java.lang.String"> <fieldDescription><![CDATA[]]></fieldDescription> </field>

<textField> <textFieldExpression><![CDATA[$F{store_name}+ ":"+ $F{currency}]]></textFieldExpression> </textField>

• jasper-reports

Share Follow edited Mar 16 at 14:47 Alex K 22.9k1919 gold badges114114 silver badges243243 bronze badges asked Mar 3 at 11:02 KalavathiKalavathi 122 bronze badges

Add a comment  | 

1 Answer 1

Sorted by: Reset to default 0

try not to left join and run query and see it it works. perhaps your join is wrong