reset parameter values 1

[DougStiers]

I am opening a report in the report viewer, using a simple VB app, but no matter what I enter in the parameters window the same values appear in my WHERE clause when I look at the SQLQueryString property of the report object. They were the same values as the last time I ran the report out of CRYSTAL.

Any help would be appreciated. Doug

 

[paulmarr]

Doug,

In order to change the SQL with a parameter you must use the parameter in the record selection:

{customer.country} = {?country}

{?country} is the parameter you choose. Remember to set the parameter to the same data type as the field you are using to filter - then when in the record selection wizard - choose "is equal to" and the second drop down box will show your parameter {?country}

hope this helps

paulmarr@arcom.com.au