contents.gifprev1.gifnext1.gif

Selecting the Reports

When the Solver finds the solution to an optimization problem, or when the solution process is terminated prematurely due to some error condition (or your own intervention), the Solver Results dialog is displayed, as shown below.

lts00005.gif

If the solution process was terminated prematurely, the Reports list box in the dialog above will be greyed, and you will not be able to select any reports; you will need to re-solve and obtain an optimal solution in order to produce the reports.

When the Reports list box is available, you can select one, two, or all three reports. Simply click on the report names to select the reports you want, or press Alt-R and then down-arrow from the keyboard. In this setting, you don't need to hold down the SHIFT or CTRL key while you click on the report names with the mouse.

Once the reports are selected, you can choose one of the options "Keep Solver Solution" or "Restore Original Values." When you click on OK, the reports will be generated. Clicking on Cancel instead will cancel generation of the reports. The reports are 1-2-3 worksheets which are inserted in the current workbook, just after the sheet containing the Solver model.