Input values with '_' (underscore) in a parameter of a Quick Report (Crystal)

Hi @CONIRATBE ,

This is record selection formula right? Also are you passing the parameter as a text field? Maybe you could try TOTEXT(value) option. 

Or you will have to break input string to identify special characters. 

Hi @CONIRATBE ,

{JT_TASK_UIV_CFV\.PROJECT_ID}  underscore in this field shouldn't be a problem. Because i have done many reports with such parameter names. 

Try printing both values ({JT_TASK_UIV_CFV\.PROJECT_ID} and {?Proyecto} ) in the report before filtering out and check whether they have similar format.

Because if project id is a number then {JT_TASK_UIV_CFV\.PROJECT_ID}  should print something like 10213.00.  Due to decimals this might not work.

You can avoid it by using ToText( ToNumber({JT_TASK_UIV_CFV\.PROJECT_ID}), "#").

So your condition would look like this

ToText( ToNumber({JT_TASK_UIV_CFV\.PROJECT_ID}), "#") = ToText ({?Proyecto})

This is how I normally troubleshoot this problem.

Hi @CONIRATBE ,

To clear out the confusion,

you are saying {JT_TASK_UIV_CFV\.PROJECT_ID} = 'AUU_2020'  is not working right?

Hi @CONIRATBE ,

Removing the special character from both sides should work. i am not sure why it is not working.

It would be the best option for your scenario.

Try replacing with a space and then trimming both sides. 

 or follow below format

stringvar output := {TABLE_NAME.FIELD_NAME};
output := Trim(output);  //get rid of leading & trailing spaces
output := Replace(output,Chr(13),'');  //get rid of line feed character
output := Replace(output,Chr(10),'');  //get rid of carriage return character

//add any other special characters you want to strip out.

Its good to know this. 

Thanks for the effort. :)