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
write a query to display the departments with no employee?
What is the enterprise class platform architecture of cognos 8?
how many notations are posible(cordinolity)are there in between two tables(one is fact and another is dimension)pls give me a example pls.
When we save a report in report studio with what extn it save?
What are the themes in a data warehouse?
Define catalog in cognos and write its various types?
What is the difference between ‘macro’ and ‘prompt?
What is the difference between Section and Section using Master/Detail in Cognos 8 Report Studio? I tried these both options many times on lists and crosstabs, but dint find any difference. So please give the answer in detail with example.
how to test reports in cognos?
How is possible this scenario using in type-in prompt.?
What is the size of database for you project?
How is cognos model organization works?
Cognos Online Training will be provided. prior training with all real time aspects. Comprehensive training will be given in Datawarehousing concepts , cognos 8.4 and cognos 10 versions. Contact kris.cognos25@gmail.com
What is the difference between group and associare?
what are slowly changing dimensions? Why we are used scd?