Solved

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

Posted on 2009-07-03
5
384 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
0
Comment
Question by:audreymjhha
  • 3
  • 2
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 24774223
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
 

Author Comment

by:audreymjhha
ID: 24793495
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
 

Author Comment

by:audreymjhha
ID: 24796477
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
 
LVL 100

Expert Comment

by:mlmcc
ID: 24798694
I am not sure exactly what it means in Crystal.

You might ask that in the SQL forum.

mlmcc
0
 

Author Closing Comment

by:audreymjhha
ID: 31599634
Thank you for all your help!
0

Featured Post

Master Your Team's Linux and Cloud Stack!

The average business loses $13.5M per year to ineffective training (per 1,000 employees). Keep ahead of the competition and combine in-person quality with online cost and flexibility by training with Linux Academy.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This document covers how to connect to SQL Server and browse its contents.  It is meant for those new to Visual Studio and/or working with Microsoft SQL Server.  It is not a guide to building SQL Server database connections in your code.  This is mo…
Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question