SAP Knowledge Base Article - Public

1768769 - Error: 'Unable to refresh report' when opening a report from the SAP BusinessObjects Repository, in Crystal Reports Viewer

Symptom

  • Unable to refresh report.
  • When opening a report in Crystal Reports Viewer saved without data or that have a dynamic parameter, it fails with the error:
       
    "Unable to Refresh Report. The report has missing parameter information but the server has disabled prompting.
      Please contact your server administrator."

    Error.PNG

Environment

  • SAP Crystal Reports Viewer 2008
  • SAP Crystal Reports Viewer 2011
  • SAP Crystal Reports Viewer 2013
  • SAP Crystal Reports Viewer 2016

Reproducing the Issue

  1. Launch Crystal Reports Viewer.
  2. Under the menu "File" select "Open from Default Server"
  3. Select a report that does not have saved or that have dynamic parameters.
      
    It then generates the error:
       
    "Unable to Refresh Report. The report has missing parameter information but the server has disabled prompting. Please contact your server administrator."

Cause

  • Crystal Reports Viewer can only view report with saved data, the exception is if you are opening a report in Crystal Reports Viewer from the SAP BusinessObjects BI Platform. The SAP BI Platform can refresh the report, and send the report with saved data to Crystal Reports Viewer. In this case, if you are receiving an error, it's because the prompting is disabled for the parameters of the report on the Enterprise Server.

Resolution

  • To be able to view the report, enable the parameter prompt when viewing the report on the SAP BusinessObjects Business Intelligence Platform server:
    1. Login to Central Management Console (CMC) with the Administrator account.
       
    2. Locate the report under Folders.
         
    3. Right click on the report and click on Default Settings.
       
    4. Click on Parameters.
       
    5. Check the option Prompt when viewing for all the parameters.
       
    6. Click on Save & Close.
       
    7. Open the report in Crystal Reports Viewer. 
         
      Now, it will prompt for the parameters and refresh the report.

Keywords

Unable to refresh report, crystal report viewer 2008, prompts, missing parameter information, disabled prompting , KBA , BI-RA-CRV , SAP Crystal Reports Viewer , Problem

Product

Crystal Reports Viewer 2008 ; SAP Crystal Reports Viewer 2011 ; SAP Crystal Reports viewer 2013 ; SAP Crystal Reports viewer 2016