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

[obscuregirl]

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.

[bmahler]

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...


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

[obscuregirl]

Thanks, that's working great now!