Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Adding data from a new table without including it Post Reply Post New Topic
Author Message
SIddhu
Newbie
Newbie
Avatar

Joined: 27 Feb 2008
Location: India
Online Status: Offline
Posts: 22
Quote SIddhu Replybullet Topic: Adding data from a new table without including it
    Posted: 27 Feb 2008 at 4:16am

I need to display a single column detail from a seperate table( say Table 2 ) different from the table ( say Table 1 ) am using in the reports.

Without including that Table 2 how do i include the details in the report section which is using Table 1. One way i can think of is using Unlinked Sub Reports, but using sub reports is not efficient. so is there any other possible solution for this issue.  
Thanks,
Siddhu.
IP IP Logged
rahulwalawalkar
Senior Member
Senior Member
Avatar

Joined: 08 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 731
Quote rahulwalawalkar Replybullet Posted: 27 Feb 2008 at 6:08am
Hi,
 
Try creating a view using sql and include the column from Table 2.... with the columns from Table1 and use that view in the report.
 
Cheers
Rahul
 
IP IP Logged
SIddhu
Newbie
Newbie
Avatar

Joined: 27 Feb 2008
Location: India
Online Status: Offline
Posts: 22
Quote SIddhu Replybullet Posted: 27 Feb 2008 at 9:50pm
hi rahul,
 
Thanks for the solution. I have tried that also. But in my project i have been given permission only to creater some temporary tables and with which i cant create any views.
 
so, i don think i can create any views and create that report.
 
Thanks,
Siddhu.
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.017 seconds.