Data Connectivity: Two Queries in One Report

Print Page | Close Window

Two Queries in One Report

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=904
Printed Date: 03 May 2024 at 6:11am

Topic: Two Queries in One Report

Posted By: gracia
Subject: Two Queries in One Report
Date Posted: 22 Jun 2007 at 2:37am

Hi!

I have two queries/records in one report, the first query displays current data and the second query displays prior data, both records contains the same fields, for the query link I did an outer left join, however when I tried

previewing the report I'm getting a "not supported " message and "Unknown Query engine error" , I would appreciate any ideas, suggestions with regards to this issue.

Thanks!

-------------
Grace Pujalte

Replies:

Posted By: BrianBischof
Date Posted: 22 Jun 2007 at 10:28am

I have no idea what the error is. Have you looked at Show SQL Query to see what CR is passing to the database? Also, if I was doing this report, I would probably create a SQL Command object and use the UNION keyword to combine the data. This makes both tables appear as one single table with sequential data. You might want to try this as well.

-------------
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>

Posted By: jkwrpc
Date Posted: 22 Jun 2007 at 11:00am

Just another thought which I suppose have already done is to lake a look at the query link. I am not clear where you are linking the fields, but it sounds like it is in the designer. If you are using the designer and linking two different queries(command objects ) you should look at the fields you are linking. It still needs to be a relational join or will give you errors.

Hope this helps.

Regards,

John W.

http://www.CustomReportWriters.net - www.CustomReportWriters.net

Posted By: gracia
Date Posted: 23 Jun 2007 at 12:01am

Hi!

Yup! I'm linking the fields at the designer, Actually both records has the same fields the only difference is that Record1 has prior data and Record2 has current data.