I have a customer code that I fetch from a database table (in the report query), and I want to fetch a description for that code from another table, without use a join in the main query. It's possibile to use SQL syntax for a calculated field or there is another way to proceed?
Thanks for the answer.
<subDataset name="Dataset1" uuid="389126dd-bee9-4370-8d2f-72c1d645d833"> <property name="com.jaspersoft.studio.data.defaultdataadapter" value="MyDatabase-AdapterName"/> <queryString> <![CDATA[SELECT * FROM Table1]]> </queryString> </subDataset>