Reports are not showing up in the Reports workspace after installation and provisioning. Some show up, but not all of them.

Version 1

    Details

    Reports are not showing up in the Reports workspace after installation and provisioning. Some show up, but not all of them.

    All reports can be run successfully from the Report List dashboard, and all Report Templates are visible, but the reports are not accessible by any role.

     


    Resolution

    Even if the reports are published to all roles, there is a flag in the database that can prevent them from being displayed. This field is named 'UnLocked'.


    Run the following SQL update statement on the application database;
    Update frs_def_reports
    Set UnLocked =1
    Where UnLocked = 0

    If you then refresh the Report workspace in the application, reports will now be visible to the Roles they are published to.