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

Difference between "Design Mode" and "Report Mode"


Related Articles...


When referring to Jet reports, what is the difference between

"Design Mode" and "Report Mode"?


  1. Report Mode

    A report is is Report Mode when the report has been run (using either the Run or Run from Cache option) and the Go to Design button is displayed:


    Changes should not be made to a report while it is in Report Mode, as those changes will be lost as soon as the report is run.
  2. Design Mode

    When a report is being designed and the Design button is displayed...

    the report is referred to as being in "Design Mode".

    Only licensed Designers have direct access to Design Mode (that is, a report that has been saved in Report Mode can only be switched to Design Mode by a licensed Designer).

    Design Mode is used to create and make changes.  When the report is then run (and placed into Report Mode), the results of those changes will be reflected.

    While in Design Mode, Jet function results are optimized for speed and are not guaranteed to accurately reflect the results of all queries.  Use Report Mode to ensure you are viewing accurate data.

Note: when working with highly complex reports which Excel takes a long time to recalculate when first opening, it can be very beneficial to set cell A1 to AUTO+HIDE+VALUES and save the report in Report Mode.  More information can be found in the Knowledgebase article Introducing Report Viewers
Was this article helpful?
0 out of 0 found this helpful