Answer Posted / cognosvij

Specify a variable based on which object can be
conditionally rendered.

e.g.
In my sample report .....
I have a Prompt page and it contains a value prompt for
revenue type i.e.X revenue and Y revenue
I have put static choices in that value prompt as X and Y .

now on report page there ,
I have a list contains ....
Client Id
X revenue
Y revenue

as a user run the report ,
if he selects X the list should displays
Client ID
X revenue

and
if user selects Y list should dispalys
Client ID
Y Revenue


for this i have created a string varibale with the values X
and Y and put the condition as....

if (ParamDisplayValue('Parameter1')='X')
then
('X')
else
('Y')

and then go to the report page select the X revenue column
and click render variable property from property sheet and
uncheck the check box for Y

and again
go to the report page select the Y revenue column and
click render variable property from property sheet and
uncheck the check box for X

and now run the report and see how Render variable is
working .....



Hope it will help u

thnx,
vij

:-)

how the values be passed to prompts in report studio? when a data item is dragged n dropped in to report, after the default query generated first which sql will the query query hit for processing means (native or cognos)? plz answers to these questions?

9308

---

-----------------What is Direct and Conventional loading?

2216

---

It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?

2512

---

What is main difference mapplets and mapping?

1262

---

faq's on cognos

4094

---

How is possible this scenario using in type-in prompt.?

1096

---

What is Fullouterjoin?

2019

---

can anyone let me know some tips or interview questions on framework manager metadata modeling, creating joins, and all other aspects related to Cognos 8 framework mgr

2099

---

7. What is performance tuning?

2049

---

What you mean by drill across and what is the difference between drill through, drill across?

1078

---

hi, i am searching job in cognos and datastage, does any can provide me the real time experieced scenerios and questions related to cognos and datastage projects, so if anyone provide me the documents related this can very helpful to me, my mail id is tchiru01@yahoo.com

2236

---

What is the difference between group and associare?

1084

---

Can you define pivot?

1197

---

i was asked what are the caluclations done by you in your report? plz give reply

2237

---

How to do Performence Tunning in Cognos Reports?

2526

---