You are not licensed to Design Reports...
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.
Related Articles
- Introducing Report Viewers
- What is a Designer? A Viewer? An Excel User?
- Difference Between "Design Mode" and "Report Mode"
- Jet Reports - Best Practices