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
Can you define drill across?
5. Which type of report you build more, list, crosstab or chart and why?
what are the dimensions that you have in your current project?list them?
hi..i'm searching on cognos.i want to know some real time explanation..persons who have real time exp and who r searching in this field..can u send ur mail-id..my mail-id is dhaanuus@gmail.com..hope u will respond as soon as possible..
What are all the different types of prompt in cognos?
Name the types of report?
hi friends pls forward impropmtu interview question
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.
Why cognos scenario is used?
Define query items?
in single column there is india and malaysia and uk canada and dubai,saudi.ok i need using valuable prompt i select asian country will be display india malaysia and i will select eurobe country only display uk canada.pls tell me any how do set this concept using valuable prompt
Can you define snapshot?
What is main difference mapplets and mapping?
What is drill down and slicing and dicing whats the difference between them?
Explain is there any comparison available for cognos reportnet vs crystal reports?
