Error message: 'No data is available for this report'. (NETIQKB34609)

  • 7734609
  • 02-Feb-2007
  • 19-Jun-2007


Directory and Resource Administrator 6.60

Error message: 'No data is available for this report'.

When publishing reports to html that contain no data, a generic HTML file is not being created with the message 'No data is available for this report'.

The HTML file is not created when publishing reports into HTML format if the report does not contain any data.

The cause of this is the error handling code does not make a call to replace the spaces with underscores so the URL is not correct.


This issue has been resolved in version 7.0 and later.  If the report published to HTML format does not have any data a generic HTML file is created that states 'No data is available for this report'

In order to resolve this issue in version 6.60, please perform the following steps:

  1. Launch the DRA reporting tool.
  2. From the File menu select Enter DesignMode.
  3. Select the Modules tab and double-click the Report Module.
  4. In the Visual Basic editor select PublishReport from the Declarations dropdown.
  5. Towards the bottom of the function, find the following code and replace it with the following below and save the changes.

If Dir(sOutput & "\" & sReport & ".html") = "" Then
         FileCopy sInstallHtmlPath & "\NoData.html", sOutput & "\" & sReport & ".html"
End If


If Dir(sOutput & "\" & ReplaceSpacesWithUnderscores(sReport) & ".html") = "" Then
         FileCopy sInstallHtmlPath & "\NoData.html", sOutput & "\" & ReplaceSpacesWithUnderscores(sReport) & ".html"
End If

Additional Information

Formerly known as NETIQKB34609