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?
Answers were Sorted based on User's Feedback
Answer / rizwan
hi buddy use ?promptname? in sql
|Is This Answer Correct ?||6 Yes||1 No|
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
|Is This Answer Correct ?||1 Yes||2 No|
What is difference between drill through and drill down?
How do you test the reports? Explain the Unit testing procedures after developing the reports?
What is called materialized view?
Cleared COG-112 with 100% score today. What next certification should i go for?
5. Which type of report you build more, list, crosstab or chart and why?
How do you test the performance of a report?
difference between boxtype and visiable
-----------Types of Fact Tables?
What is difference between page break and section report?
------------------What is Inline Query?
wat is called Model dimension?
how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?