if we have a value prompt in a prompt page and if we need to pass that prompt

if we have a value prompt in a prompt page and if we need
to pass that prompt value to a sql used in report, what is
the sql code? give me example?

Question Posted / kumar

3 Answers
9695 Views
ComNet, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used ..

Answer / rizwan

hi buddy use ?promptname? in sql

Is This Answer Correct ?

6 Yes

1 No

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used ..

Answer / the_xxx

You can use the below macro (#prompt("dataitem")#)

Is This Answer Correct ?

2 Yes

0 No

if we have a value prompt in a prompt page and if we need to pass that prompt value to a sql used ..

Answer / mac

Suppose u have a prompt which has country code, u can use
that parameter in ur sqls to filter particular contry's
details.

Is This Answer Correct ?

1 Yes

2 No

Post New Answer

More Cognos Interview Questions

Hi, I am Searching on Cognos 8, If any experienced person can send out a project or explain a realtime scenario that would be very helpful for me. Please be kind towards me and help me in this regard. I am really finding difficult to find a person who can guide me in this feild. Your help will be highly appriciated. My email id is balajishriram@gmail.com. Hope you will help....

3 Answers Deloitte,

what is physical layer and presentation layer?

2 Answers Zensar,

3.User1 doveloped some report,user2 modify the same report and user 3 also updates in that same report? how to identify that report will be modified or not?

1 Answers IBM, Thomson Reuters,

Define metrics studio?

0 Answers

Write a SQL query which should fetch the 5th maximum salary of an employee from the table?

14 Answers HCL,

im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?

1 Answers IBM,

what is tabular set? how can you break the report?

1 Answers Syntel,

Helow, i have a problem with runing-total function when i use it for a calculate row (for example : i need to diplay a running-total of total units ?)

0 Answers

What do you understand by the term 'model durability'?

0 Answers

What are all the components of Report Studio?

0 Answers

how can i provide security to my reports in report studio?

3 Answers TCS,

Hi, I got a requirement wehre in in a drill through report , in parent report i have a column of numbers on which i have to apply drill through to child report.The condition is in that column if the number ia not zero the drill through link should appear (i.e., 1 to 9) if its 0 or negative number link should not appear. How ? Help would be appreciated

1 Answers IBM,

For more Cognos Interview Questions Click Here