mudassar1214 Posted January 30, 2017 Share Posted January 30, 2017 dear expertsi 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 More sharing options...
Mehak Rajkumar Posted December 4, 2023 Share Posted December 4, 2023 @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 More sharing options...
Raphaël Peguet Posted December 5, 2023 Share Posted December 5, 2023 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 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