Interested to Buy Any Domain ? << Click Here >> for more details...
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....
- 2 Answers
- 6244 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
how u will design the report if the objects are available
What is the use of Cognos scenario?
Can you define confirmed dimension?
What is difference between primary key and unique key constraints?
How can we Maintain the Cube Security by Category level and Dimension level ?
What is meant by alternate drill down with ex?
How we check the errors before running the report?
what is power prompt in cognos ep7series?what is the use of this?
What is called materialized view?
What is the difference between set functions and filter function in dimensional data?
What is set to be Cognos configuration?
How do you call a store procedure within a transformation?
what are the errors faced while bursting the reports and how to solve those errors?
What is the difference between the content store and content manager?
Actually we have 500 users when they run the report display the flage image related country user? How its possible?
