public virtual ReportColumnCollection GetColumns()
{
ReportColumnCollection toRet = new ReportColumnCollection();
foreach (DataColumn dataColumn in dataView.Table.Columns)
{
ReportDataColumn rdColumn = toRet.AddNewReportDataColumn(dataColumn.ColumnName);
rdColumn.HeaderText = dataColumn.Caption;
rdColumn.ValueType = dataColumn.DataType;
if (rdColumn.ValueType == typeof(System.Drawing.Image))
{
rdColumn.DataCellViewType = CellViewImage.CreateDatabaseImage(ImageMIMEType.Jpeg);
}
else if (rdColumn.ValueType == typeof(System.Drawing.Bitmap))
{
rdColumn.DataCellViewType = CellViewImage.CreateDatabaseImage(ImageMIMEType.Bmp);
}
rdColumn.HeaderStyle.Border =
rdColumn.DefaultCellStyle.Border = DefaultBorder;
rdColumn.DefaultCellStyle.Width = new Size(DefaultColumnWidth);
rdColumn.DefaultCellStyle.Wrap = true;
}
return(toRet);
}
private void SetUpColumnsGroupings()
{
this.ColumnGroupings.Clear();
RColumnGrouping columnGrouping0 = new RColumnGrouping();
{
columnGrouping0.Height = new Unit(0.3, UnitType.Inch);
RDynamicColumns dynamicColumns = new RDynamicColumns();
{
dynamicColumns.Grouping = new RGrouping(this, this.ColumnGroupings);
dynamicColumns.Grouping.GroupExpressions.Add(
new RExpression(
GetReportColumnValue(ReportDataColumns[2])
));
dynamicColumns.ReportItem = GetReportCellControlItem(ReportDataColumns[2] as ReportDataColumn);
}
columnGrouping0.DynamicColumns = dynamicColumns;
}
this.ColumnGroupings.Add(columnGrouping0);
//Static headers
RColumnGrouping columnGrouping1 = new RColumnGrouping();
{
columnGrouping1.Height = new Unit(0.3, UnitType.Inch);
RStaticColumns staticColumns = new RStaticColumns();
{
foreach (ReportColumn reportColumn in ReportDataColumns)
{
RStaticColumn staticColumn = new RStaticColumn();
if (reportColumn is ReportDataColumn)
{
ReportDataColumn reportDataColumn = reportColumn as ReportDataColumn;
staticColumn.ReportItem = GetReportHeaderControlItem(reportDataColumn);
staticColumns.Add(staticColumn);
}
else if (reportColumn is ReportHyperlinkColumn)
{
}
}
}
columnGrouping1.StaticColumns = staticColumns;
}
this.ColumnGroupings.Add(columnGrouping1);
}
/// <summary>
/// Create DataTable for visible columns of DataGridView
/// </summary>
/// <param name="dgv"></param>
private void CreateHeaders()
{
//add columns to table
for (int colIndex = 0; colIndex < Columns.Count; colIndex++)
{
ReportColumn rColumn = Columns[colIndex];
Type columnType = rColumn.ValueType;
if (rColumn is ReportDataColumn)
{
ReportDataColumn rdColumn = rColumn as ReportDataColumn;
//Replace True/False to "+/-"
if (rdColumn.ValueType == typeof(bool) || rdColumn.ValueType == null)
{
columnType = typeof(string);
}
else if (rdColumn.ValueType == typeof(System.Drawing.Image) || rdColumn.ValueType == typeof(System.Drawing.Bitmap))
{
columnType = typeof(byte[]);
}
else if (!String.IsNullOrEmpty(rdColumn.DefaultCellStyle.Format))
{
columnType = typeof(string);
}
}
else if (rColumn is ReportHyperlinkColumn)
{
if (rColumn.ValueType == typeof(Uri))
{
columnType = typeof(string);
}
else if (rColumn.ValueType != typeof(string))
{
throw new ApplicationException("HyperLinkColumn should have content type System.String or System.Uri.");
}
}
else
{
throw new ApplicationException("Unknown ReportColumn type.");
}
_report.ExportedTable.Columns.Add(rColumn.Name, columnType);
}
}
private void SetUpColumnsHeaders()
{
Header.TableRows.Clear();
RTableCell tCell;
RTableRow headerRow = new RTableRow();
double sumColWidthInMillimeters = 0;
foreach (ReportColumn reportColumn in ReportDataColumns)
{
if (reportColumn is ReportDataColumn)
{
ReportDataColumn reportDataColumn = reportColumn as ReportDataColumn;
Unit _widthOfColumn = reportDataColumn.HeaderStyle.Width;
if (_widthOfColumn.Value == 0)
{
_widthOfColumn = reportDataColumn.DefaultCellStyle.Width;
}
RTableColumn newColumn = new RTableColumn();
newColumn.Width = _widthOfColumn;
this.TableColumns.Add(newColumn);
sumColWidthInMillimeters += MeasureTools.UnitToMillimeters(_widthOfColumn);
tCell = new RTableCell();
ReportControlItem rHeaderItem;
int columnIndex = ReportDataColumns.IndexOf(reportDataColumn);
int reportItemZIndex = columnIndex + 1;
rHeaderItem = GetReportHeaderControlItem(reportDataColumn);
//////////////////////
tCell.ReportItems.Add(rHeaderItem);
headerRow.TableCells.Add(tCell);
}
else if (reportColumn is ReportHyperlinkColumn)
{
}
}
Item.Width = new Unit(sumColWidthInMillimeters, UnitType.Mm);
Header.TableRows.Add(headerRow);
}
public ReportData GetWeightTicketsReport(WeightTicketReportFilterModel filters)
{
ReportData reportData = new ReportData();
DataTable data = weightTicketsDL.GetWeightTicketsReport(filters);
foreach (DataColumn column in data.Columns)
{
ReportDataColumn reportColumn = new ReportDataColumn();
reportColumn.Type = column.DataType;
reportColumn.Name = column.ColumnName;
reportData.Columns.Add(reportColumn);
}
foreach (DataRow row in data.Rows)
{
ReportDataRow reportRow = new ReportDataRow();
reportRow.Items = new List <object>(row.ItemArray);
reportData.Rows.Add(reportRow);
}
return(reportData);
}
private static ReportControlItem GetReportCellControlItem(ReportDataColumn reportDataColumn)
{
ReportControlItem toRet = null;
if (reportDataColumn.DataCellViewType is CellViewImage)
{
CellViewImage imgCellView = reportDataColumn.DataCellViewType as CellViewImage;
RImage rImage = new RImage(
reportDataColumn.Name,
true,
GetReportColumnValue(reportDataColumn),
imgCellView.Properties
);
if (reportDataColumn.HyperlinkColumn != null)
{
rImage.ImageBox.Action = new ReportExporters.Common.Model.Action(
GetReportColumnValue(reportDataColumn.HyperlinkColumn));
}
toRet = rImage;
}
else
{
RTextBox rTextbox = new RTextBox(reportDataColumn.Name, GetReportColumnValue(reportDataColumn));
if (reportDataColumn.HyperlinkColumn != null)
{
rTextbox.TextBox.Action = new ReportExporters.Common.Model.Action(
GetReportColumnValue(reportDataColumn.HyperlinkColumn));
}
toRet = rTextbox;
}
toRet.Item.Style = reportDataColumn.DefaultCellStyle;
return(toRet);
}
private static ReportControlItem GetReportHeaderControlItem(ReportDataColumn reportDataColumn)
{
ReportControlItem rHeaderItem = null;
if (reportDataColumn.HeaderCellViewType is CellViewImage)
{
CellViewImage imgCellView = reportDataColumn.HeaderCellViewType as CellViewImage;
RImage rImage = new RImage(
"header" + reportDataColumn.Name,
true,
reportDataColumn.HeaderText,
imgCellView.Properties
);
if ((reportDataColumn.HyperlinkColumn != null) && (reportDataColumn.HeaderCellHyperlink != null))
{
rImage.ImageBox.Action = new ReportExporters.Common.Model.Action(reportDataColumn.HeaderCellHyperlink);
}
rHeaderItem = rImage;
}
else
{
RTextBox rHeaderTextbox = new RTextBox(
"header" + reportDataColumn.Name, reportDataColumn.HeaderText);
if ((reportDataColumn.HyperlinkColumn != null) && (reportDataColumn.HeaderCellHyperlink != null))
{
rHeaderTextbox.TextBox.Action = new ReportExporters.Common.Model.Action(reportDataColumn.HeaderCellHyperlink);
}
rHeaderItem = rHeaderTextbox;
}
rHeaderItem.Item.Style = reportDataColumn.HeaderStyle;
return(rHeaderItem);
}
public virtual ReportColumnCollection GetColumns()
{
ReportColumnCollection toRet = new ReportColumnCollection();
foreach (DataGridViewColumn dgvColumn in dataGridView.Columns)
{
ReportDataColumn rdColumn = toRet.AddNewReportDataColumn(dgvColumn.Name);
rdColumn.HeaderText = dgvColumn.HeaderText;
rdColumn.ValueType = dgvColumn.ValueType;
if (dgvColumn is DataGridViewImageColumn)
{
CellViewImage databaseCellViewImage = CellViewImage.CreateDatabaseImage(ImageMIMEType.Jpeg);
//databaseCellViewImage.Sizing = ImageSizing.FitProportional;
rdColumn.DataCellViewType = databaseCellViewImage;
}
{ //initialize style for column header cell
InitReportStyleFrom(
rdColumn.HeaderStyle,
dgvColumn.HeaderCell.HasStyle ? dgvColumn.HeaderCell.Style : dgvColumn.HeaderCell.InheritedStyle);
}
{ //initialize style for column content cell
InitReportStyleFrom(rdColumn.DefaultCellStyle,
dgvColumn.HasDefaultCellStyle ? dgvColumn.DefaultCellStyle : dgvColumn.InheritedStyle);
}
//set column width
rdColumn.HeaderStyle.Width =
rdColumn.DefaultCellStyle.Width =
new System.Web.UI.WebControls.Unit(dgvColumn.Width, System.Web.UI.WebControls.UnitType.Pixel);
}
return(toRet);
}
private void SetUpCells()
{
Details.TableRows.Clear();
if ((reportTableGroups != null) && (reportTableGroups.Count > 0))
{
#region apply grouping
TableGroups = new RTableGroups();
for (int rtgIndex = 0; rtgIndex < reportTableGroups.Count; rtgIndex++)
{
ReportTableGroup reportTableGroup = reportTableGroups[rtgIndex];
//ReportColumn firstColumn = reportTableGroup.ColumnGrouping[0];
RTableGroup newGroup = new RTableGroup();
newGroup.Grouping.Name = string.Format("{0}_Group{1}", Name, rtgIndex + 1);
//Grouping
foreach (ReportColumn groupingColumn in reportTableGroup.ColumnGrouping)
{
RExpression groupingExpression = new RExpression(GetReportColumnValue(groupingColumn));
newGroup.Grouping.GroupExpressions.Add(groupingExpression);
}
//Sorting
if (reportTableGroup.ColumnSorting.Count > 0)
{
RSorting groupSorting = new RSorting();
foreach (ReportColumn sortingColumn in reportTableGroup.ColumnSorting.Keys)
{
RSortBy sortByColumn = new RSortBy();
sortByColumn.SortExpression = GetReportColumnValue(sortingColumn);
sortByColumn.Direction = reportTableGroup.ColumnSorting[sortingColumn];
groupSorting.SortBy.Add(sortByColumn);
}
newGroup.Sorting = groupSorting;
}
//Header
{
RHeader groupHeader = new RHeader();
{
RTableRow headerRow = new RTableRow();
{
BaseStyle hightlightStyleForRow = null;
foreach (ReportColumn reportColumn in ReportDataColumns)
{
if (reportColumn is ReportDataColumn)
{
ReportControlItem tbxHeader;
if (reportTableGroup.ColumnGrouping.Contains(reportColumn))
{
tbxHeader = GetReportCellControlItem(reportColumn as ReportDataColumn);
if (hightlightStyleForRow == null)
{
hightlightStyleForRow = tbxHeader.Item.Style;
}
}
else
{
tbxHeader = new RTextBox(String.Empty);
}
RTableCell rTableCell = new RTableCell();
rTableCell.ReportItems.Add(tbxHeader);
headerRow.TableCells.Add(rTableCell);
}
}
if (hightlightStyleForRow != null)
{
hightlightStyleForRow.Border.Style = BorderStyle.None;
headerRow.Style = hightlightStyleForRow;
}
}
groupHeader.TableRows.Add(headerRow);
}
newGroup.Header = groupHeader;
}
//Footer
{
//RFooter groupFooter = new RFooter();
//newGroup.Footer = groupFooter;
}
TableGroups.Add(newGroup);
}
#endregion
}
RTableCell tCell;
RTableRow tRow = new RTableRow();
tRow.Height = this.rowHeight;
foreach (DataColumn dataColumn in SourceDataTable.Columns)
{
tCell = new RTableCell();
ReportControlItem rDataTableItem;
int columnIndex = SourceDataTable.Columns.IndexOf(dataColumn);
int reportItemZIndex = columnIndex + 1;
ReportColumn reportColumn = reportDataColumns[columnIndex];
if (reportColumn is ReportDataColumn)
{
ReportDataColumn reportDataColumn = reportColumn as ReportDataColumn;
if ((this.reportTableGroups != null) && (this.reportTableGroups.ContainsColumn(reportColumn)))
{
rDataTableItem = new RTextBox(string.Empty);
}
else
{
rDataTableItem = GetReportCellControlItem(reportDataColumn);
}
tCell.ReportItems.Add(rDataTableItem);
tRow.TableCells.Add(tCell);
}
else if (reportColumn is ReportHyperlinkColumn)
{
}
}
Details.TableRows.Add(tRow);
}
public void MakeDocument(ReportDocument reportDocument)
{
if (this.mObj != null)
{
TextStyle.ResetStyles();
DateTime serverDtm = GlobalWebServiceDAL.GetServerDtm();
float num = 1f;
float num2 = 10f;
float num3 = 10f;
float num4 = 420f;
float num5 = 480f;
float num6 = 150f;
float num7 = 100f;
try
{
num = Convert.ToSingle(ConfigurationSettings.AppSettings["eiroutprint.pen.width"]);
}
catch (Exception)
{
}
try
{
num2 = Convert.ToSingle(ConfigurationSettings.AppSettings["eiroutprint.box.margin"]);
}
catch (Exception)
{
}
try
{
num3 = Convert.ToSingle(ConfigurationSettings.AppSettings["eiroutprint.box.padding"]);
}
catch (Exception)
{
}
try
{
num4 = Convert.ToSingle(ConfigurationSettings.AppSettings["eiroutprint.box.width"]);
}
catch (Exception)
{
}
try
{
num5 = Convert.ToSingle(ConfigurationSettings.AppSettings["eiroutprint.box.height"]);
}
catch (Exception)
{
}
try
{
num6 = Convert.ToSingle(ConfigurationSettings.AppSettings["eiroutprint.col1.width"]);
}
catch (Exception)
{
}
try
{
num7 = Convert.ToSingle(ConfigurationSettings.AppSettings["eiroutprint.col2.width"]);
}
catch (Exception)
{
}
Pen borders = new Pen(Color.White, num / 100f);
Pen pen = new Pen(Color.Black, num / 100f);
ReportBuilder builder = new ReportBuilder(reportDocument);
builder.StartBox(num2 / 100f, borders, num3 / 100f, Brushes.White, num4 / 100f, num5 / 100f);
builder.StartLinearLayout(Direction.Vertical);
builder.DefaultTablePen = borders;
string name = "Times New Roman";
int num8 = 12;
string text = "PT. MULTICON INDRAJAYA TERMINAL";
string str3 = "EQUIPMENT INTERCHANGE RECEIPT (OUT)";
string str4 = "Lucida Console";
int num9 = 10;
string headerText = "D/O No.";
string str6 = "Shipper";
string str7 = "VESSEL/VOY No.";
string str8 = "Destination";
string str9 = "Quantity";
string str10 = "Principal";
string str11 = "Delivered";
string str12 = "Vehicle No.";
string str13 = "Lucida Console";
int num10 = 10;
string str14 = "CONTAINER PREFIX + NUMBER";
string str15 = "SIZE";
string str16 = "TYPE";
string str17 = "CONDITION";
string str18 = "SEAL NUMBER";
string format = "REMARKS : {0} {1} {2}";
string str20 = "Arial";
int num11 = 10;
string str21 = "Printed and Authorized, {0} {1}";
string str22 = "PT. MULTICON INDRAJAYA TERMINAL";
try
{
num8 = Convert.ToInt32(ConfigurationSettings.AppSettings["eiroutprint.header.font.size"]);
}
catch (Exception)
{
}
try
{
num9 = Convert.ToInt32(ConfigurationSettings.AppSettings["eiroutprint.main.font.size"]);
}
catch (Exception)
{
}
try
{
num10 = Convert.ToInt32(ConfigurationSettings.AppSettings["eiroutprint.line.font.size"]);
}
catch (Exception)
{
}
try
{
num11 = Convert.ToInt32(ConfigurationSettings.AppSettings["eiroutprint.footer.font.size"]);
}
catch (Exception)
{
}
try
{
name = ConfigurationSettings.AppSettings["eiroutprint.header.font.name"];
}
catch (Exception)
{
}
try
{
text = ConfigurationSettings.AppSettings["eiroutprint.header.1"];
}
catch (Exception)
{
}
try
{
str3 = ConfigurationSettings.AppSettings["eiroutprint.header.2"];
}
catch (Exception)
{
}
try
{
str4 = ConfigurationSettings.AppSettings["eiroutprint.main.font.name"];
}
catch (Exception)
{
}
try
{
headerText = ConfigurationSettings.AppSettings["eiroutprint.main.1"];
}
catch (Exception)
{
}
try
{
str6 = ConfigurationSettings.AppSettings["eiroutprint.main.2"];
}
catch (Exception)
{
}
try
{
str7 = ConfigurationSettings.AppSettings["eiroutprint.main.3"];
}
catch (Exception)
{
}
try
{
str8 = ConfigurationSettings.AppSettings["eiroutprint.main.4"];
}
catch (Exception)
{
}
try
{
str9 = ConfigurationSettings.AppSettings["eiroutprint.main.5"];
}
catch (Exception)
{
}
try
{
str10 = ConfigurationSettings.AppSettings["eiroutprint.main.6"];
}
catch (Exception)
{
}
try
{
str11 = ConfigurationSettings.AppSettings["eiroutprint.main.7"];
}
catch (Exception)
{
}
try
{
str12 = ConfigurationSettings.AppSettings["eiroutprint.main.8"];
}
catch (Exception)
{
}
try
{
str13 = ConfigurationSettings.AppSettings["eiroutprint.line.font.name"];
}
catch (Exception)
{
}
try
{
str14 = ConfigurationSettings.AppSettings["eiroutprint.line.1"];
}
catch (Exception)
{
}
try
{
str15 = ConfigurationSettings.AppSettings["eiroutprint.line.2"];
}
catch (Exception)
{
}
try
{
str16 = ConfigurationSettings.AppSettings["eiroutprint.line.3"];
}
catch (Exception)
{
}
try
{
str17 = ConfigurationSettings.AppSettings["eiroutprint.line.4"];
}
catch (Exception)
{
}
try
{
str18 = ConfigurationSettings.AppSettings["eiroutprint.line.5"];
}
catch (Exception)
{
}
try
{
format = ConfigurationSettings.AppSettings["eiroutprint.line.6"];
}
catch (Exception)
{
}
try
{
str20 = ConfigurationSettings.AppSettings["eiroutprint.footer.font.name"];
}
catch (Exception)
{
}
try
{
str21 = ConfigurationSettings.AppSettings["eiroutprint.footer.1"];
}
catch (Exception)
{
}
try
{
str22 = ConfigurationSettings.AppSettings["eiroutprint.footer.2"];
}
catch (Exception)
{
}
TextStyle textStyle = new TextStyle(TextStyle.BoldStyle);
textStyle.FontFamily = new FontFamily(name);
textStyle.Size = num8;
textStyle.StringAlignment = StringAlignment.Center;
TextStyle style2 = new TextStyle(TextStyle.Normal);
style2.FontFamily = new FontFamily(str4);
style2.Size = num9;
TextStyle style3 = new TextStyle(TextStyle.Normal);
style3.FontFamily = new FontFamily(str13);
style3.Size = num10;
TextStyle style4 = new TextStyle(TextStyle.Normal);
style4.FontFamily = new FontFamily(str20);
style4.Size = num11;
builder.AddText(text, textStyle);
builder.AddText(str3, textStyle);
builder.AddHorizontalLine(pen);
DataTable table = new DataTable("main");
table.Columns.Add("column1", typeof(string));
table.Columns.Add("column2", typeof(string));
table.Rows.Add(new object[] { str6, this.mObj.Shipper });
table.Rows.Add(new object[] { str7, this.mObj.VesselVoyageName });
table.Rows.Add(new object[] { str8, this.mObj.DestinationName });
table.Rows.Add(new object[] { str9, "?" });
table.Rows.Add(new object[] { str10, this.mCust.Name });
table.Rows.Add(new object[] { str11, this.mObj.AngkutanOut });
table.Rows.Add(new object[] { str12, this.mObj.NoMobilOut });
SectionTable table2 = builder.AddTable(table.DefaultView, true);
table2.InnerPenHeaderBottom.Color = Color.White;
table2.InnerPenRow.Color = Color.White;
table2.HeaderTextStyle.SetFromFont(style2.GetFont());
table2.HorizontalAlignment = HorizontalAlignment.Center;
ReportDataColumn column = builder.AddColumn("column1", headerText, num6 / 100f, false, false);
column.HeaderTextStyle = style2;
column.DetailRowTextStyle = style2;
column.AlternatingRowTextStyle = style2;
ReportDataColumn column2 = builder.AddColumn("column2", this.mObj.DoNumber, num7 / 100f, false, false);
column2.HeaderTextStyle = style2;
column2.DetailRowTextStyle = style2;
column2.AlternatingRowTextStyle = style2;
builder.AddHorizontalLine(pen);
DataTable table3 = new DataTable("line");
table3.Columns.Add("column1", typeof(string));
table3.Columns.Add("column2", typeof(string));
table3.Rows.Add(new object[] { str15, this.mObj.Size });
table3.Rows.Add(new object[] { str16, this.mObj.Type });
table3.Rows.Add(new object[] { str17, this.mObj.Condition });
table3.Rows.Add(new object[] { str18, this.mObj.Seal });
SectionTable table4 = builder.AddTable(table3.DefaultView, true);
table4.InnerPenHeaderBottom = borders;
table4.InnerPenRow = borders;
table4.OuterPens = borders;
table4.HeaderTextStyle.SetFromFont(style3.GetFont());
table4.HorizontalAlignment = HorizontalAlignment.Center;
ReportDataColumn column3 = builder.AddColumn("column1", str14.Replace('+', '&'), num6 / 100f, false, false);
column3.HeaderTextStyle = style3;
column3.DetailRowTextStyle = style3;
column3.AlternatingRowTextStyle = style3;
ReportDataColumn column4 = builder.AddColumn("column2", this.mObj.Cont, num7 / 100f, false, false);
column4.HeaderTextStyle = style3;
column4.DetailRowTextStyle = style3;
column4.AlternatingRowTextStyle = style3;
builder.AddText(" ", style3);
builder.AddText(string.Format(format, this.mObj.Remarks), style3);
builder.AddHorizontalLine(pen);
builder.AddText(" ", style4);
string introduced93 = serverDtm.ToLongDateString();
builder.AddText(string.Format(str21, introduced93, serverDtm.ToLongTimeString()), style4);
builder.AddText(str22, style4);
builder.AddText(" \r\n ", style4);
builder.FinishLinearLayout();
builder.FinishBox();
}
}
/// <summary>
/// Copy cell items from visible columns retrived by IReportDataAdapter
/// </summary>
/// <param name="dgv"></param>
private void CopyRowData()
{
DataRow dtRow;
_report.ExportedTable.Rows.Clear();
int RowCount = reportDataAdapter.GetRowCount();
//create rows
for (int rowIndex = 0; rowIndex < RowCount; rowIndex++)
{
dtRow = _report.ExportedTable.NewRow();
_report.ExportedTable.Rows.Add(dtRow);
}
//add columns to table
for (int colIndex = 0; colIndex < Columns.Count; colIndex++)
{
ReportColumn rColumn = Columns[colIndex];
//proccess rows
for (int rowIndex = 0; rowIndex < RowCount; rowIndex++)
{
object cellValue = reportDataAdapter.GetCellItemValue(rColumn, rowIndex);
//Exported value
object expValue = null;
if (cellValue != null)
{
if (rColumn is ReportDataColumn)
{
ReportDataColumn rdColumn = rColumn as ReportDataColumn;
string valueFormat = rdColumn.DefaultCellStyle.Format;
if (!String.IsNullOrEmpty(valueFormat) || !String.IsNullOrEmpty(rdColumn.TemplateFormat))
{
//like {0:[valueFormat]} or {0}
string fullValueFormat =
"{0" + (String.IsNullOrEmpty(valueFormat) ? "" : ":" + valueFormat)
+ "}";
//like "Name is {0:[valueFormat]}."
string fullTemplateFormat = String.IsNullOrEmpty(rdColumn.TemplateFormat)
? fullValueFormat
: string.Format(rdColumn.TemplateFormat, fullValueFormat);
expValue = string.Format(fullTemplateFormat, cellValue);
}
else if (rdColumn.ValueConverter != null)
{
expValue = rdColumn.ValueConverter.ConvertToString(cellValue);
}
else if (rdColumn.ValueType == typeof(System.Drawing.Image) ||
rdColumn.ValueType == typeof(System.Drawing.Bitmap))
{
System.Drawing.Image imgValue = cellValue as System.Drawing.Image;
MemoryStream memStream = new MemoryStream();
imgValue.Save(memStream, imgValue.RawFormat);
expValue = memStream.ToArray();
}
else
{
expValue = cellValue;
}
ProccessStyle(rdColumn.DefaultCellStyle);
ProccessStyle(rdColumn.HeaderStyle);
}
else if (rColumn is ReportHyperlinkColumn)
{
expValue = cellValue.ToString();
}
}
else
{
// No value available
}
if ((expValue != null) && (expValue.GetType() != typeof(System.Object)))
{
_report.ExportedTable.Rows[rowIndex][rColumn.Name] = expValue;
}
}
}
}
private void SetUpCells()
{
#region MatrixColumns
{
MatrixColumns.Clear();
double sumColWidthInMillimeters = 0;
foreach (ReportColumn reportColumn in ReportDataColumns)
{
if (reportColumn is ReportDataColumn)
{
ReportDataColumn reportDataColumn = reportColumn as ReportDataColumn;
Unit _widthOfColumn = reportDataColumn.HeaderStyle.Width;
RMatrixColumn matrixColumn = new RMatrixColumn();
matrixColumn.Width = _widthOfColumn;
MatrixColumns.Add(matrixColumn);
sumColWidthInMillimeters += MeasureTools.UnitToMillimeters(_widthOfColumn);
}
else if (reportColumn is ReportHyperlinkColumn)
{
}
}
Item.Width = new Unit(sumColWidthInMillimeters, UnitType.Mm);
}
#endregion
#region MatrixRows
this.MatrixRows.Clear();
RMatrixRow matrixRow1 = new RMatrixRow();
{
matrixRow1.Height = new Unit(0.25, UnitType.Inch);
RMatrixCell mCell;
foreach (DataColumn dataColumn in SourceDataTable.Columns)
{
mCell = new RMatrixCell();
ReportControlItem rDataTableItem;
int columnIndex = SourceDataTable.Columns.IndexOf(dataColumn);
int reportItemZIndex = columnIndex + 1;
ReportColumn reportColumn = reportDataColumns[columnIndex];
if (reportColumn is ReportDataColumn)
{
ReportDataColumn reportDataColumn = reportColumn as ReportDataColumn;
if (this.reportTableGroups.ContainsColumn(reportColumn))
{
rDataTableItem = new RTextBox(string.Empty);
}
else
{
rDataTableItem = GetReportCellControlItem(reportDataColumn);
//if (rDataTableItem is RTextBox)
//{
// (rDataTableItem as RTextBox).Value =
// string.Format("=CDbl(Fields!{0}.Value)", reportDataColumn.Name);
//}
//=Sum(CDbl(Fields!Sales.Value))
}
mCell.ReportItem = rDataTableItem;
matrixRow1.MatrixCells.Add(mCell);
}
else if (reportColumn is ReportHyperlinkColumn)
{
}
}
}
this.MatrixRows.Add(matrixRow1);
#endregion
}
