Export (0) Print
Expand All
Expand Minimize

PrepareQuery Method

SQL Server 2000

ReportingService.PrepareQuery Method

Returns a dataset containing the fields retrieved by the delivery query for a data-driven subscription.

Public Function PrepareQuery( _
   ByVal DataSource As DataSource _
   ByVal DataSetDefinition As DataSet _
   ByRef Changed As Boolean _
) As [Namespace].DataSetDefinition
   Member of [Namespace].ReportingService

public [Namespace].DataSetDefinition PrepareQuery(
   DataSource DataSource,
   DataSetDefinition DataSet,
   out bool Changed
   Member of [Namespace].ReportingService
The data source for the delivery query.
The dataset containing the delivery query and fields for a data-driven subscription.
A Boolean value that indicates whether the dataset that was passed to the method is different from the one returned by the method. Use this property to determine whether the input dataset is different from the output dataset.
Return Value

A DataSetDefinition object that contains the fields and the delivery query that are retrieved from the given data source.


Pass the dataset (DataSetDefinition object) that is returned by the PrepareQuery method as input to the CreateDataDrivenSubscription and SetDataDrivenSubscriptionProperties methods.

The delivery query returns a set of fields that can be mapped to report parameter values and delivery extension settings for data-driven subscriptions. Each row in the result set contains values for a single recipient, such as an e-mail address to which the report is delivered.

The delivery query must be valid for one of the data processing extensions that are installed on the report server. For more information, see Data Processing Extensions.

See Also

ReportingService Class

Reporting Services Web Service Library

© 2014 Microsoft