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, ...
Suggested Answer

Management Report designer Repeat Each line

(1) ShareShare
ReportReport
Posted on by 155

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
    46,625 Moderator on at
    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
    171 on at
    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
    Microsoft Employee on at
    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

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

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

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 512 Super User 2026 Season 1

#2
Giorgio Bonacorsi Profile Picture

Giorgio Bonacorsi 386

#3
Adis Profile Picture

Adis 259 Super User 2026 Season 1

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans