Skip to Content
0
Former Member
Jan 20, 2012 at 11:44 AM

Binding an SQL "where" clause to a field in the report.

27 Views

Hello everybody,

I have made a crystal report that works fine. Now, I need to add a specific query to the report and drag and drop the returned fields in the report.

The problem is that I need to add a query that contains a "Where" clause that is binded to a field already existing in the report, for example :

SELECT T0.Field1,

T0.Field2,

T0.Field3

FROM Table1 T0

WHERE T0.Field4=(a field from a report)

Is it possible to do it ? if yes, how can I do it.

Thank you in advance for your further responds,

Best Regards,

- Youssef -