Changing datasource from OLE to Command Object not changing

[crogers111]

CR XI (11.0.0.2495)
SQL OLE

I have a report that I'd like to change to use a command.

I've changed datasources plenty of times but not to a command and am hoping I'm just missing something. I'm basically following the steps from this thread:

http://www.tek-tips.com/viewthread.cfm?qid=1423879

1. I select: Database..Set Datasource Location
2. I highlight the main table in the upper window
3. I highlight 'Add Command' in the lower window
4. I click 'Update' which opens the 'Add Command to Report' Window
5. I paste the copied SQL into the window and click 'OK'

Nothing happens. The mapping window does not appear and it's like I'm back at Step 3. with both items only highlighted.

I've been able to create a new/basice report with the exact same SQL in a command but I really don't want to rebuild the entire report as there is a lot of grouping, formatting, charts etc.

any help or ideas are very much appreciated !

 

[kray4660]

Unfortunately from my experience changing from a OLE or ODBC to a command does not give you an option to map the fields. Crystal treats the command like a derived table so you have to replace your existing fields with the ones from the command.