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
hi my name is siraj i want to know cognos queriy language
How to publish a package by running Java Script?
What are initial page components of Cognos connection?
How to deploy from one server to another server?
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
What's the limitation of 'Page Footer' in Report Studio? e.g. If I have an activity prompt (list of activities in a Search & Select Prompt) and selected around 2500 activites from the 'Activity' Search & Select Prompt and when I ran the report I got a message "#! Overflow" in page footer. Can somebody please tell me what's max. limit. I tried with around 300 activities and page footer displayed the activities. Your help will be appriciated.
what do u mean by bridge group? where we r using this one?
------------- How to identify the Revenue Column in Report?
2. What functional area you worked on.
What is the use of powerhouse?
Can you define confirmed dimension?
Can you define bitmap index?
1. We have been asked to add summary information to sales reprasentatives performance report. The report needs to be grouped by country and city to compare performance between areas Also we need to include revenue totals for each city and each country.
After applying date prompt and when we run the report we
fet from date and todate prompts..so when we enter
todate What is the enterprise class platform architecture of cognos 8?