CrystalProgDev
Programmer
I need to generate Dynamic SQL for cascading Parameters. Here is the scenario.
Parameters:
Department ---- Values: A-Department, B-Department
Category ---- A1, A2, A3, B1, B2
Product --- A1P1, A1P2, A2P1, B1P1, B2P1, B2P2, B2P3
If user selects A-Department the SQL Should use Dept_A table
and the category should be A1,A2,A3 (Data should come from Cat_A table) And if user selects Category A1,A2 the product should be A1P1, A1P2, A2P1 (Data hould come from Product table where dept=A and Catcode in (A1,A2))
Is there any way we can implement this in Crystal report? Please suggest. It is urgent.
Thank you in advance
Parameters:
Department ---- Values: A-Department, B-Department
Category ---- A1, A2, A3, B1, B2
Product --- A1P1, A1P2, A2P1, B1P1, B2P1, B2P2, B2P3
If user selects A-Department the SQL Should use Dept_A table
and the category should be A1,A2,A3 (Data should come from Cat_A table) And if user selects Category A1,A2 the product should be A1P1, A1P2, A2P1 (Data hould come from Product table where dept=A and Catcode in (A1,A2))
Is there any way we can implement this in Crystal report? Please suggest. It is urgent.
Thank you in advance