Subject: Subtotals and Grand Totals Showing Blanks in Discoverer Desktop Doc ID: Note:358707.1 Applies to: Oracle Discoverer - Version: 4.1.48.08 to 10.1 Microsoft Windows SymptomsSome of the report totals and subtotals are showing blanks/zeros while other reports gets aggregated correctly. SolutionFor Discoverer Desktop there is not pref.txt file to update. Discoverer Desktop makes use of the Windows Registry to store information. To implement the solution, please execute the following steps: 1. For discoverer desktop we need to edit the registry 2. Windows Start > run > regedit 3. First backup the registry patch we are going to change. 4. Highlight the key HKEY_CURRENT_USER\Software\ORACLE with your mouse or keyboard. 5. Right click on the HKEY_CURRENT_USER\Software\ORACLE entry. 6. Select the Export option. 7. Provide a file name where you want to backup the registry to. 8. Click Save. 9. Now add the following entries to the registry. Follow steps below. Discoverer Version Registry Key Path 4.1.48 HKEY_CURRENT_USER\Software\ORACLE\Discoverer 4\Application\ 10.1.2 HKEY_CURRENT_USER\Software\ORACLE\Discoverer 10\Application\ 10. Right click on the right hand side. 11. Select "New" > DWORD. 12. Set the name = AggregationBehavior. 13. Set the value = 1. 14. Again select "New" > DWORD. 15. Set the name = AllowAggregationOverRepeatedValues. 16. Set the value = 1. 17. Now restart the discoverer. 18. Open your workbook again. For Discoverer Plus and Viewer please follow Metalink Note:333521.1 - Subtotals and Grand Totals Showing Blanks in Discoverer Plus (Web) and Viewer NOTE: If you want to restore the registry file you saved: 1. Use Windows Explorer to navigate to the file. 2. Double click the file. 3. This action will import the file you exported.