angelo.1981 Posted January 17, 2017 Share Posted January 17, 2017 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. Link to comment Share on other sites More sharing options...
peter.w Posted January 18, 2017 Share Posted January 18, 2017 In Jasper Studio you can add a new data set Right click on the report in the outline and chose Create Data Set This should create a subDataset in the jrxml something like this <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>[/code] Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now