Data Connectivity
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Data Connectivity
Message Icon Topic: Binding an SQL "where" clause to a field in the re Post Reply Post New Topic
Author Message
You22ef
Newbie
Newbie


Joined: 20 Jan 2012
Online Status: Offline
Posts: 2
Quote You22ef Replybullet Topic: Binding an SQL "where" clause to a field in the re
    Posted: 20 Jan 2012 at 2:19am
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 -
IP IP Logged
You22ef
Newbie
Newbie


Joined: 20 Jan 2012
Online Status: Offline
Posts: 2
Quote You22ef Replybullet Posted: 20 Jan 2012 at 5:28am
Hello Again,
I've solved the issue.
If it will help someone, I've made a sub report linked to the field in the report.

Thank you,
 
Best Regards,
- Youssef -
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.