Parameter Field value equal to table.field value?
Parameter Field value equal to table.field value?
(OP)
I have create a parameter field in Crystal 8.5 and called it "Customer" and on the Formula field I created a field call "@Custid" and set the value to {sp_billings;1.CustID}. sp_billings is a store procedures. When a user get the Customer prompt how can a user get the customer he specified. Supposed he enter 'ABC' for Customer and I only want him to see the values belong to Customer ABC.below is my code.
select {?Customer}
CASE {?Customer}: ({@Custid}=tek_sp_rpt_billingsALL;1.CustID}{?Customer} and {tek_sp_rpt_billingsALL;1.Vendor} <> '0')
CASE "ALL": ({@Custid} = {tek_sp_rpt_billingsALL;1.CustID} and {tek_sp_rpt_billingsALL;1.Vendor} <> '0')
The CASE "ALL":works but not the CASE {?Customer}:. I appreciate somebody can help me. Thanks
select {?Customer}
CASE {?Customer}: ({@Custid}=tek_sp_rpt_billingsALL;1.CustID}{?Customer} and {tek_sp_rpt_billingsALL;1.Vendor} <> '0')
CASE "ALL": ({@Custid} = {tek_sp_rpt_billingsALL;1.CustID} and {tek_sp_rpt_billingsALL;1.Vendor} <> '0')
The CASE "ALL":works but not the CASE {?Customer}:. I appreciate somebody can help me. Thanks
RE: Parameter Field value equal to table.field value?
select {?Customer}
//CUSTOMER
CASE "ALL": ({@Custid} = {tek_sp_rpt_billingsALL;1.CustID} and {tek_sp_rpt_billingsALL;1.Vendor} <> '0')
CASE {?Customer}: ({@Custid} = {?Customer} and
{tek_sp_rpt_billingsALL;1.Vendor} <> '0')