How to merge two tables with different datasets but certain common columns into a single table in jaspersoft studio using eclipse.

[agarwalgrishma334]

We are using the Jaspersoft version 6.17 and eclipse version 4.19 to achieve the result of merging two or more tables with common column attributes . Since the datasource being used for the table is dataset.jar and wnc provider classes we cannot use SQL Queries to implement them . So can you suggest an alternate approach ?

Thanks.

[Mehak Rajkumar]

Thank you for posting to the Jaspersoft Community. Our team of experts has read your question and we are working to get you an answer as quickly as we can. If you have a Jaspersoft Professional Subscription plan, please visit https://support.tibco.com/s/ for direct access to our technical support teams offering guaranteed response times.

[Jitendra Mandalia]

Hi

Can you please provide some more details here? Are you using custom JRDataSource implementation (.jar) or JasperReports DataSource provider class? How are you getting these two tables to the report?

It will be helpful if you can add some example of the same.

Thanks.

[Mehak Rajkumar]

Hi, can you please provide an update here if you still need assistance?