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 field set? what is the query calculation and layout calculation?

2 Answers   Syntel,

---

in reportnet how u burst the reports for every 5th day, 10 th day, 15 th day, 20 th day

2 Answers   IBM, iFlex, iGate,

---

What are types of batch available in cognos?

0 Answers  

---

What are the problems you have faced recently while developing reports in report studio? And how did you solve those problems? This question is asking in many interviews,,,,so pls help me,,,,,

2 Answers  

---

difference between stored procedure and function?

4 Answers   Syntel,

---

What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.

0 Answers  

---

How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)

4 Answers   Mphasis,

---

How do we create Links & Segments in Cognos Framework Manager?

1 Answers  

---

---------------What is meant by Scheduling?

2 Answers   IBM,

---

can any body clesrly explain about types of query subjects.that is data source query subject,model query subject,stored procedure query subjects?

1 Answers  

---

Define olap designer?

0 Answers  

---

Where do you edit cognos sql in report studio?

3 Answers   HCL,

---