multiple field values with special characters

[ssriramin19]

Hello All,

There is a field (product_name) with the values ((FP@HUBMCDC,FP@MCDC,FP@PS&MCDC,FPIRP@MCDC,FP@XD&MCDC)

My requirement is that on open the above field values has to be chosen

With the special character appearing in the field values the default values are not being chosen on opening the report.

Can anyone please let me know how to approach the above issue.

Thanks

Sriram

[its_anandrjs]

Suppose if you introduce this FieldFlag in your data model fir the field product_name and your product_name field has many values on that field but you need to select only this five values then you can use this Flag_Field for selections.

[ssriramin19]

Do I need to select the field flag to 1 ? Do I need to manually select the field flag and select it to 1?

Can you clarify on that

[ssriramin19]

can you please clarify on this

[effinty2112]

Maybe:

("FP@HUBMCDC"|"FP@MCDC"|"FP@PS&MCDC"|"FPIRP@MCDC"|"FP@XD&MCDC")

good luck

Andrew