genesisproject
asked on
select statement crystal reports
can someone show me how to make a select statement in crystal reports and passing one string parameter
I have to make my own select statement.
I have to make my own select statement.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
in my modify command box i have this
Select Work_Order_ID ,Ship_To, Address, City, Province, Postal_Code, Phone_Number, Quantity, Product_name, Subtotal, Total from invoice Inner join invoiceproduct on invoiceproduct.Invoice_ID = invoice.Invoice_ID where Work_Order_ID = 'WO-000014'
WO-000014 is a string
Select Work_Order_ID ,Ship_To, Address, City, Province, Postal_Code, Phone_Number, Quantity, Product_name, Subtotal, Total from invoice Inner join invoiceproduct on invoiceproduct.Invoice_ID = invoice.Invoice_ID where Work_Order_ID = 'WO-000014'
WO-000014 is a string
Glad i could help
mlmcc
mlmcc
ASKER