With a frameset, you can display multiple files in a frame or in one window. The files must be tagged before they can be used in the frameset.
To tag a file as a frame:
- In Designer, right-click a report that you want to use in a frameset.
- In the context menu, select Mark/Tag… > As frame.
To create a frameset:
- In Designer click New > New Frameset. The following window is displayed:
- Under Templates, arrange the frames horizontally, vertically, or in a custom arrangement. The custom option allows you to set the size for both horizontal and vertical frames.
- Set the number of rows and columns, depending on the template that you selected.
- On the sides of the frames, set the size of the frame. The following options are available both for width and height:
px Allows you to set the size in pixels. The size of the frame does not change with the screen settings. % Allows you to set the size in percentage. The size of the frame changes based on the size of the screen. auto The frames set on auto adjust their size based on the screen dimensions and the size of the other frames.
- Click Insert File. The files tagged as a frame are displayed. You can choose to insert the file and keep it marked as a frame for further use (Insert) or remove the tag after inserting the file (Insert and untag).
- You can change the frame properties by clicking Frame Properties button. The following dialog is displayed:
The checked options for the frame properties take effect only in user mode:
- Hide horizontal scrollbar: the horizontal scrollbar isn’t shown in the frame.
- Hide vertical scrollbar: the vertical scrollbar isn’t shown in the frame.
- Hide sheet selector: the sheet selector isn’t shown in the frame.
- Use for export: it can be established only one frame for export as xlsx-Snapshot or HTML. For PDF export, see below. Without any setting, the frame for the export will be randomly selected.
When defining a frameset, avoid loading duplicate files. Files loaded as frames in the frameset should not be defined as resource workbooks for another frame in the frameset at the same time.
By using a frameset, you can create comfortable report controls. See the article Example: Frameset.
You can handle named ranges and see a list of every named range set in the workbook by using the Name Manager. To access it, select a frame and go to Insert > Name…
Note: when you work in a frameset in Report Designer, you cannot use the Name Manager in one frame and select the ranges from another frame as a source.
Exporting framesets as PDFs
In a frameset, several frames can be selected to be exported as PDFs. You can select the frames to be exported in the frameset properties by checking them with the Use for Export option.
When opening a Frameset in Report Designer, the new dialog Frameset Page Setup allows content to be resized by percentage, in which case the content will be exported in the chosen page orientation and format, or by using the Fit to… option, which currently only allows the 1×1 setting. When used, the PDF will consist of a single page, showing the original size of the frameset content.
Note: print range settings from individual frames will be ignored if the PDF consists of multiple frames.
Some frameset configurations cannot be exported to PDF. Exporting one frame or all of the frames always works. For other combinations, make sure that the left-most frame in the horizontal plane is always included in the export. This allows the other frames to be exported as well.
For example, in a PDF export containing 2 x 2 framesets, exporting only the two frames on the right does not work.