How do I get the export to excel button to work for a report

merril
merril Member Posts: 38
Hi guys!

I need to change an existing report to export to excel when I click on the excel button on the screen. How do I go about doing this?

Thanks in advance.

Regards

Merril

Comments

  • Shedman
    Shedman Member Posts: 194
    You can't send a report directly to Excel ... You could create a form with the same data as the report and send that to Excel.
  • ara3n
    ara3n Member Posts: 9,258
    Or modify the report and use excel buffer table to export it to excel.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Savatage
    Savatage Member Posts: 7,142
    There's an Excel Buffer demo in the download section.

    Or You can save to HTML & open In Excel
    Or www.print2excel.com
  • David_Singleton
    David_Singleton Member Posts: 5,479
    merril wrote:
    I need to change an existing report to export to excel when I click on the excel button on the screen. How do I go about doing this?

    I understand your frustration Merril,

    This to me is one of those things that would take 20 seconds to fix. ](*,)

    WHY can't the Excel and Word Icons just gray out when they are not available. Since they seem to work, customers click and click and nothing happens and they call to say "But my export to excel doesn't do anything"

    Come on Microsoft just have those icons grayed out.... please....
    David Singleton