CrystalProgDev
Programmer
I need to generate Dynamic SQL Based on Parameter selection. Here is the scenario.
Parameters: Department ---- Values: A-Department, B-Department, C-Department
If user selects A-Department the SQL Should use Dept_A, Product_A and Sales_A Tables
If user selects B-Department the SQL Should use Dept_B, Product_B and Sales_B Tables
If user selects C-Department the SQL Should use Dept_C, Product_C and Sales_C Tables
We can do it by creating a stored procedure and call that stored procedure from Crystal. But Team is not agree with my advice. Is there any other way we can implement this in Crystal report? Please suggest. It is urgent.
Thank you in advance
Parameters: Department ---- Values: A-Department, B-Department, C-Department
If user selects A-Department the SQL Should use Dept_A, Product_A and Sales_A Tables
If user selects B-Department the SQL Should use Dept_B, Product_B and Sales_B Tables
If user selects C-Department the SQL Should use Dept_C, Product_C and Sales_C Tables
We can do it by creating a stored procedure and call that stored procedure from Crystal. But Team is not agree with my advice. Is there any other way we can implement this in Crystal report? Please suggest. It is urgent.
Thank you in advance