Solved

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

Posted on 2009-07-03
5
381 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

It seems a simple enough task, yet I see repeated questions asking how to do it: how to pass data between two forms. In this article, I will show you the different mechanisms available for you to do just that. This article is directed towards the .N…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

911 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

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now