Use summary levels from spreadsheet

Controls whether collapsed levels print on the report. You can include all levels regardless of the spreadsheet layout or just the visible levels. If you clicked [Prefill from spreadsheet] on the Report Options tab, Sage Estimating (SQL) automatically selects this option.

Setting Result

Prints all levels, regardless of the layout.

Prints levels exactly as shown.


Tip: Selecting this option changes the sort levels to match the current sequence of the spreadsheet.