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
- 6013 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 |
How to findout YEAR CALCULATION? THAT MEANS YOU SHOW THIS YEAR REVENUE AND LAST YEAR REVENUE. WHEN YOU FILTER THIS YEAR VALUE THE RESULT SHOULD DISPLAY THIS YEAR RESULT AND LAST YEAR RESULT.
What is difference between informatica power mart and power center?
What is the model filter?
How to add 2 different colors for alternative rows? i.e in a report all rows colors in alternative colors(2 colors)
why u need to publish the package?
What is catalog and types of catalogs in cagonos and which is better?
how to create measures and dimensions?
What is content store?
What is the difference between low affinity and high affinity connections?
What do you mean by query studio?
Hi Friends, What is the Max no.of rows in a report & a page? If we have Master, Detail Reports, I have define drill through, Requirement is When i run Master Report it should run in HTML, when i drill through to detailed report it should get into PDF is it Possible in Cognos? Thank You Kumar
-----------Diff b/W Aggregate Function and Rollup Aggrigate Function?
Teradata 
