Print Page | Close Window

Two Queries from different tables not linked

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=12467
Printed Date: 06 May 2024 at 2:24am


Topic: Two Queries from different tables not linked
Posted By: Madhura_J
Subject: Two Queries from different tables not linked
Date Posted: 01 Mar 2011 at 7:18pm
Hi,
 
I want to use two queries from different tables that are not linked with each other in the same report
 
Eg.
1.
Date-(This value should come from table X
like, select date from X where application='y'
)
2.
then the main report will have feilds from another table
like select applicationtype,applicationdate where <some condition>.
 
How do i do this in crystal report 2008?
i have completed point 2 but what should i do to display point 1 as a separate feild in the report header??


Replies:
Posted By: Hviezdoslav
Date Posted: 02 Mar 2011 at 6:23am
Greetings Madhura_J,
 
I am not the most experienced person in Crystal Reports but I will try to help.  I have used only Crystal Reports Version 10 and Crystal Reports Version 11.
 
You could try to put into the report header a sub report.  You can link that sub report to whatever table you want and do with the sub report what you want independently of what you are doing in the main report.
 
You can create the sub report separately and then use the main report's wizard to insert the sub report to the report header of the main report.
 
I hope this information is useful to you.  If it is not useful, I apologize.  I have received help on this forum and wanted to try to help others.  I do not often get a chance to get into the forum to be honest.
 
Hviezdoslav

Posted By: Madhura_J
Date Posted: 02 Mar 2011 at 10:34pm
Hi,
 
Your info was really useful,considering my 5 days experiance in crystal reports.
Thank you so much 4 spending your time to reply me.
 
Thanks and Regards,
Madhura

Posted By: Hviezdoslav
Date Posted: 03 Mar 2011 at 3:21am

It was my pleasure, Madhura!  Let me know if you encounter any problems.  It is great that the code of this site sends an email to notify me that someone posted or replied in this site in connection to something that I posted or something to which I replied.  I have a great respect for this site and the folks in it who are very helpful and generous with their knowledge. 

 
 


Print Page | Close Window