SSRS Connect Oracle Database Production reports

SSRS reports are based on an Oracle database to make a report example.

Development environment: VS2010

SQL Server database: SQL Server 2012

PS: The database Connection section may have another problem is that the Oracle data source part of the thing should be installed in the Oracle client, but also on the test machine is installed, But in the plsql to see the Tnsnames.ora file is not the Oracle client file, this is a bit strange, I will try again in two days, just this machine reinstall, verify and then update the article.

First, create the relevant data source.

Place the string directly inside the connection string, as in the following example:

Data source= "(Description= (address_list= (address= (protocol=tcp) (host=192.190.1.123) (port=1521))) (CONNECT_DATA= ( SERVICE_NAME=TESTDB)) "

Clicking Edit will pop up the "Connection Properties" window and enter your username and password. Do some testing. A successful pop-up test connection indicates that the Oracle database has been opened.

Add a report below. Basically all the way next, I upload several key pictures.

The completion section above is the completion of this report, on the right side of the project there is a

Double-click the report to see the following effect.

This is a report of the new process, good trouble ah, with the figure is also blame waste time, the next section I began to do the parameter transfer part. A complete report will be rendered.