Microsoft Business Solutions-Axapta 3.0 is now part of Microsoft Dynamics AX 3.0. All references to Microsoft Business Solutions-Axapta and Microsoft Axapta pertain to Microsoft Dynamics AX.
Consider the following scenario:
From Microsoft Business Solutions - FRx, you export a report that has intersecting calculations to Microsoft Excel. The Calculation Priority option is set to Calculate Rows First. The Export Formulas worksheet option is turned on.
In this scenario, the totals of the intersecting calculations are incorrect in Excel.
In the Microsoft FRx DrillDown Viewer, the intersecting totals are correct.
To resolve this problem, obtain the latest service pack for Microsoft FRx 6.7. For more information, visit one of the following Microsoft Web sites, depending on whether you are a partner or a customer:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section. This problem was first corrected in Microsoft FRx 6.7 Service Pack 4.
To work around this problem, turn off the
worksheet option. The correct totals will be exported. However, no formulas will be exported. Therefore, you have to manually add the formulas in Excel.
Steps to reproduce the problem Click Start, click All Programs, click FRx 6.7, and then click Report Designer. On the File menu, click New, and then click Row. Create a row format with two GL rows and a TOT row that totals the two GL rows.
On the File menu, click Save, and then type a name for the row. On the File menu, click New, and then click Column. Create a column format with a DESC column, two GL columns, and a CALC column that divides one GL column by the other. On the File menu, click Save, and then name the new column. On the File menu, click New, and then click Catalog. Create your catalog by using the row and column formats that you created in steps 2 through 7. Click the Report Options tab, and then click the Advanced tab. For the Calculation Priority setting, click Calculate Rows First. Click the Output tab, and then click the Output Options tab. In the output list, click DrillDown Viewer (Enhanced XML). When the DrillDown Viewer opens, note the correct value in column D. On the File menu, click Export, click Worksheet Files, and then click Excel via OLE. On the File menu, click Save, and then type a name for the new file. In the Export Selection window, click to select the following check boxes, and then click OK: The Excel worksheet opens, and the intersecting totals are incorrect. Current Selection Activate Workbook Export Formulas
Article ID: 902625 - Last Review: March 14, 2013 - Revision: 4.0
Applies to Microsoft Business Solutions for Analytics–FRx 6.7 Desktop Microsoft Business Solutions–Great Plains 8.0 Microsoft Business Solutions–Great Plains 7.5, when used with: Microsoft Business Solutions for Analytics–FRx 6.7 Desktop Microsoft Business Solutions–Solomon 6.0 Microsoft Dynamics AX 3.0, when used with: Microsoft Business Solutions for Analytics–FRx 6.7 Desktop
kbmbsmigrate kbbug kbsolomonfrx kbsmallbusinessfinancialsfrx kbgreatplainsfrx kbaxaptafrx KB902625
Contact us for more help
Connect with Answer Desk for expert help.