Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing Pick List File for Parameter Field

Status
Not open for further replies.

dbew

MIS
Sep 18, 2002
49
US
Hi everyone,

I have a question in regards to Crystal Reports (Version 8.5) and its ability to import a Pick List File when creating parameter fields.

In Notepad, I create a file that contains numbers that represent the states and then the state name. For example:

01 Alabama
02 Alaska
03 Arizona
04 Arkansas

When I choose to create a parameter field in the “Create Parameter Field” window, I need to choose “Number” as my Value type. I proceed to enter the Parameter field name and prompting text, and I set the default values by importing the pick list file. I finally add the parameter field to the selection formula.

Now when I decide to refresh the report using the newly created parameter, the pick list values appear but like so:

1.00 - Alabama
2.00 - Alaska
3.00 - Arizona
4.00 - Arkansas


Does anyone know of a way to change the 1.00 to 01, the 2.00 to 02, and so on. Changing the value type to “String” does not work as I get an error message indicating “A number range is required here” (which makes sense, right?)

Please help!

Thanks,
dbew



 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top