Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Microsoft Dynamics GP (Archived)

Management Reporter 2012 Reporting Tree: Departments--Not Companies

(0) ShareShare
ReportReport
Posted on by

Hello:

In Management Reporter 2012 CU13, I have a reporting tree pulling in all departments--one row for each department.

Also in each row, for the "Company" column, I have @ANY specified.

But, when I run the report, it is only pulling in data for the company that I'm logged in to--not for all companies.  I thought that pulling in data for any and all companies was, well, the function of @ANY.  I guess not.

Okay, then.  We have eighteen companies to report on.  And, we already have a separate departmental tree that has a branch for each company.

We simply want, instead, a consolidated tree for all departments across all companies.  If that cannot be done with @ANY, then how is it done?

It sounds like I'm going to have to have eighteen rows for each department.  That's ridiculous and is going to take forever to do.

I'm shocked that a simple consolidated departmental tree cannot be accomplished with @ANY.

Thanks, in advance, for any help!

Below is an excerpt from my current tree.

ANY.PNG

John

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    on at
    RE: Management Reporter 2012 Reporting Tree: Departments--Not Companies

    Disregard.  I accomplished this by exporting to Excel, sorting by department and company, creating eighteen rows per department, pasting back into the tree, and promoting accordingly.

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

Jainam Kothari – Community Spotlight

We are honored to recognize Jainam Kothari as our June 2025 Community…

Congratulations to the May Top 10 Community Leaders!

These are the community rock stars!

Announcing the Engage with the Community forum!

This forum is your space to connect, share, and grow!

Leaderboard >

Featured topics

Product updates

Dynamics 365 release plans