Export a Report to Excel with Images in the Header and Footer

You can insert multiple static images in the report header and footer and have the images rendered in the Excel report output. This can provide a useful way to include the company logo, for example.

You can save your reports as Excel with Format in Impromptu or you can publish them to Impromptu Web Reports and then save them with this format.

Steps

1. Open a report in Impromptu.

2. From the Insert menu, click Picture Frame and with the pointer draw a frame in the header, and then, in the Picture Properties dialog box, specify the image to use. Click OK.

   To add an image to the footer, repeat step 3 but create the frame in the footer instead.

   For more information about adding static images to a report, see Impromptu User Reference.

3. From the File menu, click Save As, and save the report as Excel with Format (*.XLS) or Excel with Format (*.XLSX).

   You are warned if there are any problems with the report output if you have warnings messages set to show in the Report Properties dialog box.

4. Open the report in Excel.

   To view the header and footer, from the File menu, click Page Setup and click the Header/Footer tab.

   To see how the header and footer appears on the report page, from the File menu, click Print Preview.