How to set up real time parameter list in CR 8.5 Prof / VB6

I am new to Crystal Reports 8.5 Professional and VB 6. Is it possible to set up a parameter pick list for a CR report using a SQL query based on another user entered parameter, possibly stored in a report varaible? Or is there another way to accomplish this?

For example, user is prompted for a customer id and then based on that customer id, I need to build a pick list of customer service reps for that customer.

Quote:

---

Originally Posted by Delta

I am new to Crystal Reports 8.5 Professional and VB 6. Is it possible to set up a parameter pick list for a CR report using a SQL query based on another user entered parameter, possibly stored in a report varaible? Or is there another way to accomplish this?

For example, user is prompted for a customer id and then based on that customer id, I need to build a pick list of customer service reps for that customer.

---

Welcome to the forums. :wave:

If you are already gathering a recordset that contains the information you want (using SQL), then just pass that recordset to crystal. You shouldn't need to mess around with CR's parameters to do what you are already doing.

hack, is the CR usually embedded in the Form if in windows application???