We get asked quite a bit how to include information from one Management Reporter report on another Management Reporter report. This can be done in Management Reporter by using the link to Management Reporter worksheet option in the row definition. A few things to keep in mind when using this option:
Check out the video below see how it works.
I have a question, please. In your Row Definition for Net Income (the row linked column J) in Modified Balance Sheet, you have used the Column Restriction code of B. Does 'B' refer to the column in your Column Definition in Modified Balance Sheet where you use Book Code of either FD or WKS?. As the report in rendering, you are telling column B in the Modified Balance Sheet<>column definition to use the value in the linked cell instead of using the Book Code? I tried your method but kept getting a zero in my calculation.
In my own column definition, the Book Code is in Column C, so I used @WKS(c=d20) in my Row Definition.
Hope my question make sense. Thanks.
I think I fixed my own problem. In my report definition for my income statement, I had selected 'Financial, account, transaction' as my detail level. After the income statement was exported, I ended up with three worksheets. If I did not specify which one of three worksheet to use in my RowLink, MR picked a blank cell from one of the worksheets. I couldn't tell which worksheet MR ended up picking, but the cell it did choose was blank.
Once I changed the detail level to use 'financial', my RowLink worked.
I guess it was a good learning experience :-)