Hai Mike,
I am using Infragistics 10.1. I have a user control to generate report using ultrawingrid. And i am generating the report dynamically by passing the query for datasource.
Using this report user control, I am generating a 2 band grid as report. In this report we have summary row. Everything in the report (grid) is fine. But when i try to export the content to a pdf, the summary row is missing.
I very well know that, the pdf export is WYSIWYG logic. That why i got confused. I am using more than 50 report like this. In all my report the summary is coming correctly. In this report only i got this problem. As this report generation is common, all properties are same to all reports. Please guide me to solve this problem.
I attached the screen shot below :
Report (Grid) Screen shot
PDF Export Screen Shot :
It looks like your summary in the grid is fixed on the bottom of the grid. Since this summary is fixed in the grid, it's not a part of any of the grid's rows collections, so that might be why it's not exporting.
In the other cases where this is working, is the summary also fixed to the bottom? Or are you using different SummaryDisplayAreas in those other cases?
Mike,
I gave the coding of two reports below to display the summary row. For the first report , the summary row is coming on PDF export. But for second it is not. I attached the screen shot of first report. Please guide me to solve the problem.
First report's Coding:
dim losum,losum1,losum2,losum3,losum4,losum5 as object with grdreport.displaylayout .InterBandSpacing = 0 .Appearance.FontData.Name = "Franklin Gothic Medium" .Appearance.FontData.SizeInPoints= 10 .Override.HeaderAppearance.FontData.bold=1 .Override.HeaderAppearance.FontData.Name= "Verdana" .Override.HeaderAppearance.FontData.SizeInPoints= 8 .override.headerplacement = 0 .bands(0).Summaries.clear losum=.bands(0).Summaries.Add("amount",1,.bands(0).columns("amount"),3) losum.DisplayFormat = "{0:##,##,##,##,###.00}" losum.SummaryDisplayArea = 16 losum.Appearance.TextHAlign = 3 losum5=.bands(0).Summaries.Add("Total",6,.bands(0).columns("partycode"),3) losum5.DisplayFormat ="Grand Total"
.bands(1).Summaries.clear losum2=.bands(1).Summaries.Add("amount",1,.bands(1).columns("amount"),3) losum2.DisplayFormat = "{0:##,##,##,##,###.00}" losum2.SummaryDisplayArea = 16 losum2.Appearance.TextHAlign = 3
Second Report's Coding :
-----------------------------------
dim losum,losum1,losum2,losum3,losum4,losum5,losum41,losum01,losum11,losum51 as objectwith grdreport.displaylayout
.InterBandSpacing = 0 grdreport.displaylayout.bands(0).Summaries.clear
losum4 = .bands(0).Summaries.Add("Grand Total",6,.bands(0).columns("accname"),3)
losum4.DisplayFormat ="Total" losum = .bands(0).Summaries.Add("debit",1,.bands(0).columns("debit"),3) losum.DisplayFormat = "{0:#,##,##,##,##,##0.00}"
losum.SummaryDisplayArea = 16 losum.Appearance.TextHAlign = 3
losum1 = .bands(0).Summaries.Add("credit",1,.bands(0).columns("credit"),3)losum1.DisplayFormat = "{0:#,##,##,##,##,##0.00}"losum1.SummaryDisplayArea = 16losum1.Appearance.TextHAlign = 3
losum5 = .bands(0).Summaries.Add("closing",1,.bands(0).columns("closing"),3)
losum5.DisplayFormat = "{0:#,##,##,##,##,##0.00}"losum5.SummaryDisplayArea = 16losum5.Appearance.TextHAlign = 3
losum41 = .bands(1).Summaries.Add("Total",6,.bands(1).columns("accname"),3)losum41.DisplayFormat ="Total"
losum01 = .bands(1).Summaries.Add("debit",1,.bands(1).columns("debit"),3) losum01.DisplayFormat = "{0:#,##,##,##,##,##0.00}"
losum01.SummaryDisplayArea = 16
losum01.Appearance.TextHAlign = 3losum11 = .bands(1).Summaries.Add("credit",1,.bands(1).columns("credit"),3)
losum11.DisplayFormat = "{0:#,##,##,##,##,##0.00}" losum11.SummaryDisplayArea = 16 losum11.Appearance.TextHAlign = 3
losum51 = .bands(1).Summaries.Add("closing",1,.bands(1).columns("closing"),3) losum51.DisplayFormat = "{0:#,##,##,##,##,##0.00}"
losum51.SummaryDisplayArea = 16 losum51.Appearance.TextHAlign = 3end with
Screen Shot of First Report :