Crystal report exports Excel multi-blank page incomplete solution

xiaoxiao2021-03-06  91

During the process of crystal report, I encountered the white pages of the air, I found it on 9CBS, I also found two posts asking this.

Question, but did not get the right answer. So I figured it out, I found a way, but I feel not the most perfect.

, I hope to have a friend who is proficient in this way to enlighten me. Thank you. Similar problems in 9cbs: http://community.9cbs.net/expert/topic/3305/3305114.xml? Temp = .8683435HTTP: //community.9cbs.net/expert/topic/3458/3458844.xml? Temp = .7499506HTTP: //community.9cbs.net/expert/topic/3178/3178158.xml? Temp = .637356HTTP: //community.9cbs.net/expert/topic/3248/3248381.xml? Temp = .3554804HTTP: //community.9cbs.net/expert/topic/3138/3138593.xml?temp=.1768915 http://community.9cbs.net/expert/topic/3203/3203522.xml?temp =.8826868 http://community. 9cbs.net/expert/topic/3178/3178028.xml?temp://community.9cbs.net/expert/topic/3467/3467509.xml?temp=.2149469 In fact these problems post, feel I didn't get a perfect answer, I studied the crux of finding problems.

In yogle, we have no way to control the width of the report content (content width attribute read-only), will not be in the printing process

Many blank pages, only when exported to the Excel document, use paging previews, we can find that each page corresponding to

There is a blank page in the right, you must manually adjust the page, otherwise you will double the blank

page. In fact, we can't do such a cumbersome thing, adjust the ExcelFormatoptions, and adjust the export.

A fixed width of a column. Specifically, ExcelFormatoptions ExcelFormatopts = New

ExcelFormatOptions (); // 'Set the excel format options excelFormatOpts.ExcelTabHasColumnHeadings = false;. ExcelFormatOpts.ExcelUseConstantColumnWidth = true; excelFormatOpts.ExcelConstantColumnWidth = 24.0; oRpt.ExportOptions.FormatOptions = excelFormatOpts; oRpt.ExportToDisk (ExportFormatType.Excel,

@ "F: /leadbridge/tests/report.xls"); ORPT.Close (); this exported Excel discovers the Excel content column is close, but the exported content is on one page, and it is also pressed. Actual page output. I don't know if the problem of 9CBS or above is not the same, I hope to help them.

转载请注明原文地址:https://www.9cbs.com/read-101043.html

New Post(0)