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
:-)
| Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
How do you call a store procedure within a transformation?
What is the use of powerplay web viewer in cognos?
can you tell me what are the dimension tables are used in project
tell me two or three issues from client side and how to solve those issues?
What is meant by Reportstudio shortcut?
What do you understand by the cognos?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate ---------------Tell me about DWH Concepts? Why need staging area database for dwh? hi my name is siraj i want to know cognos queriy language What is a Query Subject? What is a Datastore in Cognos? What is the enterprise class platform architecture of cognos 8?