Hi, Can anyone help.
I have a report where the user would like to be prompted for a variety of options, ie Works Order Number, Part Number, Customer Order Number etc. After having spent days trying to get records to show when only one parameter is entered I found an article on Crystal Decisions which explains how to do it 'Create report so that you are not required to enter a value for all parameters'. I have followed their example exactly. I have created a parameter which is WORDNo and have set type as string. I have then created the following formula as per their example
(if {?WORDNo} <>"" then {MBF010.WORDNO}=tonumber({?WORDNo}) or {?WORDNo}=""
The above should work but i keep getting message that 'A String is required' Can anyone advise where i am going wrong. I can't believe such a simple requirement is causing me so many problems.
Thanks
I have a report where the user would like to be prompted for a variety of options, ie Works Order Number, Part Number, Customer Order Number etc. After having spent days trying to get records to show when only one parameter is entered I found an article on Crystal Decisions which explains how to do it 'Create report so that you are not required to enter a value for all parameters'. I have followed their example exactly. I have created a parameter which is WORDNo and have set type as string. I have then created the following formula as per their example
(if {?WORDNo} <>"" then {MBF010.WORDNO}=tonumber({?WORDNo}) or {?WORDNo}=""
The above should work but i keep getting message that 'A String is required' Can anyone advise where i am going wrong. I can't believe such a simple requirement is causing me so many problems.
Thanks