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
- 1 Answers
- 4542 Views
- IBM, I also Faced
- E-Mail Answers
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
What is the difference between regular dimension and derminant?
What are the other methods working as deployment functionality?
How can reports be bursted based on two groups? I want to schedule to burst a report based on product line and years and I need the burst report for every product line and every year. How can this be done? Please help..
What is catalog and types of catalogs in cagonos and which is better?
4. How many dimensions did you use in your reports?
Can you explain dynamic query mode?
What are the message flows?
what are the filters in framework manager and report studio?
Can you define slice?
What is the difference between a data mart and a data warehouse?
how to perform single sign in cognos by using url?
What are query items?
How to create a cube in Transformer? What is the process? Please mention process thank u
how to create cubes in transformer ?
What is meant by drill down?
