Edit Crystal Command with missing columns

[davedai]

Hello,

I couldn't find a better title but this is what I actually want to do:

- I have downloaded a SQL Crystal Report from a SAP Note
- I want to import the Crystal Report in a HANA database

Problem:

- I can't import directly to HANA because Command includes coding which is not HANA ready
- I want to edit the command in our SQL environment but I can't properly change the Datasource location because the command includes tables and columns of official SAP tables which are not there in the new database. -> means Crystal refuses to let me edit the command!?

How can I deal with this scenario? What is the best way to convert a SQL Crystal Report to a HANA Crystal Report? How can I edit a command which contains non valid SQL at the moment because of missing columns/tables?

I appreciate any help!
Thanks
André

[davedai]

I think you need to explain why "crystal refuses to let you edit the command", in other words what happened when you tried to do that.

[Andre_S]

Thanks, meanwhile I managed to open it but now the file seems to get damaged after changing the datasource and saving the file. I get an "Invalid Report Path" error, user has superuser rights, the folder is fully accessible. Any idea!?