Jump to content
JasperReports Library 7.0 is now available ×

How to show Chat Of Accounts of Software In Single Report


mudassar1214

Recommended Posts

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

Link to comment
Share on other sites

  • 6 years later...
  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

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

Link to comment
Share on other sites

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,

Link to comment
Share on other sites

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...