Share via


Creating Report Datasets from an Oracle Database

Reporting Services provides a data processing extension that supports report data retrieval from an Oracle relational data source. After you have connected to an Oracle data source, you can create a report dataset that defines the data that you want to in your report.

To create a dataset, you can either select a stored procedure from a drop-down list or create an SQL query. You can also specify properties and define report parameters and query parameters. For more information, see How to: Retrieve Data from an Oracle Data Source.

There are two types of query designers: a text-based query designer and a graphical query designer. The text-based query designer opens by default and accepts non-standard query syntax (for example, expressions in the connection string). For more information, see Text-based Query Designer User Interface and Graphical Query Designer User Interface.

Using Query Parameters

If your query contains parameters, Report Designer automatically creates corresponding report parameters in the report definition when you type the query. When the report runs, values for the report parameters are passed to the query parameters. For more information, see Adding Parameters to Your Report and How to: Associate a Query Parameter with a Report Parameter.

Using Stored Procedures

You can use stored procedures to return data in a dataset. To do this, in the Command Type text box, select StoredProcedure, and then provide the name of the stored procedure. Reporting Services supports stored procedures that return only one set of data.