Crystal Reports based on user input during runtime

[LandDestroyer]

I want to know about this too. Help!

I have a group of zip codes. I want to make a report that lists all the information from the store table for stores that have the zip codes that are checked. When the user checks 71111, 71006, 71497, I want the report to get only those stores/rows from the table and put those in the report. I only know how to make the crystal report wizard display all rows from a table or querie. How can I do this?

 

Thanks,

Chris Gregory

christopherleegregory@hotmail.com

[kcwallace]

Create a dataadapter

 

SQL = "SELECT ZIP FROM TABLE WHERE ZIP=" & ZIPofInterest

da.SelectCommand = New SqlCommand(SQL, cnn)

Dim ds As New DataSet

da.Fill(ds, "CrystalRptSourceTable")