Inline Prompt In Cognos

Inline Prompt 

The 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.

• The prompt which is created on the report page itself

• Create a list report with the following query items

• Product line

• Product type

• Product name

• Quantity

• Revenue

• Group on a Product line, Product type

• Total on Quantity, Revenue

• From toolbox

• Drag the value prompt/text prompt

• Drop on the report page

• Click on Next

• Choose the package item as Product line

• Click on OK

• Click on Next

• Click on Finish

• Run the report

(Note: If you want to delete the prompt, you have to delete the expression also )

Enroll for Instructor Led Live IBM Cognos Training PDF

Inline Prompt

All value prompt:

• Add the following query items to the list

• Product line

• Product type

• Product name

• Quantity

• Revenue

• Group on the product line

• Define total on quantity, revenue

• From Explorer bar

• Select page explorer

• Select prompt pages

• From tool box

• Drag the page and drop on the prompt pages window

• Double click on prompt page1

• From tool box

• Drag the text box prompt and drop on prompt page

• Select create a new parameter

• Enter the name

• Click on Next

• Select the package item as Product line

• Operator as =

• Click on Finish

• From tool box,

• Drag the text item and drop inside the Block

• Enter the text

• Enter Product line ore All value

• Click on OK

• From data menu

• Select filters

• From detail filter tabs

• Select the filter

• Click on Edit

• To the existing syntax

• Or ‘ALL’ = ?PROD_LINE?

• Click on OK — à  Save an run the report

• Click on OK

[Related Article: Cognos Interview Questions And Answers]