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

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

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

(0) ShareShare
ReportReport
Posted on by 282

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

  • Suggested answer
    Arcadi Profile Picture
    796 on at

    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
    Microsoft Employee on at

    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
    282 on at

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

  • Hayan Said Profile Picture
    282 on at

    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
    282 on at

    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

Season of Sharing Community Challenge Winners!

Congratulations to our community stars!

Women in Power Builds Momentum

Expanding mentorship, skilling, and AI innovation

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 274 Super User 2026 Season 2

#2
Aayush Tiwari Profile Picture

Aayush Tiwari 219

#3
Subra Profile Picture

Subra 202 Super User 2026 Season 2

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans