سلام..مشکلی که دارم اینه که خروجی pdf من سطر آخررکودهای خروجی رو توی فایل pdf بر نمیگردونه.چک کردم dt من مشکلی نداره..میخواستم راهنمایی کنید..
کدهای من :
public IPdfReportData CreatePdfReport(DataTable dt,string OrganName,string DateFrom,string DateEnd,string FilePath)
{
FileStream fo = new FileStream(FilePath, FileMode.Create);
fo.Close();
return new PdfReport().DocumentPreferences(doc =>
{
doc.RunDirection(PdfRunDirection.RightToLeft);
doc.Orientation(PageOrientation.Portrait);
doc.PageSize(PdfPageSize.A4);
doc.DocumentMetadata(new DocumentMetadata { Author = "AjansDaneshjo", Application = "PdfRpt", Keywords = "Report", Subject = "Test Rpt", Title = "Report" });
})
.DefaultFonts(fonts =>
{
fonts.Path(Application.StartupPath+"\\BNAZANIN.ttf", Application.StartupPath + "\\BNAZNNBD.ttf");
fonts.Size(13);
})
.PagesFooter(footer =>
{
footer.DefaultFooter(PersianDate.ToPersianDateTime(DateTime.Now, "/", false, false));
})
.PagesHeader(header =>
{
header.CustomHeader(new MasterDetailsHeaders { PdfRptFont = header.PdfFont ,DateFrom=DateFrom,DateTo= DateEnd,ProjTitle=ProjTitle });
})
.MainTableTemplate(template =>
{
template.BasicTemplate(BasicTemplate.SilverTemplate);
})
.MainTablePreferences(table =>
{
table.ColumnsWidthsType(TableColumnWidthType.Relative);
table.NumberOfDataRowsPerPage(50);
table.GroupsPreferences(new GroupsPreferences
{
GroupType = GroupType.HideGroupingColumns,
RepeatHeaderRowPerGroup = true,
ShowOneGroupPerPage = true,
SpacingBeforeAllGroupsSummary = 5f
});
})
.MainTableDataSource(dataSource =>
{
dataSource.DataTable(dt);
})
.MainTableSummarySettings(summarySettings =>
{
summarySettings.OverallSummarySettings(" جمع کل ");
summarySettings.PageSummarySettings("جمع صفحه");
})
.MainTableColumns(columns =>
{
columns.AddColumn(column =>
{
column.PropertyName("rowNo");
column.IsRowNumber(true);
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(0);
column.Width(1);
column.HeaderCell("ردیف");
});
columns.AddColumn(column =>
{
column.PropertyName("Name_Family");
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(1);
column.Width(2);
column.HeaderCell("در اختیار");
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
});
});
columns.AddColumn(column =>
{
column.PropertyName("DateAjans");
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(2);
column.Width(2);
column.HeaderCell("تاریخ");
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : PersianDate.ToPersianDateTime((DateTime)obj,"/",false,false) );
});
});
columns.AddColumn(column =>
{
column.PropertyName("Receipt_number");
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(3);
column.Width(2);
column.HeaderCell("شماره قبض");
});
columns.AddColumn(column =>
{
column.PropertyName("Price");
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(5);
column.Width(2);
column.HeaderCell("مبلغ");
column.ColumnItemsTemplate(template =>
{
template.TextBlock();
template.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0}", obj));
});
column.AggregateFunction(aggregateFunction =>
{
aggregateFunction.NumericAggregateFunction(AggregateFunction.Sum);
aggregateFunction.DisplayFormatFormula(obj => obj == null ? string.Empty : string.Format("{0:n0} ریال", obj));
});
});
columns.AddColumn(column =>
{
column.PropertyName("Organ_Name");
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(5);
column.Width(2);
column.HeaderCell("نام سازمان");
column.Group(true,
(val1, val2) =>
{
return val1.ToString() == val2.ToString();
});
});
columns.AddColumn(column =>
{
column.PropertyName("Destination");
column.CellsHorizontalAlignment(PdfRpt.Core.Contracts.HorizontalAlignment.Center);
column.IsVisible(true);
column.Order(4);
column.Width(2);
column.HeaderCell("مقصد");
});
})
.MainTableEvents(events =>
{
events.DataSourceIsEmpty(message: "There is no data available to display.");
})
.Export(export =>
{
export.ToExcel();
})
.Generate(data => data.AsPdfFile(fo.Name/*string.Format("{0}\\RptCalculatedFieldsSample-{1}.pdf", Application.StartupPath, Guid.NewGuid().ToString("N")))*/));
} public class MasterDetailsHeaders : IPageHeader
{
public IPdfFont PdfRptFont { set; get; }
public string DateFrom;
public string DateTo;
public string ProjTitle;
public PdfGrid RenderingGroupHeader(Document pdfDoc, PdfWriter pdfWriter, IList<CellData> newGroupInfo, IList<SummaryCellData> summaryData)
{
var table = new PdfGrid(numColumns: 1) { WidthPercentage = 100 };
var organName = newGroupInfo.GetSafeStringValueOf("Organ_Name");
table.AddSimpleRow(
(cellData, cellProperties) =>
{
cellData.Value = " گزارش " + organName + " از تاریخ " + DateFrom + " الی " + DateTo;
cellProperties.PdfFont = PdfRptFont;
cellProperties.PdfFontStyle = DocumentFontStyle.Bold;
cellProperties.HorizontalAlignment = HorizontalAlignment.Center;
cellProperties.RunDirection = PdfRunDirection.RightToLeft;
});
return table.AddBorderToTable(borderColor: BaseColor.LIGHT_GRAY, spacingBefore: 5f);
}
public PdfGrid RenderingReportHeader(Document pdfDoc, PdfWriter pdfWriter, IList<SummaryCellData> summaryData)
{
return null;
} 
