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

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

Resolution

fact
Directory and Resource Administrator 6.60

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

symptom
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'.

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

cause
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.

fix

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

TO:

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



Additional Information

Formerly known as NETIQKB34609