Hi
I am using the data report designer.I want that when the user clicks on a command button called "Generate report",to be prompted by an inputbox asking him to enter the CustomerID,if he enters a non null string and press on ok,to generate a report based on the customerID entered by the user.

the syntax of the SQL command:
Select * from Customer where customerID='the value entered in the inputbox'
the report must be generated based on the above SQL statement

how can i do it?