Is it possible to format values in a dynamic report prompt to remove the thousands separator and decimal point in Crystal Reports XI? For example, the number 5682 is showing as 5,682.00 in the prompt.
Crystal Reports XI does not allow you to format the prompt itself. However, it is possible to format the appearance of the value of the number once it is selected from the list of value.
To do so perform the following steps:
- Right-click on the parameter.
- Click Format Field.
- Click the Number tab.
- Select the desired formatting.
Dynamic, Prompts, Dynamic Prompts, List of Values, Format, Numbers, Decimal, Comma, Appearance , 2866298 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem
SAP Crystal Reports XI ; SAP Crystal Reports XI R2