Problem with excel filter and page breaks

Posted by: crueman on 4 August 2017, 2:50 pm EST

  • Posted 4 August 2017, 2:50 pm EST

    I have a report that I am wanting to export to excel.  I am trying to get the report to insert page breaks after every page.


    I have set genpagebreaks = true. 


    After exporting my report and opening it back up in excel, the page break is off one line for every page printed. I am using ver ar2StdSP2.4.0.1279. 


    I have included a screenshot from excel with the show page breaks option turned on.  Any ideas would be appreciated.


     


    2006/02/Problem.JPG
  • Replied 4 August 2017, 2:50 pm EST

    Can you please save your report output to the RDF format and attach it to this thread or e-mail it to me so that I can reproduce the issue here using your report? You can save the report to the RDF format by calling the .document.save method off of the report object.


    Ex.


    rpt.Document.Save(@"C:\Output.RDF");


    Thanks,

  • Replied 4 August 2017, 2:50 pm EST

    Thank you for the quick response.


    Here is the rdf file. 


    2006/02/2006.rdf
  • Replied 4 August 2017, 2:50 pm EST

    I am experiencing the same issue. Has there been a solution found to this problem?


Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels