hi I have a crystal report ver8

[2969]

hi

I have a crystal report ver8 which is connected to an vfp database thru OBDC connection. Now I have a sql query which shows all the fields selected and tables joined. I want to prompt the user to pass a paramter and so that the reports displays only the records for that parameter value.

I have made a paramter field also and dropped it on the report.

Everytime i pass a paramter, it reurns all the records instead of onyl the records which match the parameter..

my sql is like this
select a.rec1, a.rec2, b.rec1, b.rec2 from a, b where a.rec1 = b.rec2.

Can anybody suggest anything i am missng???

 

[synapsevampire]

Add the formula for the parameter to filter into the record selection criteria. You don't need to drop the parameter into the report.

The record selection is found using the Pull Down menu:

Report->Edit Record Selection

It should look something like this when complete:

{SOMEDATABASE.THEFIELD} = {?MYPARAMETER}

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com