Skip to main content
Dynamics 365 Community / Forums / Finance forum / Management Report desi...
Finance forum
Suggested answer

Management Report designer Repeat Each line

editSubscribe (1) ShareShare
ReportReport
Posted on by 58

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 !

 

Attachments
  • 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
  • Maria Nastevska Profile Picture
    Maria Nastevska 77 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
    Frank Hamelly | MVP, MCP, CSA Profile Picture
    Frank Hamelly | MVP... 3,429 Super User 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.

Helpful resources

Quick Links

New Blog Features Released!

Check out the new community blog features for viewers and authors…

Setting Up Knowledge Sources for Copilot…

Look at how configuring a comprehensive knowledge base is crucial…

Demystifying Copilot with Georg Glantschnig…

Industry experts answer burning questions directly from our amazing Community…

Leaderboard

#1
Andre Arnaud de Calavon Profile Picture

Andre Arnaud de Cal... 283,130 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 222,689 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,138

Featured topics

Product updates

Dynamics 365 release plans