GetReportDataSourcePrompts Method
SQL Server 2000
ReportingService.GetReportDataSourcePrompts Method
Returns the prompt strings for each data source that is associated with a specified report.
Public Function GetReportDataSourcePrompts( _ ByVal Report As String _ ) As String Member of [Namespace].ReportingService
public string GetReportDataSourcePrompts( string Report ); Member of [Namespace].ReportingService
Parameters
- Report
- The full path name of the report.
Return Value
An array of DataSourcePrompt[] objects that represents the prompt strings for each data source that is associated with the specified report.
Permissions
| Operation | Description |
|---|---|
| Read Properties | Required on the report and on all data source items to view the data source prompt information. |
Remarks
Data sources in the report server database include the DataSourceDefinition.CredentialRetrieval property, which you use to determine how users are prompted for data source credentials. If a data source that is associated with a specific report references a shared data source in the report server database and the CredentialRetrieval property is set to Prompt, the prompt string from the data source item is returned.