Print Page | Close Window

Multiple levels of queries in one report

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=201
Printed Date: 28 Apr 2024 at 8:46pm


Topic: Multiple levels of queries in one report
Posted By: crystaluser
Subject: Multiple levels of queries in one report
Date 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


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


Print Page | Close Window