First, we need to create a spreadsheet that contains a copy of the list block on the screen.
Select the Group Information object. Expand it, and select the group to which you wish to add the new spreadsheet entity.
Right click on the group and select
Create->Entity.
Click on the Spreadsheet
bullet.
In the Entity Name property, enter ITEM_MASTER_INQ_SS
Leave the Datasource set to (use default).
Set the Based On property to SPREADSHEET_TEMPLATE.
Set the Default Mode to Run Report.
Leave the Body
Style, Editable Field Style,
Non-Editable Field Style, Lov Style, and Link
Style properties set to (from parent).
Click on the Finish button. The new spreadsheet is added to the originally selected group.
Click on the Save
button in the main toolbar to save the new spreadsheet..
Expand the SCREENS group, and then expand the ITEM_MASTER_INQUIRY screen.
Right click on the ITEMS_CONTAINER (list) block.
Select Copy
from the menu.
Right click on the ITEM_MASTER_INQ_SS spreadsheet that you just created.
Select Paste
from the menu.
The block is added to the spreadsheet.
Click on the Save
button in the main toolbar to save the changes.
Now we need to create a button on the list mode of the ITEM_MASTER_INQUIRY screen that will generate the spreadsheet.
With the ITEM_MASTER_INQUIRY screen expanded, select the ITEMS (qbe,list) block.
Right click and select Create
-> Label from the menu.
Click on the Add button.
In the field,
enter SPREADSHEET.
Click on the Add Fields button at the bottom of the screen.
Expand the ITEMS (qbe,list) field and select the new SPREADSHEET field. Display the property sheet.
Set the Display As property to Button.
In the Field Style property, select DEFAULT_BUTTON.
In the Contents property, enter Generate Spreadsheet.
Set the On QBE property to false.
In the On
Mouse Click property, enter ExecuteReportInNewWindow('ITEM_MASTER_INQ_SS');
Click on the Save
button in the main toolbar to save the changes.
To test, select the ITEM_MASTER_INQUIRY
screen, and click on the Run 
button in the main toolbar.
The Preparing to Run
pop-up is displayed. Click on the Run
button.
The screen will be run in the browser.
Enter some query information and select Execute Search
on the left menu.
The list is displayed.
Click on the Generate Spreadsheet button to generate
the spreadsheet.
