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

set scope level in transformer

2 Answers  

---

Define the slice and dice?

0 Answers  

---

Hi I have Columns A, B, C, D, E in a Crosstab Report, Cost Budget Column A Column B Column C Column D Column E Total of A+B+D+ E Product 1 100 200 300 400 500 1200 Product 2 500 300 400 500 800 2100 Column A Column B Column C Column D Column E is coming from the Query Item: Category I dont want to include C Column value in the Total Column Column Chas to display in the Crosstab Report how to achieve it Any idea Thanks Sumith

2 Answers  

---

What is Model Versioning or Versioning in Cognos Framework Manager?

2 Answers   Systime,

---

architecture of cognos8

1 Answers   IBM, Sonata,

---

---

What is the difference between static and dynamic conditions?

0 Answers  

---

how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

0 Answers  

---

If anybody need certification dumps like COG-112 COG-122 COG-132 THEN MAIL ME ON kris.bi121@gmail.com.all are latest dumps test taken on july-09

42 Answers  

---

A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?

1 Answers  

---

what is alias what is shortcut what ia alias shortcut and diff among them if u know explain clearly

2 Answers   TCS,

---

what is Galaxy schema??

2 Answers   IBM, iGate, Wipro,

---

can anybody tell me when do use 'running total'...give an example for the usage of running total

2 Answers   EDS,

---