如何使用.NET从SSRS报告中获取数据源信息

using System;
using System.Collections.Generic;
using System.ServiceModel;
using ReportServiceReference;

public static List<DataSource> GetReportDataSources(string reportServerUrl, string reportPath, string username, string password)
{
    // 创建ReportingService2010对象
    var rs = new ReportingService2010SoapClient("ReportingService2010Soap");

    // 设置凭据
    rs.ClientCredentials.Windows.ClientCredential.UserName = username;
    rs.ClientCredentials.Windows.ClientCredential.Password = password;

    // 设置URL
    rs.Endpoint.Address = new EndpointAddress(reportServerUrl);

    // 获取报告数据源
    DataSource[] dataSources = rs.GetItemDataSources(reportPath);

    // 将结果转换为列表并返回
    return new List<DataSource>(dataSources);
}

string reportServerUrl = "http://your-report-server/ReportServer/ReportService2010.asmx";
string reportPath = "/YourReportFolder/YourReportName";
string username = "your-username";
string password = "your-password";

List<DataSource> dataSources = GetReportDataSources(reportServerUrl, reportPath, username, password);

// 输出数据源信息
foreach (DataSource dataSource in dataSources)
{
    Console.WriteLine($"Name: {dataSource.Name}");
    Console.WriteLine($"ConnectionString: {dataSource.ConnectionString}");
    Console.WriteLine($"DataSourceReference: {dataSource.DataSourceReference}");
    Console.WriteLine($"Enabled: {dataSource.Enabled}");
    Console.WriteLine($"Extension: {dataSource.Extension}");
    Console.WriteLine($"ImpersonateUser: {dataSource.ImpersonateUser}");
    Console.WriteLine($"OriginalConnectStringExpressionBased: {dataSource.OriginalConnectStringExpressionBased}");
    Console.WriteLine($"Prompt: {dataSource.Prompt}");
    Console.WriteLine($"UseOriginalConnectString: {dataSource.UseOriginalConnectString}");
    Console.WriteLine($"UserName: {dataSource.UserName}");
    Console.WriteLine($"WindowsCredentials: {dataSource.WindowsCredentials}");
}