To validate your SQL query string and ensure that your report delivers the appropriate results, click Produce Report. This will actually produce the report, so you might want to limit your testing to a small set of data.
You can continue to edit your SQL query string and test the results of your report until you are ready to save it.