[RESOLVED] [2005] Changing format of a Parameter Field in Crystal Report

Hi

I have logged this on the Crystal Forum but I'm not getting any answers there so thought I'd try this one!

I'm trying to set up a report (through Visual Studio 2005) that has a parameter field that is a year e.g. 2004, with hardcoded values. I've tried setting it up as a Number so that I can manipulate it as a number in the Record Selection Formula e.g. 2004 + 1. The problem I'm having is that the Parameter Field Editor converts 2004 to 2,004.00!

Is there any way of forcing the format to be 2004?

Thanks.

Why not pass in the date parameter when generating the report instead of hardcoding it.

Otherwise, if you ar using a number you can set a custom format to remove the comma and decimal places like so...
http://ffxilinkshell.com/images/screen.jpg

Set the decimals to 1
the rounding to 1 and uncheck the thousands seperator and you number should be 2004

Thanks, that's working great now!