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.