SQL in the record selection formula of the report

[aajay]

Crystal Report 9.0
Data base SQL server
I have a report that runs from a view. I would like to filter records
in the report based on a SQL subquery that operates on the view. Is
there a way to accomplish this in crystal? This is very similar to
having a SQL in the record selection formula of the report although
I am quite sure you cannot pass a SQL in the record selection formula.

We could possibly change the view to a store procedure and then
incorporate the logic to run the subquery. But, then I would land
me redoing the report since crystal might remove some or all of the
fields from the report when I change the view to the store procedure
and register it with crystal report.

Any ideas how to accomplish this would be of great help.

 

[synapsevampire]

Create another View out of this subquery and use that, or use the Add Command and paste in this SQL as appropriate and join it to the View.

Rather than posting text, try posting technical information so that we understand what you have and what you need.

-k