Inline Prompts in Cognos Report Studio

Introduction: inline prompt is a prompt embedded within a report, which is not prompted at run-time. User can directly select the values from the report output page to filter the records he wants to see.

Steps: 
a. Create a List report with the columns shown below.

b. Create another data item with the name Rank and add the below expression.

c. Apply Grouping on Sales Region and Aggregation on Revenue.

d. Add two block objects to the left-hand side of List. Insert a Text Item to the first block and add the description ‘Specify the Number of Rankings to View’. Drag a Text Box Prompt to the second block and create a parameter with the name p_Rank.

Note: inline prompts require a Prompt Button to submit the changes.

e. Drag a Prompt Button object to the right-hand side of the text box prompt.

f. Click on the created prompt and set the Type as Reprompt.

g. Click on Text Prompt and set the Required Property to No and Numbers Only  property to Yes and specify the value in Default Selection as 5.

h. Go to Query1 and add the prompt filter as shown below.

i. Select the prompt and set the Application property as After Auto Aggregation.

j. Run the report

 k. Change the value in the Text box Prompt to 3 and click on Reprompt button.