[RESOLVED] Changing the format of a Parameter Field

[obscuregirl]

Hi

I'm trying to set up a report 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 is at 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.

[Arwen@Aragon]

Hi

I'm trying to set up a report 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 is at 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.U have to change value type of year from Number to String.

[obscuregirl]

I can't do that because if it's a string, it won't let me process it as a number e.g. 2004 + 1 to equal 2005.

anyway, I posted this on the VB.Net Forum too and got an answer. For anyone that's interested, that answer can be seen here:

http://www.vbforums.com/showthread.php?p=2629010#post2629010

Thanks