I wonder if this is possible and if yes, can anyone tell me know to do it?
I'm creating report based on Crystal reports.
I'm going to use one stored proc for three different reports, and their primary parameter is going to be different.
order_id for report a,
customer_id for report b
employee_id for report c
while they all have some common fields, rest will be different.
(i'm using if statement to bring out those place holderS)
if order_id = 2
major id = 2 then generation order_number, order_amount, order_tiem
if customer_id is 1
major id = 2 then customer_name, customer_phone, customer_email
if employee_id 1
major id = 2 employee_name, experience... something like this
do you see what i mean?
There are going to be some fields that are common, but not all the fields are going to be the same.
Is this possible?