Local Report - Excel - more than 65k rows.Any idea about multiple worksheets? RRS feed

  • Question

  • Hello,
    I have 131,000 rows for my local report.I am showing it in localreport.Now user wants to export this report to excel.
    I know that excel can't have more that 65,536 rows.
    I am thinking of dividing my records into more than 1 excel files,or more than 1 worksheet in single excel file.
    but how to do this?
    If you any other options,please let me know.
    I am using microsoft report viewer and local report.

    Thanks in advance,
    Jay Parikh.

    Wednesday, June 18, 2008 6:54 PM

All replies

  • well if you set a pagebreak in the table, the excel export will create a sheet based on every pagebreak. 

    For instance I pagebreak at the start of every group, and this creates one sheet in excel for every group.
    Living my life at 123mph in 11.15 seconds
    Thursday, June 19, 2008 1:14 PM
  • I can put that group wise,but there will be around 100 or more worksheets that way.
    Can i set manual page break in the table?
    For example,if somehow i can put page break after say 50,000 lines.


    Tuesday, June 24, 2008 5:52 PM
  • set the group expression  to   

    =(RowNumber(Nothing) - 1) \ 60000

    replace 60000  with however  many rows you want to have per sheet, and make sure you enable page break for the group.  I believe page breaking at the end will work fine....
    Living my life at 123mph in 11.15 seconds
    Tuesday, June 24, 2008 6:01 PM