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
- 5268 Views
- I also Faced
- E-Mail Answers
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 an sid (surrogate key)?
what is Associated grouping? and how it works in cognos impromptu?
what are the migration tools available in the market with respect to cognos such as impromptu reports are migrated to cognos reportnet?
what is report studiio and how to start it?
what are determinants?
4 Answers College School Exams Tests, IBM,
Can you define report item?
what are the special features in cognos reportnet?
When we save a report in report studio with what extn it save?
what do u mean by bridge group? where we r using this one?
If we run a report, that has 2 pages, i want to display one page in HTML format and another page wil display in pdf format. What is the procedure?
7. What is performance tuning?
im having a value prompt, in that value prompt im having the values as ABC and CDF, i want to hide the select box in that value prompt? is it possible in cognos?
Teradata 
