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 OKSubscribe MindMajix YouTube Channel
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
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]
Name | Dates | |
---|---|---|
IBM Cognos Training | Oct 19 to Nov 03 | View Details |
IBM Cognos Training | Oct 22 to Nov 06 | View Details |
IBM Cognos Training | Oct 26 to Nov 10 | View Details |
IBM Cognos Training | Oct 29 to Nov 13 | View Details |
Ravindra Savaram is a Technical Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.