Hi,

I had problem in reading the string parameter in the Add Command at Crystal Report XI. I tried receiving records from Pervasive database in a table and need to read the parameter to filter out out unwanted records. When I tried to print out this report to the screen, a blank record is displayed.
The datatype of the field is SmallInt and the parameter is String so will there be any problem. My code is as follow

select * from POAAPC WHERE
VENDOR = 'C017R' AND 'FISCPERIOD' >= '{?FROMPERIOD}'

Hope to receive your reply soon

Thanks!
Regards