Dynamics Community Forum Thread Details

Management Reporter Consolidation of Departments for multiple entities

Here is my scenario, I have multiple companies and each company has a listing of departments (which are predominantly the same) and I want to be able to provide a departmental manager a report of all of their departments by entity.

I created a tree in management reporter that looks like this to start

Company Unit Name Unit Description Dimensions

@Any Consolidated Summary of all Units

@Any Corporate Corporate Dept. Department 100:150

LSLP Corporate_LSLP Corporate_LSLP Department 100:150

CGLP Corporate_CGLP Corporate_CGLP Department 100:150

This continues for the same department for all entities, and then I would select the next department and do the same thing, and each of the entities is a reporting unit under the summary Department heading. However when I run the report there is no data showing. I selected @Any as the company on the report definition as well. If I remove my tree and select a specific company the report works so I know it isn't anything from the row or column definition.

Please Help what am I missing here?

Thank you

Lonnie

Quick Links

Leaderboard