Unified Operations & Dynamics AX Forum

Expand all | Collapse all

Management reporter Totals row is blank

  • 1.  Management reporter Totals row is blank

    TOP CONTRIBUTOR
    Posted 29 days ago
    HI All

    Started with a simple report: Trial Balance: containing 50000 rows. some how its not showing the last line which is TOTAL and the amount, although it shows single and double underlines

    any suggestion

    Thanks and kind regards
    AXUG Summit - Post


  • 2.  RE: Management reporter Totals row is blank

    GOLD CONTRIBUTOR
    Posted 28 days ago
    ​Without seeing your Row Definition (at least the last couple of lines) or your Column Definition, it is hard to troubleshoot.

    When you have the report open in MR, on the Settings tab, is the Other Formatting option of Display blanks for zero amounts marked or unmarked?

    Is the total line simply not showing or is it the fact that the Trial Balance is equal to (in total) $0.00?

    Thank you

    ------------------------------
    Sharon Nolan
    Senior ERP Business Analyst
    Bay Industries Inc.
    Green Bay WI
    ------------------------------

    AXUG Summit - Post


  • 3.  RE: Management reporter Totals row is blank

    TOP CONTRIBUTOR
    Posted 26 days ago
    Hi Sharon

    Trial balance report : Columns : Account #, description. balance. Last line where its TOTAL that line is blank only underlines are there. Where as using same Row definition and changed the column to reflect movement, this report reflect totals

    Here are the setting screen shot attached

    Thanks and kind regards

    AXUG Summit - Post


  • 4.  RE: Management reporter Totals row is blank

    GOLD CONTRIBUTOR
    Posted 21 days ago
    Hi Nazim.

    Odds are you have the checkbox unchecked on the Report Definition Settings tab that says "Display Rows with No Amounts". Check this box and in your Row Definition, use X0 as a Print Control on every row with an account reference. Do not use X0 on the Total Row.

    Alternatively, I probably would not have 50000 rows on my Row Definition. I would use one row with a range of account numbers (i.e. 100000:999999) and run the report with account-level detail to drilldown to the details. Less maintenance that way.

    See you in Orlando? I am teaching Management Reporter training classes on October 14th and 15th the two days prior to Summit. https://na.usergroupsummit.com

    ------------------------------
    Noah Moseley
    Senior Partner/Consultant
    MSX Group
    Pensacola FL
    ------------------------------

    AXUG Summit - Post


If you've found this thread useful, dive deeper into User Group community content by role