Automatic selection and submission of values
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.
Getting ready
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.
How to do it...
We will start by wrapping the prompts within spans, so that they can be captured easily in JavaScript. Add one HTML tag before and one after each prompt to define Spans. Define the spans as...