Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Multiple Details without Subreport Post Reply Post New Topic
Author Message
karthikkjm
Newbie
Newbie
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 21
Quote karthikkjm Replybullet Topic: Multiple Details without Subreport
    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
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
Quote kevlray Replybullet 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).
IP IP Logged
karthikkjm
Newbie
Newbie
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 21
Quote karthikkjm Replybullet 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
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet 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
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.047 seconds.