Hi all, I have a list report with Country, City & Revenue. In
the run time i want to hide the particular column. I have
tried using Java script but i didn't get any out comes.
Please any one share steps for me....
Answers were Sorted based on User's Feedback
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
Is This Answer Correct ? | 2 Yes | 0 No |
what is a prompt value in report studio and variables ?
if there are list,crosstab,chart how can you apply a single filter to all object?
what is an sid (surrogate key)?
what is requery in cognos?
Explain how data modeling is useful to cognos in daily life?
What is meant by junk dimension?
Hi I need real time senarios and how to explain project in the interview pls let me know my email id m.n.prathyusha@gmail.com.Please help me out with this
i have 4 countries in my database as USA, UK, INDIA, CHANA. In value prompt's prompt control list, i want WESTERN_COUNTRIES, ASIAN_COUNTRIES instead of those country names. When i click on WESTERN_COUNTRIES, it should retrieve USA, UK records and when i click on ASIAN_COUNTRIES, it should retrieve INDIA, CHINA records. How is it possible?
what are determinants?
How do you improve the performance of the Cognos Analytics report
What are the different types of reports present in cognos?
Can anyone explain the procedure for configuring cognos8 with oracle as Content Manager/Content Store? I know the configuration of cognos8 with SQL SERVER (Like how to create CM database in oracle and applying securities to access that Database from cognos8 (Cognos Configuration)