Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Dynamics 365 Community / Forums / Microsoft Dynamics GP (Archived) / Management Reporter co...
Microsoft Dynamics GP (Archived)

Management Reporter conditional print control does not work

(0) ShareShare
ReportReport
Posted on by Patrick Chodulski 135

I am trying to build a rolling 12 months report where the most recent month shows first. So running for March, the report should show March, February and January, but no other months. Each month has:

- Actual column

- Budget Column

- Variance

- %

4 columns per month. The goal is to only print those months that have value. The report works, but PRINTS ALL THE PERIODS DESPITE MY RESTRICTIONS even without the value. I used the following column definitions:

Column Type: FD (except for CALC columns)

Book Code: Actual or Budget or blank for CALC columns

Fiscal Year: BASE (except for the CALC ) columns

Period: used specific period # in all FD columns

Periods Covered: Formula: only in CALC columns

Print Control: used P<=B, WT

How can i get the report to print only those periods that are before Base Period?

 

 

 

*This post is locked for comments

  • Community Member Profile Picture
    Community Member Microsoft Employee on at
    RE: Management Reporter conditional print control does not work

    I got it to work by adding the XO option (don't print if zero or blank).

  • simpleman Profile Picture
    simpleman 5 on at
    RE: Management Reporter conditional print control does not work

    Conditional printing still does not work.  I have an item that belongs in the assets of the balance sheet if it is a debit and the liabilities if it is a credit.  Setting the conditional print options to DR should print a row if the balance is a debit and CR should print if a credit but setting either causes the row to not print at all...   Unless the rules of accounting have changed, it either has to be a debit, a credit or zero.... and it's not zero.

  • Heather Roggeveen Profile Picture
    Heather Roggeveen 9,142 on at
    Re: Management Reporter conditional print control does not work

    I can't help with the answer on this - all I can say is that I am experiencing the same thing.  I think I have the latest version of MR (2.1.1028) and the conditional printing still does not work.

    Can anyone shed any light on this?

    Does anyone have it working?

    Could it be a regional issue?

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,269 Super User 2024 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 230,198 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans