How do I select all the secondary values from a Cascading Prompt in Crystal

    I've created a loop in Visual Studio for 25 managers. With in the loop, I want to call Crystal and send Crystal Reports the manager name and have the "record selection" for the report be based on the manager's employees. I set everything up in tables and linked those tables into Crystal Reports. I created a Dynamic Cascading Prompt which allows me to select the manager for the first level and then displays all the corresponding employees. I don't believe there is a way to select "ALL" for the secondary cascading prompt. I hope I'm wrong.
   If I'm wrong, how could I code visual studio to send the appropriate "record selection" to Crystal?

Thank you
Audre7
audreymjhhaAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mlmccCommented:
There is no default way to select all employees.

Do you always want to select all employees?  If so thenjust use the manager as the parameter.

There is a way to add ALL to your list but I forget what it is.

mlmcc
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
audreymjhhaAuthor Commented:
mimcc,
    Thank you for responding. The managers are not actually linked to the employees in the payroll system because there are layers of management in between. I created separate tables which link the managers to the corresponding departments. I tried creating a dynamic cascading pick list. The first one allows me to select the manager (off of my table) and second one selects the list of departments based on the manager. This also works except I would like to be able to put an all in the second list. I found an "ALL" selection example in a book but I don't entire understand it. It says I can use command objects with DCPs to create a list of values. I've tried creating one that looks like
select DepartmentNumber from HomePayroll.dbo.DepartmentInformation

??I've tried putting where Departmenthead = {?aparameter}
and I've tried using the DCP parameter but I received an error message.
Does any of this help you to remember?

How can I code the second prompt in the DCP to point to a select statement which could retrieve all the department numbers corresponding to the department manager name?

Thank you
I hope I wasnt confusing.
Audrey
0
audreymjhhaAuthor Commented:
I created a table with the department managers and the department numbers. I linked the payroll table department number to the department number within crystal reports. The arrow is pointing to my table. When I look at the link options, it says inner join - unenforced. I created a parameter for manager and I set my tables department manager equal to the parameter. It worked but I don't know the reason. What does the not enforced mean?
Thank you
Audrey
0
mlmccCommented:
I am not sure exactly what it means in Crystal.

You might ask that in the SQL forum.

mlmcc
0
audreymjhhaAuthor Commented:
Thank you for all your help!
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
.NET Programming

From novice to tech pro — start learning today.