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?

Answer Posted / rizwan

hi buddy use ?promptname? in sql

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why cognos decision stream is used?

640


Explain is there any comparison available for cognos reportnet vs crystal reports?

547


What is the difference b/w macros and prompt?

598


What do you mean by Drill down and Drill Up?

574


Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com

1627






What is an olap designer?

532


how to explain health care project and which reports we can create in health care doain?

6358


I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt

1828


What errors and types of errors you faced in Cognos ReportNet?

3490


Why are meta service important then other services?

588


What are the types of catalogs in cognos?

677


-----------------What is Determination Model?

1694


How to generate cubes in cognos?

574


Can you define dimension?

641


i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

2257