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?
- 3 Answers
- 8566 Views
- ComNet, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / the_xxx
You can use the below macro (#prompt("dataitem")#)
| Is This Answer Correct ? | 2 Yes | 0 No |
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 |
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?
Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?
where exactly determinants are used in cognos framework manager?
17. How can we display tabs in the report Footer (Ex; PAGE 1 2 3 4 5...last)?
-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?
how to perform back drill through in cognos 8 what is the use of it
Can any one tell me cognos training class in chennai? thanks in advance...
What is a Pivot?
How to write the necessary TSQL to create data sets, pull the data sets in Cognos Report Studio WITHOUT using framework manager.
what is model and how to create model and how to test model?
Can any body suggest me that Drill through of packages is possible? If yes, how it can be done?
what is the difference between group and association?
Teradata 
