locked
RDLC export to Excel RRS feed

  • Question

  • User-587630019 posted

    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?

    Monday, April 19, 2010 4:27 PM

All replies

  • User1045943723 posted

    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

    More expalantion:

    http://www.4guysfromrolla.com/ASPScripts/PrintPage.asp?REF=%2Fwebtech%2F051502-1.shtml


    Monday, April 19, 2010 9:11 PM
  • User-587630019 posted

    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.

    Monday, April 19, 2010 10:01 PM
  • User-902758937 posted

    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.

    Wednesday, August 4, 2010 1:11 PM
  • User-981899747 posted

    The following article indicates that you can disable soft page breaks by setting InteractiveHeight to 0.

    http://msdn.microsoft.com/en-us/library/ms251701

    Friday, April 29, 2011 9:56 PM