logo
Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error

Options
Go to last post Go to first unread
div  
#1 Posted : Thursday, February 4, 2021 2:09:59 PM(UTC)
div

Rank: Newbie

Groups: Registered
Joined: 1/13/2021(UTC)
Posts: 0
India
Location: Chennai

Thanks: 5 times
i'm trying to create the manual dashboard just using seallibrary.dll but there are some issue in it.
I've chaecked connection, It works fine but it don't work, Colum is not loaded.

I took referance of Dashboard application to set some properties but it's not sufficient.


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();
Users browsing this topic
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.