Exporting Reports with Multiple List Frames to Excel

When you render a report containing several list frames, each list frame is exported to a separate worksheet. The list frame keeps the position it held in the Impromptu report. This may give unexpected results in Excel. For example, if you export a report containing two list frames, each list frame appears in a separate Excel worksheet in the same location as in the Impromptu report. White space fills the worksheet area where the other list frame existed before export.

To render multiple frames and avoid extra white space in a worksheet, try the following in Impromptu:

• Export the list frames without images, static charts, and text frames.

  Tip: From the Report menu, click Excel, and in the Include in Excel Worksheet box, clear the check box next to Images, Static charts, and Text frames.

  When you export the report, the Impromptu locations are ignored. Each list frame is positioned on a separate worksheet in the upper, left corner.