Open Forum

Like what you see? Discover the benefits of the GPUG Community. Learn More

Management Reporter will not drill down to detail level

  • 1.  Management Reporter will not drill down to detail level

    Posted 6 days ago
    I built a report using Management Reporter, and then someone went in and clicked a bunch of buttons, now my report will not drill down to transaction level detail.  It says Summary, Account, and Transactions but it wont do it?? I have tried recreating the report and it wont work at all anymore?

    Here are my settings

    These are my settings




    ------------------------------
    Krista Politzer
    Silicon Valley Clean Water
    Redwood City CA
    ------------------------------


  • 2.  RE: Management Reporter will not drill down to detail level

    GPUG ALL STAR
    Posted 5 days ago
    @Krista Politzer,

    The first thing I noticed was that the Base Period and Base Year are in fiscal year 2019. Is your fiscal year from July to June?

    Do you generate the reports into the web viewer or the MR client viewer? You might try the client viewer (in MR Designer, Tools >> Options >> Use Management Reporter Report Viewer as default viewer).

    ​As a systematic kind of guy, I would have built the report from scratch, too. If that didn't work, as in your case, I would try running the original report with a reduced detail level like Financial & Account. If that doesn't work, then I'd start to wonder about rebuilding the datamart.

    Regards,

    ------------------------------
    "Sparkly" Steve Erbach - QMS Manager and Business Development Analyst
    GLC Minerals, LLC - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    GP 2016 R2 (16.00.0579) / MR 2012 CU16
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach
    2018-12-06_08_06_34-Mozilla_Firefox.jpg
    ------------------------------
    Welcome to Dynamics!
    You do not have permission.
    Call Steve.
    (hat tip: Lou Spevack)
    ------------------------------



  • 3.  RE: Management Reporter will not drill down to detail level

    GOLD CONTRIBUTOR
    Posted 5 days ago
    I'm pulling from memory but I'm pretty sure you can only get transaction-level detail if columns are periodic (versus YTD). If you want a YTD column with the ability to drill down to detail level, you'd have to create a periodic column and then put 1:Base in the period section.
    Let me know if this doesnt make sense. Also, maybe a screenshot of the column definition of the report in question would help.
    Thanks,
    Kyle

    ------------------------------
    Kyle Malone, CPA
    GP Admin - CGB Enterprises, Inc.
    Lead Consultant/Blogger - http://ALaCarteGP.com
    Chapter Leader - Louisiana (New Orleans)
    ------------------------------



  • 4.  RE: Management Reporter will not drill down to detail level

    GPUG ALL STAR
    Posted 4 days ago
    @Kyle Malone and @Krista Politzer,

    Kyle, that is an excellent catch!​​ It's been a while since I had to trouble-shoot an M-R problem like that; but that is exactly the point.

    Sincerely,

    ------------------------------
    "Sparkly" Steve Erbach - QMS Manager and Business Development Analyst
    GLC Minerals, LLC - Green Bay, WI
    Co-Chair, GPUG WI (Green Bay) Chapter
    GP 2016 R2 (16.00.0579) / MR 2012 CU16
    Blog: https://www.gpug.com/blogs/steve-erbach
    Twitter: twitter.com/serbach
    2018-12-06_08_06_34-Mozilla_Firefox.jpg
    ------------------------------
    Welcome to Dynamics!
    You do not have permission.
    Call Steve.
    (hat tip: Lou Spevack)
    ------------------------------