Finance | Project Operations, Human Resources, ...

Management Report designer Repeat Each line

(1) Share

Report

Posted on by BassFad

123

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 !

All responses (3)

Answers (0)

Suggested answer

Kevin Xia Microsoft Employee on at

Like (0)

Report

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

Like (0)

Report

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... 46,215 Super User 2024 Season 2 on at

Like (0)

Report

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.