Hi all,

I need to know how can I put a simple subquery in a report?

For instance a query like:

Select T1.a
, T1.b
, (Select sum(x)
from T2
where T2.c = T1.c) AS ValueToInsertInReport
From T1
Where ...

When I put this kind of query in the 'SqlQuery' of the Crystal, he 'still' the subquery.

Is this possible?
If not what are my possibilities?

Thank you for your suport.

Regards

CF.