A business report has numerous prompts on the prompt page. Often, users want to run a report for the latest month in the database, 'Camping Equipment' product and 'E-mail' as a order method.
They want a facility to either manually select vales for these prompts; or alternatively, run the report for the above selections on single button click.
In this recipe, we will add a custom button on prompt page that will allow users to quickly run the report for frequently used selections.
Create a list report with product line, order method, and sales quantity as columns.
Create optional filters on product line, order method, and Shipment Month that is, Month Key (Shipment Date).
Create a prompt page with three value prompts for these filters.