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, ... / Management Report desi...
Finance | Project Operations, Human Resources, ...
Suggested Answer

Management Report designer Repeat Each line

(1) ShareShare
ReportReport
Posted on by BassFad 153

Hi,

Is there a more efficient method for generating a report that automatically displays, on each line (if different from zero), my main account and splits it across all departments? As illustrated below, currently, I have to manually create each line for every combination of main account with department.

 

Thanks !

 

I have the same question (0)
  • Suggested answer
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 46,623 Super User 2025 Season 2 on at
    Management Report designer Repeat Each line
    I'm not aware of a way to do this but you could create your lines in Excel, then copy/paste them into the row definition.  This would at least provide greater ability to create the strings formulaically.
  • Maria Nastevska Profile Picture
    Maria Nastevska 171 on at
    Management Report designer Repeat Each line
    Unfortunately I don't think there's any other way of doing this. What Frank suggested might be the queckest solution. 
     
    Alternatively, you can potentially consider a customized Report.
  • Suggested answer
    Kevin Xia Profile Picture
    Kevin Xia Microsoft Employee on at
    Management Report designer Repeat Each line
    Hi,
    There is no easy standard function that can be used out of the box, and it is not much simpler to operate in excel. You can customize it to suit your needs. If you don't have a developer, you can seek help from Microsoft partners who will provide you with customized services. Please refer to this link for details: Find the right app | Microsoft AppSource.
    Best regards,
    Kevin

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 724 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

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

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 400 User Group Leader

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

Product updates

Dynamics 365 release plans