var repository = Repository.Create();
Report report = Report.Create(repository);
report.DisplayName = "BikeStore Report";
MetaSource source = new MetaSource();
ReportSource newSource = report.AddSource(source);
if (source != null)
{
newSource.LoadRepositoryMetaSources(repository);
}
// MSSqlServerConnectionString
newSource.Connection.MSSqlServerConnectionString = @"Data Source=(LocalDB)\MSSQLLocalDB;AttachDbFilename=""C:\Program Files\Microsoft SQL Server\MSSQL15.SERVER1\MSSQL\DATA\BikeStores.mdf"";Integrated Security=True;Connect Timeout=30";
newSource.Connection.ConnectionType = ConnectionType.MSSQLServer;
newSource.Connection.DatabaseType = DatabaseType.MSSQLServer;
// newSource.Connection.CheckConnection(); -------------------check connection
Response.Write(newSource.Connection.HelperCheckConnection);


//Report Model Design

ReportModel model1 = ReportModel.Create();
model1.Name = "sale per id";

model1.SourceGUID = newSource.GUID;
model1.ConnectionGUID = newSource.Connection.GUID;
model1.Report = report;

//Metacolumn1 design for Elemet1
MetaColumn column1 = new MetaColumn();
column1.Source = newSource;
column1.Name = "SELECT Commission FROM sales.commissions";

//Report Element1 Design------------------------------------
ReportElement elemet1 = ReportElement.Create();
elemet1.Source = newSource;
elemet1.Report = report;
elemet1.Model = model1;
elemet1.MetaColumnGUID = column1.GUID;
elemet1.MetaColumn = column1;
elemet1.Name = column1.Name;
elemet1.SerieDefinition = SerieDefinition.Axis;
elemet1.AxisUseValues = false;
elemet1.SetDefaults();