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

Define cognos report net?

0 Answers  

---

What do you mean by Drill down and Drill Up?

0 Answers  

---

how u publish the packages in framework manager

3 Answers   TCS,

---

how you burst the reports? If you are bursted reports is not reached to destination how you identify?when you import data into catalog you have complex columns names.how do you change the name of those columns?

0 Answers   IBM,

---

i'm searching on cognos..i want to know real time scenarios..persons having real time exp or undertaking trainings or who searching on cognos...can send me the details...for proper guidence..for project and interview preparation..pls help me out..my mail-id is ammu2india@gmail.com..hope u will respond as soon as possible..thanks..

0 Answers  

---

-------------How you design DWH?

0 Answers   Bank Of America,

---

Can you explain model durability?

0 Answers  

---

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,

---

What is Star schema group?

1 Answers   IBM,

---

what are the applications of the tabular model ????

5 Answers   iFlex, iGate,

---

what r the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet??

2 Answers   Satyam,

---

how do you test reports in reportnet? what do you record in unit testing documents? pls give answer in detail......

2 Answers   TCS, Tech Mahindra,

---