Editing Prompts in Reports

If the report contains prompts, you can choose to use the default prompts or change them after importing the report in Smart View.

Note:

Before you begin:

You should have imported the report as explained in Importing and Working with Fully Formatted Reports.
Save the workbook if there are changes that you want to keep. The workbook will be closed and regenerated when you edit prompts.

To change the prompts for an imported report:

In the Smart View ribbon, click Edit Prompts.
In the Edit Prompts dialog box, from the list of prompts present in the report, click Select next to the required prompt to open the Member Selection dialog box, make your prompt selection, and click OK.
You can reset a prompt selection by clicking next to a prompt. You can also click Reset All to reset and fetch the default selections for all prompts from your web application.
After you have edited all the required prompts, click OK in the Edit Prompts dialog box.

The sheets in the resulting workbook will appear in alphabetical order, just as they were listed in the Edit Prompts dialog box. You can manually reorder the sheets, if required.