Ok, this second part can be confusing. This is what I found to be a workaround (though its not ideal) for the functionality of the row linking in FRx. You can link an existing MR report as source data for a second MR report. First make sure that you don't have to insert any rows as this is unfortunately static cell referencing.
Generate your first report and export it out to excel. This is how you will know what cells and rows to link to.
You will need to either edit your existing report column or create a new one for just this report. The reason for this is that you will have to specify that the column type is a WKS (not a FD, coming from the GL). If you have multiple comparative periods, you will need the same number of additional WKS columns to represent the data for the summary.
On your summary row format, you will need to add a new Row Link. You can do this through the edit menu bar. The type is going to be Management Reporter Worksheet. Give it a name and description.
At this point I would cross reference the cells from you exported excel report (1st report) to this row format. So, for example, the Summary report may just have a Total Revenue line that sums all the revenue from A+B+C. On your exported spreadsheet that (for instance) may appear in cell B12 for current month, C12 for YTD, D12 for PYMTD ... etc.....
On your summary row format in the line for Total Revenue in the MR Worksheet link, you will put in B=B12, C=C12, D=D12 . The first letters before the = sign correspond to the destination column in Management Reporter. So if the first column in the COLUMN (uggh) is Description that is column A.... Then you want Current Month that is typically column B unless you are adding a Fill column between them. And following my above example C would be current month and D Prior Year MTD.
You would follow this format B=B12, C=C12, D=D12 (with however many periods you have in your columns) and paste this information into any row that needs actual financial data and is not itself a total, changing the '12' to the correct row number from your exported spreadsheet.
The last thing is to create a report group. This ensures that the Summary report represents "fresh" data and is not pulling from a prior generated version of the report. When creating the report group be sure to list the detail report first and the Summary second so it will be pulling fresh data.
You WILL not see the summary all in one report as you are accustomed to in FRx. You will have two reports one that lists it as you have it now and another in a summary format with the same data.
CAVEAT: If you insert rows you run the risk of blowing up your summary. It is very important that reports are properly managed and that everyone does not have access to change the reports.
A good habit to form is that when you are working on a report, that you export that reports building blocks to a .tdbx file. If they do not work as anticipated, you can re-import the .tdbx file and be back to where you started, no harm no foul.
I realize this is clear as mud, so feel free to ask away.....
Share
Report
All responses (
Answers (
95
