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.
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.