D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Max Filesize - Save Reports to OneDrive or SharePoint

  • 1.  Max Filesize - Save Reports to OneDrive or SharePoint

    Posted 29 days ago
    Hello,

    Is there a way to generate D365FO reports and save them in Excel format to Onedrive, SharePoint, or a local network path? Is there any way to extract a report from D365 other than the standard output options: Screen, File, Printer, Email

    We generate a large financial report that exceeds the maximum filesize our Exchange server can handle. (Greater than 35MB). We use a recurring batch job to generate this report every night. Using email output s not an option, nor is screen or printer. The File option does not work with batch (a message appears stating that it will not work). Selecting the Print Archive toggle will only output the report in PDF format. We require Excel output.

    I would like to know if there is any other way to generate and extract this batched Excel report from D365. I'm open to ideas, however I would like the simplest possible solution if possible.

    Thank you very much for your input.


    ------------------------------
    Tim Khan
    Application Support Analyst
    DATA Communications Management Corp
    Brampton ON
    ------------------------------


  • 2.  RE: Max Filesize - Save Reports to OneDrive or SharePoint

    Posted 29 days ago
      |   view attached
    Here are my current output options.

    ------------------------------
    Tim Khan
    Application Support Analyst
    DATA Communications Management Corp
    Brampton ON
    ------------------------------



  • 3.  RE: Max Filesize - Save Reports to OneDrive or SharePoint

    Posted 8 days ago
    Hi Tim,

    You may try Docentric Free Edition which gives you options to send SSRS generated report to the File print destination, where you can choose among Azure storage, SharePoint or File system (the latter is applicable only in on-premise installations). This functionality is also supported in batch processing.

    ------------------------------
    Albin Lotric
    DOCENTRIC D.O.O.
    Kranj
    ------------------------------



If you've found this thread useful, dive deeper into User Group community content by role