direct query sql error

[sallywt]

I am trying to use direct query to bring back the fgures I need from an SQL database and I'm getting an error even though I know the SQL works in SQL management studio.  The SQL statement is:

SELECT COUNT(distinct oh.OrderHeaderId) AS Orders,
count(distinct ol.orderlineid) as orderlinecount,
cast(DatePlaced as date)
FROM OrderLines as ol WITH (NOLOCK),
OrderHeaders as oh WITH (NOLOCK)
WHERE oh.OrderHeaderId = ol.OrderHeaderId
and dateplaced >= DATEADD(day,-7,getdate())
AND OrderStatus = '0'
GROUP BY cast(DatePlaced as date)
order by cast(DatePlaced as date)

The error I'm seeing is

 This query contains transformations that can't be used for a live connection

Can anyone advise on how I can get this without downloading the data as this takes and age.

[sallywt · Accepted solution]

I've found the solution, the CAST(DatePlaced) did not have a column name and so it was erroring.  I've given the column a name and now it works.