Pick Lists 1

[JohnEck]

I am having problems setting up a pick list for my reports. When I set them up in CR they work fine. When I try to set them up in SI they do not display the description. This is actually quite important because the valu is kind of meaningless.

 

[rhinok]

This Crystal Decisions support document is extremely helpful:

http://support.crystaldecisions.com/kbase/c2004868.asp

The key is that your picklist cannot be embedded in the report. It must be referenced externally. I personally use this method to generate a list of Quarterly End Dates from a reporting_date table. The value, which I hide, is in the Crystal Syntax (Date(YYYY,MM,DD)), however, the description the user sees and selects is 'June 2001'.

By the way, you can successfully create a report that will generate the correct output in text format for the picklist. This way, you can schedule your pick lists to be updated on a recurring basis.

 

[JohnEck]

Thanks but I found the problem in SI 7.5 was that I the parameter was an integer so for some reason it wouldn't load the description. When I changed the parameter to a char and then converted it to int in the stored Proc it worked fine.