Using a Character Paramerter in Crystal 9

[michG]

I am using PeopleSoft 8.9 with Crystal 9. I have a prompt in my query on EMPLID (Char 11). The prompt is working correctly. However, when I use this prompt {?Employee Id (Ctrl + F4)} in a formula or insert it on the report I am getting no data. Any ideas?

 

[Turkbear]

Hi,
I do not understand : {?Employee Id (Ctrl + F4)}

How are you using this and why Ctrl + F4 ?

In your record selection formula it should be;

{Table.EMPLID} = {?EmployeeID}





To Paraphrase:"The Help you get is proportional to the Help you give.."

 

[michG]

Turkbear, thank you for your response.

Employee Id (Ctrl + F4) is just the prompt text the user sees when they run the Crystal report. The prompt text is used as the field name. If the user keys Ctrl + F4 they get a search table where they can enter a name to get the Employee Id. The prompt must be in the PeopleSoft query to get the search functionality.

The problem is when I insert the prompted field on a Crystal Report or use it in a formula I am getting blank not the Employee Id I entered in response to the prompt. The prompt is working correctly because I am seeing the correct data for the employee.

My Crystal Report has subreports with their own Employee Id prompts. I am trying to ensure that the user has entered the same Employee Id in response to the prompts.