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 is the difference between the standard and metrics folder?

0 Answers  

---

WHAT IS METRIC STUDIO?WHAT IS SCORE CARDS HOW TO IMPLEMENT IT AND WHAT IS THE USE OF SCORE CARD?

1 Answers   IBM,

---

-------What are the Adv of Star Schema and Snow Flake Schema?

4 Answers   Bank Of America,

---

we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?

2 Answers   Accenture,

---

plz anybody help me, how many reports we can create in one project?, and what are the names?in real time project at first what we will do?

2 Answers  

---

What is Index?

2 Answers  

---

A product manager is analysing the sales made for each product, he has requested a report containing data for specific products. To do this we will create a report that includes a prompt page that filters on specific products within specific product subcategory and category.

0 Answers  

---

How to limit the cut,copy and paste operations for an user in reportlevel? Can anyone please send me the steps as i am new to cognos?

0 Answers   Accenture,

---

What do you do to make a report result in showing 4 different regions in an xl sheet in individual sheets(like Region1-sheet1,Region2-Sheet2 soon)?

5 Answers   IBM,

---

Diff b/w Crossproduct and Outerjoin?

0 Answers   IBM, Mind Tree,

---

------Diff B/W DrillThrough and master and Detailed Report?

2 Answers   IBM,

---

Did you find any differences in bursting feature between reportnet 1.1 & cognos 8? what are the differences?

0 Answers  

---