Question

如何列出所有报告, 我在报告服务器上创建的报告? 稍后我要使用此列表在 < code> ReportViewer 控制器中显示它们。

Answer 1

报告服务器使用名为 findObjects nocursive 的存储程序。

string cnxstr = "Data Source=server;Initial Catalog=ReportServer;Integrated Security=SSPI;"; //connection string
using (SqlConnection connection = new SqlConnection(cnxstr))
{
    connection.Open(); 
    SqlCommand command = new SqlCommand();
    command.Connection = connection; 
    command.CommandType = CommandType.StoredProcedure; 
    command.CommandText = "FindObjectsNonRecursive";
    command.Parameters.Add(new SqlParameter("@Path", "/folder_name"));
    command.Parameters.Add(new SqlParameter("@AuthType", 1));
    SqlDataReader reader = null; 
    try
    {
        reader = command.ExecuteReader(); 
        while (reader.Read())
        {
            string path = reader["Path"].ToString(); 
            //now you can display this path in your list, or do whatever
        }
    }
    finally
    {  
        if (reader != null) 
            reader.Close(); 
    }
}

友情链接