Format of parameter used in formula

[KimMc]

I am having a problem with a parameter field. I need the parameter ?Period to allow both range of values. The parameter is defined as a string. However when I try to use it in a formula, I get errors both using it as a string or a number. Converting it to the other as below doesn't work, if I convert to a number it asks for a string and vice versa.

{Bal_Data.Period}= ToNumber({?Period})

Any help?

 

[dgillz]

What do you mean by "both range of values"? Is this a range parameter or not?

You should not have to convert either field. Make your parameter a number and your formula should work fine. Have you tried making your parameter a number? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[dgillz]

Also, what version of CR are you using? Is this a straight up Crystal Report or an integrated application? Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com

 

[KimMc]

I am using Crystal Reports v8, and it's a straight report. I have tried formating the parameter as a number, but the error just switches to asking me for a string. This is really odd. Sorry, 'both' should read 'a'.

 

[synapsevampire]

Period should be a date, if you're trying to limit rows by their age, so try that.

The important thing is to KNOW your datatypes.

The icon on the far right of the field explorer will show data types, this should help in this effort.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[dgillz]

I am unsure what you mean by "formatting" your parameter as a number. Two questions:

1) When you edit the parameter field, what is the data type?

2) When you look at {Bal_data.Period} in the field explorer, what is the data type?

Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com