Sage 100

Here's a easy question for you CR 2011 gurus. I have a SAGE 100 v2017 Crystal Report in Payroll where I only want Employee Status = A(ctive) record to print on the report. I got that working. But in my report I want the end user to select a range of employees to include on the report = I set up a dynamic parameter field. I got that working also. QUESTION: How do I set up the Record Selection prompt to only show Active Employee IDs to choose from?

In Report > Selection Formulas > Record add the formula for only the status ""A"" and only those record will be brought into the report data set.

@MichelleTaylor Thank you for your response. However I have that part working. Below is an image of what I'm trying to select. Basically the Employee ID is their three initials. So on the image below the employees with a yellow arrow are Active employee and the rest are Inactive. How do I get only the Active employee to show up on this pull down list?

Dynamic parameters were in a later version of CR.

@MichaelMcDonald Yes, as Rhonda stated with a Dynamic Parameter

That is what I did - see image below. How do I tell it to only display Active Employee IDs

A cascading parameter is one way. You know, like you'd do if you were prompting for a country then the city, but only selecting from cities in that country. Let me think.

OK, this is completely inelegant and I'm sure someone else can Ido-Millet a better solution in two clicks. But here's one idea. You can add a command object that filters the employee list to actives and then let your parameter use that pre-filtered list. My example is with an item. I just want the user to pick items in the DC product line. It's my first time using a command (must keep straight face)...ok, using a Crystal Command. So for all I know it may take it six hours to run. But it worked for me. The third image shows where Add Command lives, for any other noobs like me.

Returning to my CR report @RhondaMcNamara...I was able to make some progress. I created the Crystal Command following your example and almost got it to work. If I create the command, but don't include the filter, the lookup parameter works. But if I include the filter to select only EmployeeStatus_AIT = ""A"", I receive an error message. Can someone review my syntax? TIA

Try it as: _**= 'A'**_ (single quotes) instead of **_= ""A""_** (double quotes)

@RhondaMcNamara nice find with the Command!!! I didn't know that one.