help needed with command parameter

[ub1234567]

Hi,

i am passing three parameter in my sql command.

when i put sample database parameter value in command then it works fine.
but when i replicaing that value with ?parameter and passing parameter externally then it does not give me any results.

pls geive me suggestion

thanks.

 

[hilfy]

Did you manually create the parameters in the report (not the command) or did the command create them for you? I've found that you need to create the parameters in the command dialog and let that create them in the report in order for the parameters to link up to the command correctly.

_Dell

A computer only does what you actually told it to do - not what you thought you told it to do.