Overview
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.
Cause:
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:
-
Open the report and place it in Design Mode
-
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)
-
Run the report
-
Save the report in Report mode
Comments