EXCEL export page break doesn't work

Posted by: philippenaranjo on 4 August 2017, 3:13 pm EST

  • Posted 4 August 2017, 3:13 pm EST

    I have 2 problems,

    1)

    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.

    no page break is done

    2) I have lot of graph and JPG images sembedded in my reports and the images are dumped in the XLS file but they are hiding my data
    2008/11/Output.RDF
  • Replied 4 August 2017, 3:13 pm EST

    Thank you for your question. Could you please provide me with an RPX of the report provided? It appears there may be overlapping controls causing the overlapping issue. Also, please note that the Excel export is not 100% WYSIWYG, but for maximum control over the Excel export we offer a Spreadbuilder API to allow you to control how the report is exported. You can find some additional information about the use of the Spreadbuilder API here:

    http://www.datadynamics.com/Help/AR2Exports/HX_Using_the_SpreadBuilder_API.html

    http://www.datadynamics.com/Help/AR2Exports/HX_Working_with_SpreadBuilder_sheets.html

    Thanks,
        Eric

  • Replied 4 August 2017, 3:13 pm EST

    I atttached my report.


    2008/11/AcquisitionsBySite.zip
  • Replied 4 August 2017, 3:13 pm EST

    Thank you for your reply. It appears you do indeed have some overlapping controls in your report and this could be causing issues exporting to Excel. You can find some helpful information about the ActiveReports design rules here:

    http://www.datadynamics.com/forums/78647/ShowPost.aspx

    Also, please note if you are still unable to receive the desired results you may want to utilize the Spreadbuilder API previously mentioned.

    Thanks,
        Eric

Need extra support?

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

Learn More

Forum Channels