The Management Reporter team has spent a lot of time talking about the cool features in Management Reporter and how you can use it to create dynamic, powerful financial statements. Now, it’s time to start looking at advanced scenarios and how Management Reporter has an extended set of capabilities to handle them.
Every company has unique reporting needs, but there are two common scenarios we get questions on quite often.
Scenario 1: A company has many detailed reports, but would like a summarized report that just shows a few rows. These rows are often calculated and total rows.
Scenario 2: A company has complex reporting requirements and often needs to create a row with hundreds of lines to get to a final value they are looking for. If there is the need to report on the values at a higher level, it is cumbersome to create all the rows again in a master row definition.
The following is an option for handling these scenarios in Management Reporter. (Existing Microsoft FRx customers often refer to this method as ‘row linking.’)
There are multiple methods Phyllis (the accounting manager/report designer) can use to accomplish these scenarios. The method chosen depends on each company’s unique requirements. Here are five options:
1. Create the necessary row definitions and report definitions to obtain the values required.
Tip: Utilize Report Groups to generate them at the same time.
2. Use Dimension Sets to store the unique grouping of accounts and dimensions and combine them with the use of wildcards to get the desired results.
3. Create multiple Links to Financial Dimensions in the row definition.
Tip: This works great for consolidations or unique situations where account and dimension codes are different.
4. Create a row definition that has all the accounts, dimensions, and calculations necessary, and make the rows you do not want to print Non-Printing.
5. Link to other Management Reporter reports to pull in the required fields. This is my personal favorite!
Because #5 is my favorite and one of the great, powerful features of Management Reporter, let’s look at how to accomplish this in more detail.
In the following example, there is a partial detailed Income Statement. The key rows are:
This is done to easily identity the rows and is a helpful feature in Management Reporter.
The CFO wants a daily, summary Income Statement snapshot to review. Instead of maintaining a separate report, Phyllis is going to utilize her main detailed Income Statement and retrieve the values and calculations from this report.
First, Phyllis generates her detailed Income Statement.
Then, she creates a link to Management Reporter, specifies her Detailed Income Statement, and enters the cells of data.
Phyllis can also automate this process by creating a Report Group. Be sure to add the detail report first in the list. Each time you run the report and change the date, the first report will generate with details, and the second report will generate a summary report based on the data from the updated Management Reporter report.
Using this simple example, you can apply the concepts to any complex report where you require data dependent on another report.
Do you know if Microsoft offers an API for Management Reporter so that we can call reports programatically?
There is no API to call reports automatically. We will be offering report scheduling with the Management Reporter 2012 release.
The excel link is one way but beats the object of having everything centrally in a database. Really think row linking should be included but happy with the workaround to have a separate row set which is a duplicate of the detail but summarised.
hello, i have a question. i got some reports in frx that had a row format linked to another row format (not de accounting). In management reporter i have lost this capability? (or a i dont find it)
I am not sure I am making the connection between @WKS(B=56) and row "GP" in the detailed income statement. How does MR know to pull row "GP" when @WKS(B=56) is keyed into the "Link to Financial Dimension + Worksheet" column?
My gross porfit calc will not work although it appears to be coded accutartely in the row format. Any ideas why this is happening?
I would suggest you contact Support or your partner for help on a specific report. You also could post a question in community.dynamics.com with an example of what your report looks like and someone may be able to help.
Re: Grady's question above: Are the @WKS references to cells on the exported worksheet? If they are, then why is the Row Link to a Management Reporter report and not to an External Workbook?
When initially setting up the reports, you'll generate the detailed report and download it to Microsoft Excel to determine the cell references you want to use. Then, you'd update the summary report.
I know this is an old article, but are there any new suggestions of how to accomplish this type of report design and have it automated for Management Reporter 2012? There is unfortunately no longer an option to output directly to Excel. The suggestion of using a report group, or even to use two separate report schedules to generate both reports, will not work since the removal of the option to output directly to Excel.
Would Financial Dimensions work to replace the multiple row formats in a reporting tree functionality? It's missing from MR RU4 and I don't think it's in RU5 either. We have a lot of companies that we need to consolidate and a few of them have different account formats. -Thank you!
For different account formats across companies, you want to use multiple Links to Financial Dimensions. Here is a blog post about it: blogs.msdn.com/.../creating-consolidated-financial-statements-using-management-reporter-consolidating-data-across-one-or-multiple-dynamics-erps-with-different-chart-of-accounts-part-2-of-7.aspx
How did you determine cell reference in step #5, As example I created two row formats and then exported to excel to determine the cell reference, when I enter the cell reference in the second row definition, it seem to go up in step of 4. Totally confused. Would it be possible to get copy of your sample reports.
Thanking you in advance.
The more I am learning about MR the less happy I am. Sure this a workaround, but it is a really poor one. All it takes is for one line to be inserted in the row of the base report and all of your links are blown away OR a column used that has an additional line in the header. Row linking used a specific number so it was static.
I have a report with a row definition and a column definition. on my row definition, there is a spot for gross margin %; on my column definition (I have multiple columns) there is a formula that is adding all of the rows to get to a 'total' column. everything works great, except for when my total column is adding the gross margin % together, instead of taking into the consideration of the actual volume of items that relate to the %. is there a way that I can override that formula and possibly get it to the correct % in the total column but also keep the adding of the other columns in tact? anything will be helpful and I appreciate it.