Hi,
I got a requirement wehre in in a drill through report , in
parent report i have a column of numbers
on which i have to apply drill through to child report.The
condition is in that column if the number ia not zero the
drill through link should appear (i.e., 1 to 9) if its 0 or
negative number link should not appear. How ?
Help would be appreciated
Answer Posted / suresh
Hi
Lets say I have a report and columns like
Class Student
1st Std 10
UKG 6
Pre KG 0
Steps:
1) create a Boolean varible like student>0
2) go to report and select Student cell not the column
3) unlock the object
4) delete the student from the cell
5) drag the conditional block into the cell
6) go to contional block properties and block variable
point to already created boolean variable
7) then current block set to yes
8) drag the student again to this conditional block
9) create the drill throuh for this yes block
10) now change the current block to No
11) then drag the student again into the cell
12) run the report.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
It is possible to test 2 query subjects at a time in CRN1.1 & C8 FWM?
hi my name is siraj i want to know cognos queriy language
Define catalog in cognos and write its various types?
what is degenerate key in oracle ?whare do we use it?
2. We have asked to create a repots showing sales by region in order to determine which regions are generating the most revenue and highest sales volume. The report needs to include the revenue and quantitiy sold of each subcategory with in category.
Can you explain the advantage of using shortcuts?
What is the size of the cube?
What is the diff between cognos 8.1 & cognos 8.2 & cognos 8.3? Measn whet are the enhancements are added in new versions(8.2& 8.3)?
What do you understand by the term 'dynamic cube'?
What are all types of Batches?
Define cognos report net?
What is meant by junk dimension?
What junk dimension contains?
how can we Upgrad the reports from version Impromptu 6.0 to 7.0 and Power Play from version 6.6 to 7.0 ?
What is set to be cardinality?