How do I select all the secondary values from a Cascading Prompt in Crystal
Posted on 2009-07-03
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?