SQL Command and Parameter

[iamdavidlee]

Hi

I am new to Crystal Reports

I am using Crystal reports 9. When i use the standard report creation wizard. I can create the database connection and when i try to enter the following SQL command it gives me an error.

select * from table1 where name={param}

I have created a parameter called param i the parameter list using the same add command window. I am not sure how to use the parameter in the SQL command.


Thanks for the help...
David

 

[synapsevampire]

I would think that you want the record selection formula.

-k

 

[iamdavidlee]

how would i go about creating a record formula...

thanks

 

[synapsevampire]

I think that it's still under Report-?Edit Selection Formula in CR 9.

Try hitting F1...

-k

 

[iamdavidlee]

got it working thanks