Link to home
Start Free TrialLog in
Avatar of genesisproject
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.
SOLUTION
Avatar of Brian Crowe
Brian Crowe
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of genesisproject
genesisproject

ASKER

yes but can you show me what it would look like
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
Glad i could help

mlmcc