public void CreateDataSource() { Definition = new DataSourceDefinition(); Definition.CredentialRetrieval = CredentialRetrievalEnum.Store; Definition.ConnectString = "data source=NIBS;initial catalog=Books"; Definition.Enabled = true; Definition.UserName = "******"; Definition.Password = "******"; Definition.EnabledSpecified = false; Definition.Extension = "SQL"; Definition.ImpersonateUserSpecified = false; Definition.Prompt = null; Definition.WindowsCredentials = false; Deploy_SSRS.ReportingServices2010.Property[] properties = new Deploy_SSRS.ReportingServices2010.Property[1]; Deploy_SSRS.ReportingServices2010.Property p = new Deploy_SSRS.ReportingServices2010.Property(); p.Name = "Hidden"; p.Value = "true"; properties[0] = p; bool IsFolderThere = CheckIfReportExists(SSRSFolder, "/", false); if (IsFolderThere) { rs.CreateDataSource(SSRSDataSource, "/" + SSRSFolder, true, Definition, properties); Console.WriteLine("Data Source Created => " + SSRSDataSource); } else { Console.WriteLine("Data Source NOT Created as no Folder => " + SSRSFolder); } //string directory = @""; // bool folderExists = CheckIfReportExists(SSRSFolder, directory); // if (!folderExists) // { // rs.CreateFolder(SSRSFolder, @"/", null); //Console.WriteLine(connection); // } // Console.WriteLine("Folder Exists => " + SSRSFolder); }
public void CreateDataSource() { // string[] DataSources_To_Create = SSRS_DataSources.Split('#'); DataSourceDefinition[] DataSources = new DataSourceDefinition[DataSources_To_Create.Count()]; DataSourceDefinition Definition; int x = 0; foreach (string ds in DataSources_To_Create) { Definition = new DataSourceDefinition(); Definition.CredentialRetrieval = CredentialRetrievalEnum.Store; Definition.ConnectString = ConfigurationManager.ConnectionStrings["Connection_" + ds].ConnectionString; //"data source=NIBS;initial catalog=Books"; Definition.Enabled = true; Definition.UserName = ConfigurationManager.AppSettings["SSRS_UserName"]; Definition.Password = ConfigurationManager.AppSettings["SSRS_UserPassword"]; Definition.EnabledSpecified = false; Definition.Extension = "SQL"; Definition.ImpersonateUserSpecified = false; Definition.Prompt = null; Definition.WindowsCredentials = false; DataSources[x] = Definition; ReportingServices2010.Property[] properties = new ReportingServices2010.Property[2]; ReportingServices2010.Property p = new ReportingServices2010.Property(); p.Name = "Hidden"; p.Value = "true"; properties[0] = p; Property desc = new Property(); desc.Name = "Description"; string Server = ConfigurationManager.ConnectionStrings["Connection_" + ds].ConnectionString; desc.Value = Server.Substring(12, Server.IndexOf("initial", 12) - 12 - 1); properties[1] = desc; rs.CreateDataSource(@"Data_Source_" + ds, "/" + SSRS_Project, true, Definition, properties); Console.WriteLine("Created DataSource => " + "/" + SSRS_Project + @"/Data_Source_" + ds); x++; } Console.WriteLine(" "); }