web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance | Project Operations, Human Resources, ... / Electronic Reporting i...
Finance | Project Operations, Human Resources, ...
Answered

Electronic Reporting is showing only one Record when I export to Excel

(0) ShareShare
ReportReport
Posted on by Hayan Said 280

Dear All,

I have setup an Electronic Report to generate Excel sheet and save it on SharePoint, I Have Followed up a Blog that was shared by Ludwig Reinhard link is below, however I am facing an issue that the Excel sheet is only Having one record.

https://dynamicsax-fico.com/2018/11/01/reserves-for-bad-debt/comment-page-1/#comment-22412 

Please see below Screen Shots for the Process that i have done.

I have Created an ER Node

pastedimage1615378169558v1.png

I have designed the module

pastedimage1615378209081v2.png

Mapped to Datasource

pastedimage1615378225990v3.png

Designed and Bind the Record List with the Required Table

pastedimage1615378283808v4.png

Created the Excel sheet designed it and Mapped it with the module

pastedimage1615378376901v5.png

however i am only getting one record which is the first record in the list. Any ideas what i might have done wrong.

Best

HAYAN

I have the same question (0)
  • Suggested answer
    Arcadi Profile Picture
    Arcadi 794 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Try linking the BadDebt recordlist to tabelle1, you should see the fields in the format (left) with a "@" this means they are inside the loop

  • Suggested answer
    Ludwig Reinhard Profile Picture
    Ludwig Reinhard Microsoft Employee on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Hello Hayan,

    In your second screenprint, I can see a Record List element and right below a record element.

    In screenprint No 4 the record element is not bound to anything.

    Can you please try the following:

    1. Get rid of the record element in your model (screenprint 2). The easiest way might be setting up things from scratch.

    2. Do the same setup for the other elements exactly as you have it and then in the model mapping bind the record list element to your custtransopen table.

    Best regards,

    Ludwig

  • Hayan Said Profile Picture
    Hayan Said 280 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Thx Arcadi, i tried it and it worked. Appreciate ur help.

  • Hayan Said Profile Picture
    Hayan Said 280 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Hello Ludwig,

    Thx for your help, I tried Arcadi Tip and it worked with me.

    Appreciate your help again.

    Best

    HAYAN

  • Hayan Said Profile Picture
    Hayan Said 280 on at
    RE: Electronic Reporting is showing only one Record when I export to Excel

    Dear Ludwig,

    I was trying the Above Scenarios with On premise D365 F&O. I am getting the error that

    Unable to communicate with SharePoint Server in the Document management parameter.  can we work your Solution using OnPremise Env?

    Best

    HAYAN

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
Martin Dráb Profile Picture

Martin Dráb 683 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 563 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 398 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans