Sign Up for Training |
insightsoftware Company Site
Submit a Request
Become a Jet Insider
Give Feedback

You are not licensed to Design Reports...


When someone - who is not a licensed report Designer - attempts to place a report in Design mode or attempts to run a report that is already in Design mode, an error message is displayed:


Complete text of error message is:

You are not licensed to Design reports. If you are a licensed Report Viewer, please tell your Report Designer that "Auto+Hide+Values" or "Auto+Hide+Lock" must be in cell A1 of at least one worksheet of this report the report must be saved in Report mode.


This error message is caused by not having a "+Values" or "+Lock" in cell A1 of at least one worksheet of a workbook containing Jet formulas (NL, NP, GL, NF).  Please see Introducing Report Viewers for additional information on preparing reports for Viewers.

Resolution Process

A licensed Designer must:

  1. Open the report and place it in Design Mode

  2. In cell A1 of any single sheet of the report, add +Values or +Lock  to make the cell contents either Auto+Hide+Values or Auto+Hide+Lock (using +Lock will also lock that specific sheet when the report is refreshed)

  3. Run the report

  4. Save the report in Report mode

Was this article helpful?
0 out of 0 found this helpful