Management Reporter Link to Multiple other MR Reports

(0) Share

Report

Posted on by Community Member

I am trying to create links in one report to multiple other management reporter reports. When I do this as shown below only the first link works and the second column link (column K) is ignored. How can I get both, column J and column K links to work?

*This post is locked for comments

I have the same question (0)

All responses (18)

Answers (0)

Community Member on at

Like (0)

Report

Here is the screen shot referenced in my question...

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Sorry, but I guess my first question should be how do I paste a screen print?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jim,

Please try to save the screenprint as a file and upload it via the 'use rich formatting' window that can be accessed by hitting the button just below this text field.

Thank you.

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks, Ludwig, I think I finally uploaded the image with your help.

Was this reply helpful? Yes No
Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hello Jim Silver,

Have you actually created both reports to which you want to link your report to?

In addition, please check your column reference Setup and probably compare it whith what is described here:

blogs.msdn.microsoft.com/.../linking-to-another-management-reporter-report

Hope this helps,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I still haven't found an example of linking one report to multiple MR reports. My link works as long as I only link one report but doesn't recognize multiple links.

Was this reply helpful? Yes No
Suggested answer

Ludwig Reinhard Microsoft Employee on at

Like (0)

Report

Hi Jim,

I finally tested your Scenario and noticed the following:

To overcome this issue, I created a row structure with 3 columns; 2 of which refer to a workbook

Then I created a reporting tree that link to the different MR reports (in my case the Balance sheet and cash flow Statement)

Finally you have to ensure that the different columns of your reporting tree refer to the reporting tree elements.

Running the Report included the data from the Balance sheet and cash flow Statement.

If you do not want to show them in separate lines you can of course make use of non-printing columns/lines an summarize the data.

Yet, if you setup a similar structure things should work fine.

Best regards,

Ludwig

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Ludwig, thank you, this did work. One follow-up question to consider...if I was needing to bring in, for instance, 6 rows of information from 6 different reports and I wanted 12 monthly columns, would I need to create 72 (6x12) columns in the row definition file? It seems as though each row in the row definition file would require a new column for each month in order to utilize the correct cell reference for each month. Sounds like it is more difficult than it should be.

Thanks for your help, it is truly appreciated.

Was this reply helpful? Yes No