Skip to Content
author's profile photo Former Member
Former Member

Trouble changing datasource

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Sep 18, 2009 at 05:53 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.