What is Conditional block? How do you use in a report?
Answer / khushbu
Conditional block: Specify a variable based on which
objects inserted into a
block can be conditionally rendered.
for example user can have option for List report or chart
report when he runs the report.
Try this out........
CONDITIONAL BLOCKS
The goal of this report is to prompt users on which display
they would prefer, a list or a chart.
To start, create a simple list report in Report Studio.
Using the Cognos sample data, product line, order method
and revenue are added to the list. From the toolbox, drag
and place a pie chart below the list. Select the chart and
in the properties pane, attach this chart to query 1:
Now the chart can be populated from the data items tab.
The consumers of this report need the ability to choose
between the displays they want to see. To accomplish this,
build a blank prompt page allowing them to select from a
drop down list either list or chart. Drag a value prompt to
the prompt page with the following settings:
At this point hit ‘Finish”. The dropdown list has to be
populated manually though the static choices property of
the value prompt. The two choices added are list and chart.
*You can leave the display value blank. If you do so,
Report Studio is smart enough that it will take the use
value for the display value.
Now that my prompt page is set, return to the Report Page.
In order to conditionally display an object, use the
conditional blocks object in the toolbox. Drag this to the
bottom of the report.
The next step is to attach the variable to the conditional
blocks block variable property. This variable is a Boolean
variable that either equals a list or doesn’t.
We need to test if our parameter is equal to the
value ‘List’. If the user selected List this expression
will evaluate to true, if the user selected ‘Chart’ from
the prompt, then this will evaluate to false.
After this step is completed there is a new property on the
conditional blocks object that tell us which block we are
currently looking at. First, drag the chart into the ‘No’
block.
Now, select the conditional block again, and switch the
current block property to ‘Yes’. The conditional blocks
object appears empty because there is currently nothing in
the ‘Yes’ block.
The final step is to drag the entire list inside the ‘Yes’
block.
Now when the report is run, the user will be prompted for
their display of choice.
Is This Answer Correct ? | 19 Yes | 0 No |
we have a list of 80,000 records, i would like to display in excel sheet but excel sheet has capacity of 60000 record.. how you going to display?
How to generate cubes in cognos?
what is the security module used in cognos?
---------------Tell me about DWH Concepts?
diff b/w dimension and regular dimension
What are all types of Batches?
I have tables like tableA&tableB,in tableB columns(sno,month,netrevenue,year),by using both the tables we hava to create list columns like(country,month,net revenue)when i run the report if my retrevenue'0'this plasa i want to display'NULL'
what is dynamic sort?
how many types of keys are there i.e primary key and foreign key etc..?
WHAT ARE THE DISTNICT VARIABLES?
Can anyone tell me which automation tool is used in cognos,is it a testing tool or performance enhancing tool Thanks in advance
What are the types of studio?