CODEWITHSUNDEEP
oracle-databasecrystal-reportsoracle11g
user3245120
user3245120

Reputation: 5

Crystal Reports Data Source in Oracle

I inherited a legacy system using Crystal Reports in VS.NET pulling info from an Oracle11g DB.

The database fields are in "REPORT_DATA", I updated the stored procedure which the code is querying to add a field, however I cannot see that new field in the field explorer.

When I click on "Verify Database" and manage to log into the DB I get a "Remove Table" prompt - "The database table "REPORT_DATA" cannot be found. Proceed to remove this table from the report?"

Of course, there is no REPORT_DATA table and there never was.

When I preview the report or put it on the server it works, so there is some behind-the-scenes magic which I don't understand.

Upvotes: 0

Views: 804

Answers (1)

user3245120
user3245120

Reputation: 5

Figured it out.

I had to highlight the server name in the “Current Data Source” area and the name of the server in the “Replace With” area on the Set Datasource Location window. Then click the “Update” button.

Since the report wasn't built on my machine it had to be reconfigured - can't figure out why it still connected to the DB when previewing though.

Upvotes: 0

Related Questions