When working with server reports, the connection string needs to be embedded in the report definition, or (recommended) used by a name registered in Report Server Data Connections
. The Data Connections are managed through the DATA
page in the Report Server Management Console. This page allows to register a new connection or edit/delete existing one. Once registered in Data Connections, the connection can be referred by name by all the reports stored in Report Server. The server data connections are available when designing a server reports - they will be listed in the Choose data connection
page of the Configure SQL Data Source
I shot a small movie demonstrating how to create a data connection to Oracle database and then create a report that uses that connection. The report can be previewed in the Standalone Designer and in the Report Server Management Console. The video can be seen here: https://www.screencast.com/t/VKmJACId
(please note that it has no sound and requires Adobe Flash to run). I hope you will find it useful, but if you have further questions, please do not hesitate to ask.
Do you want to have your say when we set our development plans?
Do you want to know when a feature you care about is added or when a bug fixed?
Telerik Feedback Portal
and vote to affect the priority of the items