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 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
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]
Stay updated with our newsletter, packed with Tutorials, Interview Questions, How-to's, Tips & Tricks, Latest Trends & Updates, and more ➤ Straight to your inbox!
Name | Dates | |
---|---|---|
IBM Cognos Training | Dec 02 to Dec 17 | View Details |
IBM Cognos Training | Dec 05 to Dec 20 | View Details |
IBM Cognos Training | Dec 09 to Dec 24 | View Details |
IBM Cognos Training | Dec 12 to Dec 27 | 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.
1 / 15
Copyright © 2013 - 2023 MindMajix Technologies