I am using asp.net and have a Crystal report which queries my Order table. In this table the PK is the int ID. I would like to pass the report a list of IDs to restrict the results to only orders whose IDs are in this list. How can I do this? I am new to Crystal I am uncertain even how to add paramters to the reports.
I also need to pass a second parameter of Status which can be either "O" for open or "C" for closed. How can I have the report filtered by two parameters?