Replace table with command in Crystal Reports XI

Question

Hi,

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

Answer 1

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.