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(" ");
}