Print Page | Close Window

Outer Join Support

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=3454
Printed Date: 29 Apr 2024 at 1:16pm


Topic: Outer Join Support
Posted By: muazzamazaz
Subject: Outer Join Support
Date Posted: 17 Jun 2008 at 4:00am
I am using MS Access database and the following query generate support error in crystal report.

SELECT
Item.`Item_Code`, Item.`Item_Name`, Item.`OP_QTY`, Item.`OP_Rate`,
Stock.`voucher_no`, Stock.`voucher_date`, Stock.`quantity`, Stock.`rate`, Stock.`DC`,
Users.`User_Name`,
Company.`Comp_Name`, Company.`Address`
FROM
((`Stock` Stock RIGHT OUTER JOIN `Item` Item ON Stock.`item_id` = Item.`Item_Code`) INNER JOIN `Company` Company ON Stock.`comp_id` = Company.`Reg_No`) INNER JOIN `Users` Users ON Stock.`user_id` = Users.`User_Id`
ORDER BY
Item.`Item_Code` ASC


-------------
Muhammad Muazzam


Replies:
Posted By: BrianBischof
Date Posted: 17 Jun 2008 at 3:01pm
Have you tried creating the query directly in Access and calling the query from Crystal? Doing that would prevent CR from passing complex SQL to Access and getting it mixed up.

-------------
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: muazzamazaz
Date Posted: 17 Jun 2008 at 8:12pm
this query is the CR query and stock is a query in MS Access.
 


-------------
Muhammad Muazzam


Print Page | Close Window