Formula with many type in output
I work with Crystal Report XI.
I need to have one formula with sometime number and sometime characters in output. It's possible ?
2 separates formulas are not good for me.
It's to export report in Excel with good format.
Have you a solution to help me please ?
No. It is not possible to have a formula that can switch data types.
In your case, the solution would be to set it as a string data type because the string data type can display both alpa & numeric character sets.