[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 775
  • Last Modified:

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.
0
genesisproject
Asked:
genesisproject
  • 2
  • 2
2 Solutions
 
Brian CroweCommented:
What version of Crystal? What is your datasource?

If I am understanding you correclty just set your datasource and use a string parameter to filter the data in the record selection formula.
0
 
mlmccCommented:
Depending on CR version you have different options.

In general the easy way is

Open Crystal
Select NEW REPORT
Select the DATA SOURCE
Select the TABLE(S)
Select the FIELDS

You can then use the Select Expert to add the filtering

mlmcc
0
 
genesisprojectAuthor Commented:
yes but can you show me what it would look like
0
 
genesisprojectAuthor Commented:
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
0
 
mlmccCommented:
Glad i could help

mlmcc
0

Featured Post

Prep for the ITIL® Foundation Certification Exam

December’s Course of the Month is now available! Enroll to learn ITIL® Foundation best practices for delivering IT services effectively and efficiently.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now