web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Row Definition Help
Microsoft Dynamics GP (Archived)

Row Definition Help

(0) ShareShare
ReportReport
Posted on by Community Member

Hello-

I'm trying to see if there is a way to "link" a row definition description field to already existing account descriptions.  We have 80+ facilities that are all assigned a unique facility number and name.  I'd like to create a row definition that automatically updates these facilities as they are added/deleted (IE...I don't want to have to key them all in).  Example:

Facility Number (Header)      Facility Name (Header)

001                                        Facility X

002                                        Facility Y

003                                        Facility Z

Obviously, I'm a MR novice so any help that can be provided would be greatly appreciated.

Thank you.

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    serbach Profile Picture
    serbach 571 on at
    RE: Row Definition Help

    Creating the initial set is easy. Start with a blank Row Definition and select Edit >> Insert Rows From Dimensions. You will then see a dialog box with a grid. The grid column headings represent the different segments of your account number (ours has just two: the natural account number "Account" and a department/entity segment, "Entity").

    The Account segment column will contain a string of &'s in the "Dimensions" row representing the number of characters in the Account number. The other columns will show strings of #'s, again, representing the number of characters in each segment. The #'s will be ignored, the &'s will be included in the Insert Row operation.

    In our company we have 125 or so Entities/Departments. So, to get a Row Definition filled in with one Entity on each row I first select the row of &'s under "Account" and click the "All ###" button. Then, under "Entity", I click the "All &&&" button. I adjust the Starting row code and the Increment to taste, and click OK. The finished dialog box looks like this:

    Back in the Row Definition, all of the Entity descriptions will now be listed, one to a row. To get the actual Entity segment number to appear on a report, I would add an "Acct" column to the Column Definition next to the Description column.

    Unfortunately, I don't know of a way to automagically add/delete your facilities as you suggest. I'm pretty sure that Management Reporter requires a fixed Row layout in order to create properly the drill-down links.

    Sincerely,

    Steve Erbach
    WOW Logistics Company
    Appleton, WI

  • serbach Profile Picture
    serbach 571 on at
    RE: Row Definition Help

    Sorry about no image appearing. I could paste a screen shot into my original reply, but it doesn't seem to have come through on the actual post.

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

News and Announcements

Join experts in person to explore low code and AI agents at the Power Platform Community Conference sponsored by Microsoft

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Congratulations to the September Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics GP (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans