Malkie
February 21st, 2007, 11:36 AM
I am using a view to get data. I would like to do the filtering on the server side.
The filtering is using some simple functions (with no variables). When I set the filtering in the record selection it is not being set as part of the SQL server.
If I set the record selection to: table.field = "559"
that gets set as part of the sql query and filtering is done on the server. :)
but if I se the record selection to: table.field = {@Id}
the it does not get set as part of the sql query. :(
Is there anything I have to set so that so that the record selection can become part of the query.
Thank you.
I am using Crystal reports 8.5.
The filtering is using some simple functions (with no variables). When I set the filtering in the record selection it is not being set as part of the SQL server.
If I set the record selection to: table.field = "559"
that gets set as part of the sql query and filtering is done on the server. :)
but if I se the record selection to: table.field = {@Id}
the it does not get set as part of the sql query. :(
Is there anything I have to set so that so that the record selection can become part of the query.
Thank you.
I am using Crystal reports 8.5.