Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics GP (Archived)

MR suppress title row

Posted on by 4,150

hi folks

I want to suppress the title row of a section if the total of the section is zero

 

Below if row 520 = zero I want to suppress row 280 and 490. Is this done

 in the row format,

 on the report format with a checkbox or

  not possible?

 

thanks!

 

*This post is locked for comments

  • Keith Vogt Profile Picture
    Keith Vogt on at
    RE: MR suppress title row

    Hi Ian,

    You should be able to put row code "520" without the quotes into column D (Related Formulas/ Rows/ Units) for the Commodity Costs title in row code 280 and for row code 490.

  • Verified answer
    Ian Richardson Profile Picture
    Ian Richardson 4,150 on at
    RE: MR suppress title row

    answer my own question:

    office.microsoft.com/.../relating-a-format-row-to-an-amount-row-in-management-reporter-HA010248580.aspx

    if you relate row 280 and 490 to 520 then they will suppress along with 520 if the report is set to suppress zero rows.

    ian

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

Quick Links

December Spotlight Star - Muhammad Affan

Congratulations to a top community star!

Top 10 leaders for November!

Congratulations to our November super stars!

Tips for Writing Effective Suggested Answers

Best practices for providing successful forum answers ✍️

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 291,280 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,214 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans