Hello Marcel,
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 wizard.
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.
Regards,
Ivan Hristov
Progress Telerik
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?
Explore the
Telerik Feedback Portal
and vote to affect the priority of the items