Replace table with command in Crystal Reports XI

I'm trying the replace a table with a command.

Replacing one table with another is usually no problem. Trying to do the same thing with a "command". It seems to work at first, an edit command window opens.开发者_开发问答 I type in the command (I used "select * from myTable" as a test case), click ok and absolutely nothing happens.

Background is that the one table now contains multiple rows per serial num (which it didn't when the report was first created), and I need to aggregate that data. So, instead of creating groups in CR and changing every field in the whole report, I want aggregate the data in SQL and use the command instead of the table. (Creating a view on the DB is not an option.)

Thanks Martin

What does the SQL syntax look like when you are just using tables? Possibly you could use that as a template for building your own SQL statement.

Try and create a new report with your command instead of replacing the data source on an existing report.

I've had problems with that before.