Last post Apr 29, 2011 09:56 PM by chohmann
Apr 19, 2010 04:27 PM|Ben Aminnia|LINK
I have an rdlc report based on a one-to-many relation between two tables which renders fine within our asp.net 3.5 site.
Regarding its export features:
Export to PDF in fine.
Export to Excel, however, creates a separate tab (Excel sheet) for each page break. How can I change this behavior and make it export the entire report into one Excel sheet?
rdlc (Report) export to Excel
Apr 19, 2010 09:11 PM|rossman308|LINK
I use something like this to select the sheet:
Set objSheet1 = objWorkbook.Worksheets(1) objSheet1.Name = "One" Set objSheet2 = objWorkbook.Worksheets(2) objSheet2.Name = "Two" objWorkbook.Worksheets(3).Delete
Apr 19, 2010 10:01 PM|Ben Aminnia|LINK
This doesn't address my issue, because I'm using the export feature of rdlc, so the generated Excel file is not under my control.
I'm looking for some feature in the rdlc file which changes its export behavior.
Aug 04, 2010 01:11 PM|pbrophy|LINK
I have the same issue. How do I get around this "interesting feature"?
I suppose I can set any objects that force a page feed to Hidden in the rdlc based on a parameter passed in.
That will have to suffice for now.
Apr 29, 2011 09:56 PM|chohmann|LINK
The following article indicates that you can disable soft page breaks by setting InteractiveHeight to 0.