Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

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 / the_xxx

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

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by junk dimension?

1100


Is it possible to join multiple Databases in a Catalog?

1060


What is a Pivot?

1042


Can you define a datastore in cognos?

976


Explain what is the difference between native sql and cognos sql?

938


Write types of folders present in cognos?

1022


faq's on cognos

3999


how do you deploy a report in cognos 8 to run in maximo6? what r the steps in maximo??

2337


what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?

971


how u will design the report if the objects are available

2697


How can you link a query to a data container manually in Report Studio?

2305


What are the components used in web tier?

926


-------------What is Coditional Prompting?

2070


my table having data like this year month revenue 2011 jan 100 2011 feb 200 2011 mar 150 like this i want My report 2011 jan 100 2011 feb 100+200=300 2011 mar 300+150=450 like this for this where we specify the condition how will specify? pls ans me pls...

4126


Can you define cognos impromptu?

978