We help IT Professionals succeed at work.

Check out our new AWS podcast with Certified Expert, Phil Phillips! Listen to "How to Execute a Seamless AWS Migration" on EE or on your favorite podcast platform. Listen Now

x

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

Medium Priority
444 Views
Last Modified: 2013-11-26
    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
Comment
Watch Question

Senior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013
Commented:
Unlock this solution with a free trial preview.
(No credit card required)
Get Preview

Author

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

Author

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
Mike McCrackenSenior Consultant
CERTIFIED EXPERT
Most Valuable Expert 2011
Top Expert 2013

Commented:
I am not sure exactly what it means in Crystal.

You might ask that in the SQL forum.

mlmcc

Author

Commented:
Thank you for all your help!
Unlock the solution to this question.
Thanks for using Experts Exchange.

Please provide your email to receive a free trial preview!

*This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

OR

Please enter a first name

Please enter a last name

8+ characters (letters, numbers, and a symbol)

By clicking, you agree to the Terms of Use and Privacy Policy.