Suppress budget column in drill-down MR financials

(0) Share

Report

Posted on by Community Member

I have a standard budget to actual income statement with three columns (budget, actual, variance). I'd like to allow viewers to drill down on the actual column for revenue & expense lines to see view the transaction level detail. I set up ATTR columns in the column definition, but the presence of the budget column is distorting the drill-down view. Is there a way to suppress the budget column on the drill-down view, but still have it show on the original income statement view? thank you!

*This post is locked for comments

All responses (4)

Answers (1)

Community Member on at

Like (0)

Report

RE: Suppress budget column in drill-down MR financials

Much better, thanks again!
Verified answer

Leahs on at

Like (0)

Report

RE: Suppress budget column in drill-down MR financials

In the Report Definition's > settings tab > check display blanks for zero amounts.
Community Member on at

Like (0)

Report

RE: Suppress budget column in drill-down MR financials

Using version 2.1, thank you for your suggestion. The addition of the calc column did indeed take out the transaction detail on the drill-down page. I was hoping that the calc column would not show at all on the drill down page, instead it shows all zeroes. But it is a good solution.
Leahs on at

Like (0)

Report

RE: Suppress budget column in drill-down MR financials

What is the version of Management Reporter?

With Management Reporter CU 9 (2.1.9011.11) using a FD/YTD column did not show the Transaction detail.

If using Management Reporter CU 9 with a FD\Periodic column an option could be to use a Print Control of NP on the Column and then create a Calc column with a Formula of the previous column. The Calc column will not show the Transaction detail.