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