Trouble changing datasource

[Former Member]

Hi,

I have a report that is pointing to a view in an Oracle database.

I want to change the source from the view to a Command that contains the same sql as the view.

I go: Database -> set datasource location

I then select the view in the 'Current Data Source' window.

In the 'Replace with' window, I select the connection to the appropriate database, select 'Add Command' and click the Update button.

The 'Add Command to Report' window pops up, I paste my sql in and click Okay. Then the window closes and nothing happens. The current data source is still pointing to the view and the command does not get created. I know the sql is syntactically fine. I have even tried simple select statement (knowing the report fields wouldn't map properly), but still no go.

Does anyone have any thoughts?

I can manually add the command in the Database Expert, no problem. But then I would have to manually change all the report fields to point to the command instead of the view.

Big pain in this report (and 4 others ones I need to update) as there are a about 75 fields and they are all formatted to a specific length.

[former_member11696]

Hi Foghat,

Currently there is no mapping functionality when converting from a direct connection to the DB tables to a Command Object.

Command Objects are simply SQL Statements that CR does not touch and pass directly to the server. We then wait for the data to return. The fields defined in the SELECT portion is what you see in the designer.

I believe we are working on this ability in some future release but it will not be implimented in current versions.

No option but to re-build the reports.

Thank you

Don

[Former Member]

okay, thanks for the reply