In below SQL query I am not able to use DBlink using jasper report
select 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:
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.