Problem setting Default Range Parameters

[Former Member]

I am very new to Crystal Reports XI and I can't seem to figure out how to set a default range parameter.

I have a DB with Vehicles in it and the report requires a range of departments and a separate one for class codes.

The problem is that i can't seem to figure out how to set the range parameters as just a number or string. the only examples i have seen in my searchings is for the date time format.

does anyone have any insight as to how I could format this report to set the parameters to a fixed range of data as a default parameter?

- Drew Foulks

Computer Technician

City of Newport News

Edited by: Drew Foulks on Aug 25, 2008 8:55 PM

[Former Member]

Hi Drew,

After creating the parameter in the same window you will get "Value options" at the lower part. In this section, you can set true for "Allow range values". By doing this the parameter will accept a range of values.

Please let us know if this helps.

Regards,

Abhishek.

[Former Member]

Hello Abhishek,

That certainly did help, the problem is that I need to modify this report to not prompt for this value at all, I need to set the default parameter where the user does not have to input anything at all. the people using this report are even unaware of what these values mean, so this parameter would just confuse them.

if you could help that would be fantastic

-Drew

[Former Member]

Hello Abhishek,

That certainly did help, the problem is that I need to modify this report to not prompt for this value at all, I need to set the default parameter where the user does not have to input anything at all. the people using this report are even unaware of what these values mean, so this parameter would just confuse them.

if you could help that would be fantastic

-Drew

[former_member230846]

Hi Drew,

It doesn't sound like you need to use parameters for this purpose. It sounds like you need to create a selection formula in Crystal Reports instead. In Crystal Reports, under Report|Selection Formula|Record...

You can hardcode the range of values or array of values. For example, an array:

{database.field} in [value1,value2,value3]

For example, hardcoded range for numbers:

{number.field} in 1 to 10

For a hardcoded string range:

{string.field} in "123 store" to "xyz store"

Regards,

Wallie

corrected {string.value} to {string.field} for clarity.

Edited by: Wallie Cheng on Aug 26, 2008 6:37 PM

[Former Member]

Wallie,

I very much so appreciate your help, the report works wonderfully.

thank you very much,

Drew Foulks