Print Page | Close Window

Multiple Details without Subreport Printed From: Crystal Reports Book Category: Crystal Reports for Visual Studio 2005 and Newer Forum Name: Report Design Forum Discription: The best way to design a report and problems you have encountered URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=22248 Printed Date: 26 Apr 2024 at 6:44am Topic: Multiple Details without Subreport Posted By: karthikkjm Subject: Multiple Details without Subreport Date Posted: 22 Feb 2017 at 3:46am I have 1 main table with 3 sub tables. i can design the report with 2 sub reports. But i want to do it without sub reports. all tables are needed to be combined and a single view is enough OR 4 tables in the main report is enough. give me your suggestions. ------------- karthik Replies: Posted By: kevlray Date Posted: 22 Feb 2017 at 4:39am Do you know how to write a command (SQL code)?  You might be able to do that way. You have not provided enough details on the tables and how they are linked (if at all). Posted By: karthikkjm Date Posted: 22 Feb 2017 at 8:59pm all tables are linked using primary/foreign keys. Exambles of tables: Table 1:Voucher_Header (single row of data) (Vch_id (PK)) Table 2:Voucher_Accounts (multiple row of data) (Vch_id (FK)) Table 3:Voucher_checkdetails (multiple row of data) (Vch_id (FK)) how to show the table_3 is details without sub report ? thanks in advance. ------------- karthik Posted By: hilfy Date Posted: 01 Mar 2017 at 9:17am Do the check details also match to accounts? If so, you'll need to add that join. If not, you'll have to use a subreport or a command. -Dell ------------- Proviti, Data & Analytics Practice http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Print Page | Close Window