Active TopicsMemberlistSearchHelpRegisterLogin

Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Two Queries from different tables not linked Post Reply Post New Topic
Author Message
Madhura_J
Newbie
Newbie


Joined: 01 Mar 2011
Online Status: Offline
Posts: 4
Quote Madhura_J Replybullet Topic: Two Queries from different tables not linked
    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??
IP IP Logged
Hviezdoslav
Newbie
Newbie


Joined: 19 Jul 2010
Location: United States
Online Status: Offline
Posts: 9
Quote Hviezdoslav Replybullet 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
IP IP Logged
Madhura_J
Newbie
Newbie


Joined: 01 Mar 2011
Online Status: Offline
Posts: 4
Quote Madhura_J Replybullet 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
IP IP Logged
Hviezdoslav
Newbie
Newbie


Joined: 19 Jul 2010
Location: United States
Online Status: Offline
Posts: 9
Quote Hviezdoslav Replybullet 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. 

 
 
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.016 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2024 Brian Bischof. All Rights Reserved.