RDLC report with page breaks and export to excel RRS feed

  • Question

  • User363834793 posted

    Hi ,

    I have a requirement to develop a rdlc report and set the page size to 10 and when I export it to excel the data should come in a single sheet. 

    For the above requirement I developed a rdlc report and for page breaks I have created a new group and set the expression as below. =Int((RowNumber(Nothing)-1)/10). 

    Now the paging works but when I export the report to excel file(using the inbuilt functionality of RDLC report). For each page break it is creating a new work sheet.

    My requirement is to have data in a single sheet. Can anyone help how I can acheive it.

    Please let me know if you need any more information.


    Monday, July 2, 2012 4:25 AM

All replies

  • User-697637982 posted


    if you are only displaying data on Report not doing any changes then do this  Write a code which download data from dataset to Excel

    or Please Post your Question to  this forum



    Monday, July 2, 2012 6:21 AM
  • User363834793 posted

    Hi Sandip, 

    Thanks for the reply.
    I am not looking for custom export of data into excel file. I am looking to use the inbuilt export feature that is available with the rdlc reports.


    Monday, July 2, 2012 6:27 AM