Solved

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

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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Recently while returning home from work my wife (another .NET developer) was murmuring something. On further poking she said that she has been assigned a task where she has to serialize and deserialize objects and she is afraid of serialization. Wha…
For those of you who don't follow the news, or just happen to live under rocks, Microsoft Research released a beta SDK (http://www.microsoft.com/en-us/download/details.aspx?id=27876) for the Xbox 360 Kinect. If you don't know what a Kinect is (http:…
In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're interested in additional methods for monitoring bandwidt…
This video shows how to remove a single email address from the Outlook 2010 Auto Suggestion memory. NOTE: For Outlook 2016 and 2013 perform the exact same steps. Open a new email: Click the New email button in Outlook. Start typing the address: …

760 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

18 Experts available now in Live!

Get 1:1 Help Now