Print Page | Close Window

Adding data from a new table without including it

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
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=2452
Printed Date: 28 Apr 2024 at 4:43am


Topic: Adding data from a new table without including it
Posted By: SIddhu
Subject: Adding data from a new table without including it
Date 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.


Replies:
Posted By: rahulwalawalkar
Date 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
 

Posted By: SIddhu
Date 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.


Print Page | Close Window