Can anyone help me? I've created a Crystal report with several charts using tables from an Oracle Database. Now I want to replace the database tables in the Database Expert with a SQL statement by adding a new Command. The fields I used in the SQl statement are the same fields used in the report.
I tried to use the "Set Datasource Location" dialog box.
I selected the table in the "Current Data Source" and then chose the "Add Command" option in the "Replace with:" window. I hit the Update button and then pasted my SQL statement in the "Add Command To Report" dialog box. However, after choosing "update", the SQL statement in the command line disapperas and the Database Table is still listed as the Current Data Source.
Is this a bug, or am I doing something wrong?