Removing the Comma from a Parameter Drop down list 1

[acenterprises]

Hi Guys,

I'm using crystal 2008 off sql server 2008.
The report is working perfectly, but the end user doesn't like the fact that when he is prompted to select a year, it displays as 2,013 instead of 2013.

I've tried editing the parameter properties from number to text, but I have many formulas that cause the report not to run.
ex:
if {?Year} = {Command.FISCAL_YEAR} and {Command.ACCOUNT} = 4000 then {FBDETAIL.DB_UNITS_09}+{FBDETAIL.CR_UNITS_09} else
IF {?Year} = {Command.FISCAL_YEAR} THEN {FBDETAIL.DB_AMOUNT_09}+{FBDETAIL.CR_AMOUNT_09}

Do you guys have any suggestions on how I can get the year parameter listing to display without the comma?

 

[AndyMc]

One way to handle this is edit the Parameter and in Parameter Default Values, Use 'Set Description' to enter 2013, and then change "Display:' right below that to "Description". This changes what the User see's.

 

[pmax9999]

Change the Parameter type from number to text and run the report. The report will display every formula where the Parameter type causes a problem - simply replace {?Year} everywhere it appears with Val({?Year}).

Hope this helps.

Cheers
Pete

 

[acenterprises]

pmax9999, that did it perfectly. Thanks for all the help!