tara1367
چهارشنبه 16 اسفند 1391, 10:04 صبح
سلام دوستان
من در برنامم از گزارش گير پويا stimulsoft استفاده كردم و تعريف جدول و يا ارسال پارامتر و ... را با كد انجام دادم ولي نمي دونم چطور ميتونم صفحه بندي،تعيين شماره رديف در جدول و همچنين margin رو با كد بفرستم.
با تشكر
اينم كد ارسال مقادير به گزارش:
private void PrintDataGrid(DataGridViewX sender)
{
DataView dataView = (DataView)sender.DataSource;
StiReport report = new StiReport();
report.ScriptLanguage = StiReportLanguageType.CSharp;
//Add data to datastore
report.RegData("view", dataView);
//Fill dictionary
report.Dictionary.Synchronize();
StiPage page = report.Pages.Items[0];
page.Orientation = StiPageOrientation.Landscape;
page.Name = "ليست كارمندان";
//Create Table
StiTable table = new StiTable();
table.Name = "Table1";
table.AutoWidth = StiTableAutoWidth.Table;
table.AutoWidthType = StiTableAutoWidthType.FullTable;
table.ColumnCount = sender.ColumnCount;
table.RowCount = 2;
table.HeaderRowsCount = 1;
table.FooterRowsCount = 0;
table.Width = page.Width;
table.Height = page.GridSize;
table.DataSourceName = "view" + dataView.Table.TableName;
page.Components.Add(table);
table.CreateCell();
table.TableStyle = StiTableStyle.Style32;
int indexHeaderCell = sender.ColumnCount - 1;
int indexDataCell = sender.ColumnCount * 2 - 1;
int n = 0;
foreach (DataColumn column in dataView.Table.Columns)
{
//Set text on header
StiTableCell headerCell = table.Components[indexHeaderCell] as StiTableCell;
headerCell.Text.Value = sender.Columns[n].HeaderText;
headerCell.Border = new StiBorder(StiBorderSides.All, Color.FromArgb(0, 0, 0), 0, StiPenStyle.Solid);
headerCell.HorAlignment = StiTextHorAlignment.Center;
headerCell.VertAlignment = StiVertAlignment.Center;
headerCell.WordWrap = true;
headerCell.Font = new System.Drawing.Font("B Nazanin", 7F, System.Drawing.FontStyle.Bold);
headerCell.Height = 3;
StiTableCell dataCell = table.Components[indexDataCell] as StiTableCell;
dataCell.Text.Value = "{view" + dataView.Table.TableName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.R eplaceSymbols(column.ColumnName) + "}";
dataCell.Border = new StiBorder(StiBorderSides.All, Color.FromArgb(0, 0, 0), 0, StiPenStyle.Solid);
dataCell.ShrinkFontToFit = true;
dataCell.HorAlignment = StiTextHorAlignment.Center;
dataCell.VertAlignment = StiVertAlignment.Center;
dataCell.Font = new System.Drawing.Font("B Nazanin", 10F, System.Drawing.FontStyle.Regular);
indexHeaderCell--;
indexDataCell--;
n++;
}
report.Render(false);
report.Show();
}
من در برنامم از گزارش گير پويا stimulsoft استفاده كردم و تعريف جدول و يا ارسال پارامتر و ... را با كد انجام دادم ولي نمي دونم چطور ميتونم صفحه بندي،تعيين شماره رديف در جدول و همچنين margin رو با كد بفرستم.
با تشكر
اينم كد ارسال مقادير به گزارش:
private void PrintDataGrid(DataGridViewX sender)
{
DataView dataView = (DataView)sender.DataSource;
StiReport report = new StiReport();
report.ScriptLanguage = StiReportLanguageType.CSharp;
//Add data to datastore
report.RegData("view", dataView);
//Fill dictionary
report.Dictionary.Synchronize();
StiPage page = report.Pages.Items[0];
page.Orientation = StiPageOrientation.Landscape;
page.Name = "ليست كارمندان";
//Create Table
StiTable table = new StiTable();
table.Name = "Table1";
table.AutoWidth = StiTableAutoWidth.Table;
table.AutoWidthType = StiTableAutoWidthType.FullTable;
table.ColumnCount = sender.ColumnCount;
table.RowCount = 2;
table.HeaderRowsCount = 1;
table.FooterRowsCount = 0;
table.Width = page.Width;
table.Height = page.GridSize;
table.DataSourceName = "view" + dataView.Table.TableName;
page.Components.Add(table);
table.CreateCell();
table.TableStyle = StiTableStyle.Style32;
int indexHeaderCell = sender.ColumnCount - 1;
int indexDataCell = sender.ColumnCount * 2 - 1;
int n = 0;
foreach (DataColumn column in dataView.Table.Columns)
{
//Set text on header
StiTableCell headerCell = table.Components[indexHeaderCell] as StiTableCell;
headerCell.Text.Value = sender.Columns[n].HeaderText;
headerCell.Border = new StiBorder(StiBorderSides.All, Color.FromArgb(0, 0, 0), 0, StiPenStyle.Solid);
headerCell.HorAlignment = StiTextHorAlignment.Center;
headerCell.VertAlignment = StiVertAlignment.Center;
headerCell.WordWrap = true;
headerCell.Font = new System.Drawing.Font("B Nazanin", 7F, System.Drawing.FontStyle.Bold);
headerCell.Height = 3;
StiTableCell dataCell = table.Components[indexDataCell] as StiTableCell;
dataCell.Text.Value = "{view" + dataView.Table.TableName + "." + Stimulsoft.Report.CodeDom.StiCodeDomSerializator.R eplaceSymbols(column.ColumnName) + "}";
dataCell.Border = new StiBorder(StiBorderSides.All, Color.FromArgb(0, 0, 0), 0, StiPenStyle.Solid);
dataCell.ShrinkFontToFit = true;
dataCell.HorAlignment = StiTextHorAlignment.Center;
dataCell.VertAlignment = StiVertAlignment.Center;
dataCell.Font = new System.Drawing.Font("B Nazanin", 10F, System.Drawing.FontStyle.Regular);
indexHeaderCell--;
indexDataCell--;
n++;
}
report.Render(false);
report.Show();
}