priyanka01031983 Posted March 23, 2019 Share Posted March 23, 2019 In below SQL query I am not able to use DBlink using jasper reportselect column_name from user_tab_columns where table_name = 'order' minus select column_name from user_tab_columns where table_name = 'order@DB_test';where DB_test is a different server. one server I have connected as below: Link to comment Share on other sites More sharing options...
hozawa Posted March 27, 2019 Share Posted March 27, 2019 iReport is no longer being developed nor supported. Please use Jaspersoft Studio instead.In Jaspersoft Studio'&s "Dataset and Query Dialog", enter you sql statement and at the bottom tab, select "Data preview" and click on "Refresh Preview Data". If data does not show up, it means Jaspersoft Studio does not support DBlink. In this case, you'll have to write your own program that uses JasperReports library. 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