public static XtraReportDefault3 CreateXtraReport(DataSet dataset)
{
var xtrareport = new XtraReportDefault3();
var accountBand = xtrareport.detailBand1;
var xrLine1 = new DevExpress.XtraReports.UI.XRLine();
accountBand.HeightF = 116.6667F;
accountBand.Name = "Detail";
accountBand.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
accountBand.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLine1
//
xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
xrLine1.Name = "xrLine1";
xrLine1.SizeF = new System.Drawing.SizeF(650F, 23F);
//accountBand.Controls.Add(xrLine1);
var columns = dataset.Tables["Account"].Columns;
float height = 35;
foreach (DataColumn column in columns) {
if (column.ColumnName == "Id") continue;
var xrLabelName = new DevExpress.XtraReports.UI.XRLabel();
xrLabelName.LocationFloat = new DevExpress.Utils.PointFloat(33.75017F, height);
xrLabelName.Name = "xrLabel13";
xrLabelName.SizeF = new System.Drawing.SizeF(200F, 23F);
xrLabelName.StylePriority.UseTextAlignment = false;
xrLabelName.Text = column.ColumnName;
xrLabelName.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
var xrLabelValues = new DevExpress.XtraReports.UI.XRLabel();
xrLabelValues.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Account."+column.ColumnName)});
xrLabelValues.LocationFloat = new DevExpress.Utils.PointFloat(243.7502F, height);
xrLabelValues.Name = "xrLabel49";
xrLabelValues.CanShrink = true;
xrLabelValues.CanGrow = true;
xrLabelValues.Multiline = true;
xrLabelValues.SizeF = new System.Drawing.SizeF(350F, 23F);
xrLabelValues.Text = "xrLabel49";
height += 35;
accountBand.Controls.Add(xrLabelName);
accountBand.Controls.Add(xrLabelValues);
}
var xrPageBreak2 = new DevExpress.XtraReports.UI.XRPageBreak();
xrPageBreak2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
xrPageBreak2.Name = "xrPageBreak2";
accountBand.Controls.Add(xrPageBreak2);
xtrareport.Bands.Add(accountBand);
return xtrareport;
}
public static XtraReportDefault CreateXtraReport(DataSet dataset)
{
XtraReportDefault xtrareport = new XtraReportDefault();
#region Account Level
var accountBand = xtrareport.detailBand1;
var xrLine1 = new DevExpress.XtraReports.UI.XRLine();
accountBand.HeightF = 116.6667F;
accountBand.Name = "Detail";
accountBand.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
accountBand.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
//
// xrLine1
//
xrLine1.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
xrLine1.Name = "xrLine1";
xrLine1.SizeF = new System.Drawing.SizeF(650F, 23F);
//accountBand.Controls.Add(xrLine1);
var columns = dataset.Tables["Account"].Columns;
float height = 35;
foreach (DataColumn column in columns) {
if (column.ColumnName == "Id") continue;
var xrLabelName = new DevExpress.XtraReports.UI.XRLabel();
xrLabelName.LocationFloat = new DevExpress.Utils.PointFloat(33.75017F, height);
xrLabelName.Name = "xrLabel13";
xrLabelName.SizeF = new System.Drawing.SizeF(200F, 23F);
xrLabelName.StylePriority.UseTextAlignment = false;
xrLabelName.Text = column.ColumnName+":";
xrLabelName.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
var xrLabelValues = new DevExpress.XtraReports.UI.XRLabel();
xrLabelValues.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "Account."+column.ColumnName)});
xrLabelValues.LocationFloat = new DevExpress.Utils.PointFloat(243.7502F, height);
xrLabelValues.Name = "xrLabel49";
xrLabelValues.CanShrink = true;
xrLabelValues.CanGrow = true;
xrLabelValues.Multiline = true;
xrLabelValues.SizeF = new System.Drawing.SizeF(350F, 23F);
xrLabelValues.Text = "xrLabel49";
height += 35;
accountBand.Controls.Add(xrLabelName);
accountBand.Controls.Add(xrLabelValues);
}
height += 35;
var xrLine4 = new DevExpress.XtraReports.UI.XRLine();
xrLine4.LocationFloat = new DevExpress.Utils.PointFloat(0F, height);
xrLine4.Name = "xrLine4";
xrLine4.SizeF = new System.Drawing.SizeF(650F, 23F);
accountBand.Controls.Add(xrLine4);
var xrPageBreak2 = new DevExpress.XtraReports.UI.XRPageBreak();
xrPageBreak2.LocationFloat = new DevExpress.Utils.PointFloat(0F, 0F);
xrPageBreak2.Name = "xrPageBreak2";
accountBand.Controls.Add(xrPageBreak2);
#endregion
#region Contact level
var contactDetailReport = new DevExpress.XtraReports.UI.DetailReportBand();
var contactDetailBand = new DevExpress.XtraReports.UI.DetailBand();
contactDetailBand.HeightF = 116.6667F;
contactDetailBand.Padding = new DevExpress.XtraPrinting.PaddingInfo(0, 0, 0, 0, 100F);
contactDetailBand.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopLeft;
contactDetailBand.Name = "Detail";
contactDetailReport.DataSource = dataset;
contactDetailReport.DataMember = "account.account_contact";
contactDetailReport.Level = 1;
contactDetailReport.Name = "DetailReport3";
var cColumns = dataset.Tables["Contact"].Columns;
height = 35;
foreach (DataColumn column in cColumns)
{
if (column.ColumnName == "AccountId" || column.ColumnName == "Id") continue;
var xrLabelName = new DevExpress.XtraReports.UI.XRLabel();
xrLabelName.LocationFloat = new DevExpress.Utils.PointFloat(33.75017F, height);
xrLabelName.Name = "xrLabel13";
xrLabelName.SizeF = new System.Drawing.SizeF(200F, 23F);
xrLabelName.StylePriority.UseTextAlignment = false;
xrLabelName.Text = column.ColumnName+":";
xrLabelName.TextAlignment = DevExpress.XtraPrinting.TextAlignment.TopRight;
var xrLabelValues = new DevExpress.XtraReports.UI.XRLabel();
xrLabelValues.DataBindings.AddRange(new DevExpress.XtraReports.UI.XRBinding[] {
new DevExpress.XtraReports.UI.XRBinding("Text", null, "account.account_contact."+column.ColumnName)});
xrLabelValues.LocationFloat = new DevExpress.Utils.PointFloat(243.7502F, height);
xrLabelValues.Name = "xrLabel49";
xrLabelValues.CanShrink = true;
xrLabelValues.CanGrow = true;
xrLabelValues.Multiline = true;
xrLabelValues.SizeF = new System.Drawing.SizeF(350F, 23F);
xrLabelValues.Text = "xrLabel49";
height += 35;
contactDetailBand.Controls.Add(xrLabelName);
contactDetailBand.Controls.Add(xrLabelValues);
}
height += 35;
xrLine4 = new DevExpress.XtraReports.UI.XRLine();
xrLine4.LocationFloat = new DevExpress.Utils.PointFloat(0F, height);
xrLine4.Name = "xrLine4";
xrLine4.SizeF = new System.Drawing.SizeF(650F, 23F);
contactDetailBand.HeightF = height+35;
contactDetailBand.Controls.Add(xrLine4);
contactDetailReport.Bands.Add(contactDetailBand);
xtrareport.Bands.AddRange(new Band[] { accountBand, contactDetailReport });
//xtrareport.Bands.Add(accountBand);
//xtrareport.Bands.Add(contactDetailReport);
#endregion
xtrareport.DataSource = dataset;
return xtrareport;
}
private XRControl AddPageBreak(TemplateDynamicData property, float yPosition)
{
var xrPageBreak1 = new DevExpress.XtraReports.UI.XRPageBreak();
xrPageBreak1.LocationFloat = new DevExpress.Utils.PointFloat(0F, yPosition);
xrPageBreak1.Name = "xrPageBreak1" + Guid.NewGuid();
return xrPageBreak1;
}
