Mindmajix

Inline Prompt In Cognos

Inline Prompt

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 in the report page itself
  • Create a list report with the following query items
  • Product line
  • Product type
  • Product name
  • Quantity
  • Revenue
  • Group on 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 )

INLINE PROMPT

Screenshot_980

Screenshot_981

Screenshot_982

Screenshot_983

Screenshot_984

Screenshot_985

All value prompt:

  • Add the following query items to the list
  • Product line
  • Product type
  • Product name
  • Quantity
  • Revenue
  • Group on 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

ALL VALUE PROMPT

Screenshot_986

Screenshot_987

Screenshot_988

Screenshot_989

Screenshot_990

Screenshot_991

Screenshot_992

Screenshot_993

Screenshot_994

Screenshot_995

Screenshot_996

Screenshot_997

 

 

 


 

0 Responses on Inline Prompt In Cognos"

Leave a Message

Your email address will not be published. Required fields are marked *

Copy Rights Reserved © Mindmajix.com All rights reserved. Disclaimer.
Course Adviser

Fill your details, course adviser will reach you.