on 08-25-2008 7:45 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.