Answer / sasi

Use render variable and static choices

Answer / ln

Hi,

Q:-Conditionally Select Country, City & Revenue in a
Report?
Render Variable:-

1.Drag List-Country, City & Revenue;

2.Go Page Explorer, Click on Prompt Pages, Drag page-->
Open Prompt Page;

3.Drag Value Prompt-name as Parm_StaticChoice;

4.Select V.P, in Properties Click on Static Choice - Add
Use&Display Values as Country-Country, City-City & Revenue-
Revenue, Click Ok;

5.Go Condition Explorer, Drag Boolean Variable--> Give
condition as Drag Parameter1 - ParamDisplayValue
('Param_StaticChoice') = 'Country' ;
--Drag Boolean Variable as -- ParamDisplayValue
('Param_StaticChoice') = 'City' ;
--Drag Boolean Variable as -- ParamDisplayValue
('Param_StaticChoice') = 'Revenue' -- Click Ok. ;

6.Add Values as Country, City & Revenue - Click Ok;

7.Go to page1 - Select Entire 'Country' Column - in
properties Render Variable as Boolean1, click ok, Curser
move on Condition Explorer select BOOLEAN1, Double click
on Green colour Vertical bar;

8.Select Entire 'City' - in properties Render Variable as
Boolean2, click ok, Curser move on Condition Explorer
select BOOLEAN2, Double click on Green colour Vertical
bar;

9.Select Entire 'Unit Cost' - in properties Render Variable
as Boolean3, click ok, Curser move on Condition Explorer
select BOOLEAN3, Double click on Green colour Vertical
bar; Save & Run Report.


Do u hve any queries get me in touch ln.cognosbi@gmail.com

What do you understand by the term 'dynamic cube'?

0 Answers  

---

How do you use SUM function in Reportnet?

3 Answers   IBM,

---

if ur report having report filter save the report.open u r report in cc the report filter doesnt work means it does n't any values what we do for this situation?where we rectify this?please please ans me......

0 Answers  

---

What is difference between content store and content manager?

0 Answers  

---

What is content store?

1 Answers   HCL,

---

what is the role of cognos comsultant?what actually it means?pls reply

0 Answers  

---

APPLYING COLORS TO ALTERNATE ROWS IN A LIST REPORT

5 Answers   Satyam,

---

how to merge 2 crosstabs thans

0 Answers   HCL,

---

10. In Report studio ,how to get the top 20 employees in using list report Row number – if only list  Rank  Running-count

1 Answers   Data Semantics,

---

How can I schedule reports in cognos?

0 Answers  

---

How to publish a package by running Java Script?

0 Answers  

---

what does my folder and public folder contains? difference between the my folder and public folder?

3 Answers   HCL,

---