[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.p...10#post2629010

Thanks