I didn't know exactly where to put this but I discovered something unique about our situation with using Telerik RadGrid and export to PDF in SharePoint 2010. I am only posting this because I could not directly find the information that we needed but got clues as to what I needed to do, so I thought I would share my experience with others.
Our circumstances:
- We were using a customized SharePoint 2010 setup.
- Our data was being automatically exported and updated by Active Directory each night.
- All data was being exported into SharePoint lists.
Our Issue:
When we would attempt an export to PDF and we were setting the "ignorepaging" to true (as suggested in numerous posts), but we were still getting a Telerik error message. Doing searches through the system did not give us the exact resolution to the problem so alot of troubleshooting went on to resolve it.
Our Resolution:
- When using a RadGrid in a SharePoint 2010 webpart, check to see if you have a sizing limit as to the number of rows returned per page. This was true for us because of the amount of data we were pulling and we were limiting the max rows per page to 75 rows and we had close to 300 rows or so being pulled into our RadGrid.
- If the above is true, when you export to PDF, you need to set your controls for the look and feel of the pdf, then before you send it to the pdf, ensure that you "rebind" the data prior to exporting it. This is essential, if you have paging enabled in the RadGrid but you are setting "ignorepaging" to true.
Example:
myDataList.ExportSettings.ExportOnlyData =
false
;
myDataList.ExportSettings.IgnorePaging =
true
;
myDataList.ExportSettings.OpenInNewWindow =
true
;
myDataList.ExportSettings.FileName =
"Some_Name"
;
myDataList.ExportSettings.Pdf.PageWidth = 1200;
myDataList.Rebind();
myDataList.MasterTableView.ExportToPdf();