SQL within crystal

I am pulling directly from an ODBC connection and have seeveral issues that I am trying to resolve with this.

1) I have created an sql statement with the query designer that works fine. However to refresh the data in the report, you have to open the query, refresh that and then open the report and repost data? Can't this be refreshed directly from within the report? There are going to be about ten subreports in this project and updating it query by query seems to be pretty inefficient.

2) I have tried working without this query and putting it straight into a new report by selecting the appropiate fields. What I needed to do though was a count function within the SQL statement. But it does not appear to work in the manner I want. It is counting in a summary manner, which was not my goal. I want the count function to be implemented in the detail line. Does crystal not have this direct capability?