Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Multiple levels of queries in one report Post Reply Post New Topic
Author Message
crystaluser
Newbie
Newbie
Avatar

Joined: 15 Jan 2007
Location: United States
Online Status: Offline
Posts: 5
Quote crystaluser Replybullet Topic: Multiple levels of queries in one report
     Posted: 06 Feb 2007 at 1:16pm
I have a report that needs two set of queries. The first query returns a date which acts as a parameter to another query. So far, I have been using parent report-subreport structure, wherein the parent has the date query. I catch the date in a formula, which i link to a subreport parameter.
 
Is it possible to achieve this without using subreports?
Crystal User
IP IP Logged
EscApe
Newbie
Newbie


Joined: 13 Nov 2006
Location: Finland
Online Status: Offline
Posts: 37
Quote EscApe Replybullet Posted: 07 May 2007 at 3:50am
Have you tried using cascaded sql in SQL Command, like:

select *
from database db1
where db1.date = select date from anotherdatabase db2 where db2.field = "ThisIsWhatINeed"
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | KONACAD

© 2004-2026 Brian Bischof. All Rights Reserved.