D365 Finance & Operations and Dynamics AX Forum

Expand all | Collapse all

Management reporter Totals row is blank

  • 1.  Management reporter Totals row is blank

    TOP CONTRIBUTOR
    Posted May 26, 2019 04:29 PM
    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


  • 2.  RE: Management reporter Totals row is blank

    GOLD CONTRIBUTOR
    Posted May 28, 2019 11:13 AM
    ​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
    ------------------------------



  • 3.  RE: Management reporter Totals row is blank

    TOP CONTRIBUTOR
    Posted May 29, 2019 11:42 PM
    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



  • 4.  RE: Management reporter Totals row is blank

    GOLD CONTRIBUTOR
    Posted Jun 04, 2019 09:37 AM
    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
    ------------------------------



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