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
Define cognos report net?
What is a Framework manager?
1)diff between shortcut-key and alias table? 2)what is unit testing? 3)what is scorecard?
what are the features in cognos8ui
What errors and types of errors you faced in Cognos ReportNet?
How the Bursting happens in same report and how to Print the bursting Report?
In my report i want display sales rep name, country ,city how to achieve this by using repeater table
------------------What is Inline Query?
How can we import Excel data in to FWM?Wt is mean by Ragged dimensions?where can we observe the Regular dimensions & measure dimensions?
What is the size of database for you project?
What is the difference b/w macros and prompt?
how to develop dynamic dashboards, and what is the difference between static and dyanmic dashboards in report studion and need with example. plz mail me on this email id vasucognos4@gmail.com
What is the use of Cognos scenario?
I have created a database "TestingDB" in MS SQL Server 2005. I have set the port properties and the Cognos Service is up. But I don't see anything in the Cognos. In the administration i have set the ODBC connection and it tested successfully.If i copy the samples to the appropriate directory then i can see the samples.But I don't know how to do the same thing with my own database "TestingDB". As i have configure the cognos in my company which is having a database (very near to production database).I am a novice in cognos. Please help me out.
----------------------What are the User Securities?