Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Removing the Comma from a Parameter Drop down list 1

Status
Not open for further replies.
Mar 26, 2013
10
US
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?
 
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.

 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top