select (distributor_code+ '-' +master_dealer_code+ '-' +state_code+ '-' +dealer_code)as agent_code , agent_type, company,contact_person, status, created_date as date, (CASE WHEN contact_mobile_no IS NOT NULL THEN contact_mobile_no WHEN contact_mobile_no IS NULL and contact_office_no IS NOT NULL THEN contact_office_no ELSE NULL END )as contact_no

from sdms_agent

where agent_type ='{?AgentType}' and status ='{?Status}'

order by (distributor_code+ '-' +master_dealer_code+ '-' +state_code+ '-' +dealer_code)

Actually i want to set two parameter in crystal report. where agent_type (Main,DIstributor,Master Dealer,Dealer) & status(active,unsigned,terminate,suspend).

I actually get the parameter. But when i choose the agent_type or status, i only can one by one choose and view on the report. example: agent_type i choose on Distributor, status choose Active. it sure will comes out the report of it.

But let say, i now want to view the Distributor with all the status. But it's not work. even i had try to put '%e%'. It really can't comes out with the result.

mean i want a list which contain of distributor with different status.
or in another way different agent_type with one status. or view all report.