Error : 'There are too many rows to output, based on the limitation specified by the output format (NETIQKB6195)

fact
Directory and Resource Administrator 6.x

fact
Directory and Resource Administrator 7.x

symptom
Error:  'There are too many rows to output, based on the limitation specified by the output format or by Directory and Resource Reporting'  when trying to export to an Excel spreadsheet.

cause

This issue is caused by a Microsoft Access limitation when trying to export to an Excel spreadsheet.  This limitation in Access is for backward compatibility.  Microsoft Access defaults to the Excel 5.0 specification, which is limited to 16,384 rows.

For more information see the following Microsoft Knowledge base article:  http://support.microsoft.com/default.aspx?scid=kb;EN-US;q201589 

fix

There are two workarounds for this condition:

1. Export the reports as a webpage and make the reports viewable from the web console.  Please follow the steps in this article for this process:
   
• How to Publish Reports in an HTML Format for Viewing in the Web Console
  
• https://www.netiq.com/kb/esupport/consumer/esupport.asp?id=NETIQKB1182
  
2. Filter the reports by domain so the number of rows exported are below the limitation.   Follow these steps to accomplish this:
   
• Launch the DRA reporting tool.
  
• Select Reports from the Menu bar.
  
• Select Filter by domain.
  
• Select Report on selected managed domain.
  
• Click on the desired domain.
  
• Click OK. 

Formerly known as NETIQKB6195