Print Page | Close Window

Sql Expression Field

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=1362
Printed Date: 05 Apr 2025 at 8:00pm


Topic: Sql Expression Field
Posted By: Vishyonline
Subject: Sql Expression Field
Date Posted: 22 Sep 2007 at 6:00am
Hi all,

I tried to create a new sql expression which i need to use in my report. But when i try the following query it gives me error

The query is
(Select  "Employee.EmployeeID" from "[Adventureworks]"."[HumanResources]"."[Employee]")
When i try to save and close it throws an error saying
Invalid Object Name
'[Adventureworks].[HumanResources].[Employee]' Database Vendor Code: 208.

I have tried hard but could not figure it out. Some body please through some light on it and explain me with some sample sql query.

Thanks in Advance,

Vishy


Replies:
Posted By: jkwrpc
Date Posted: 22 Sep 2007 at 3:58pm
It appears to not be finding your table If you know you are connecting to the AdventureWorks database
try this statement
 
"Select EmployeeID from Employee"
 
Hope it helps.
 
Regards,
 
John W.
http://www.CustomReportWriters.net - www.CustomReportWriters.net
 
 
 
 
 


Print Page | Close Window