Print Page | Close Window

Binding an SQL "where" clause to a field in the re Printed From: Crystal Reports Book Category: Crystal Reports 9 through 2020 Forum Name: Data Connectivity Forum Discription: How to connect to data sources and export reports URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15414 Printed Date: 19 May 2024 at 6:08am Topic: Binding an SQL "where" clause to a field in the re Posted By: You22ef Subject: Binding an SQL "where" clause to a field in the re Date 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 - Replies: Posted By: You22ef Date 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 -

Print Page | Close Window