How to show Chat Of Accounts of Software In Single Report

[mudassar1214]

dear experts

i am new in this community so plese guide me. i have created new java software and my software has 10 accounts in 

difrent tables (customers(2),employees(2),shipper(3),suppliers(3)) so i want to show chart of account is single report 

with table name but when i try that 's show me all tables data in one colum so plese tell me solution

[Mehak Rajkumar]

@mudassar1214Thank 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.
 

[Raphaël Peguet]

Hello,

This question here is how to generate a SQL query which would retrieve the correct data. If you have 10 tables for 10 accounts and that you need a list of accounts you will need to UNION the tables instead of the standard joins.

Which databases do you use to store the accounts? Most databases come with a tool to build queries, I'd recommend you do that first and then paste the query that works in Jaspersoft to build your report.

 Please let me know if that helps.

Thanks,