I'm using the Business Objects - Business Views
As such I can build a data source in the BV Manager - this is where I have my problems
In Business View Manager (BO server) - log on to server required
1) I build a data connection (ODBC, Native Oracle - does not matter both react same way) {build connection}
2) I buld a Data Foundation - referencing the data connection {selects tables - and can add relationships}
3) I build a Business element - referencing the data foundation {select table elements}
4) I build the business view - referencing the Business element {seems to just create a package}
At this point there is nothing to see - no way to validate the logic of what I slung together - just hope I got it right
In Crystal reports (CR server - also BO enterprise server) - log on to server required
1) I select blank report
2) I select the BV view I built
3) I select elements from the field explorer
4) I preview the report - good results
5) I save the report to a folder
Then I goto INFOView (this is also called the Central Managment Console (BO Server)) - where I have full admin rights
1) I select either folder or object - either works but we tend to go right to the folder
2) I select ADD - use browse to goto the folder I saved report in (on my desktop)
3) this places the rpt file in the folder on the server
I goto folder - select the report and hit preview
it goes to
and gives me
Error |
Failed to open the connection. test_oracle Details: [Database Vendor Code: 12154 ] | | |
When I use the data connection that the ADMIN user built (same ODBC or Oracle native connection, same user ID and PW (Mine) - it all works fine
This BO Server stuff is driving me nuts