Defining Report Datasets for Relational Data from an SAP Database
SQL Server 2005 provides the Microsoft .NET Data Provider for mySAP Business Suite. You can use this data provider as a data processing extension to define relational SAP data for a Reporting Services report. To retrieve multidimensional data from an SAP data source, see Defining Report Datasets for Multidimensional Data from an SAP NetWeaver BI System.
The .NET Data Provider for mySAP Business Suite is not installed or configured by default. For information about how to make the data provider available to a Reporting Services installation, see Configuring Reporting Services to Use the Microsoft .NET Framework Data Provider for mySAP Business Suite.
Configuration steps include having your database administrator install two custom remote function calls (RFCs) that provide support for Business API (BAPI) calls to the underlying SAP database. Depending on the configuration, one or several result sets can be returned from the data source. Reporting Services currently supports only the first result set returned. If multiple result sets are expected or if the Business API (BAPI) has OUT parameters of type Table, you can customize the .NET data provider and manipulate the multiple result sets separately. For more information, see Implementing a Data Processing Extension.
To view instructions about creating a dataset, see How to: Create a Dataset (Report Designer).