Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 5086 Views
- IBM, I also Faced
- E-Mail Answers
Answer / 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 |
What are the advantages of using cognos sql?
Can you define materialized view?
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 the use of report studio?
What is the advantage of using shortcuts?
A list box contains 1000 records, while running the list, inside the header the content has to scroll down. Note the header should not go up?
Column level security in report
Can you explain dynamic query mode?
Due Date (Highlight Issues in Blue where Due Dates are less than Todays Date),I have only Due Date column then how to over come the problem.How to find out which Due Date are less than Today Date...Kindly provide the detail steps to my mail ID-->asimcognos10@gmail.com
How create measures and demensions?
----------------What is meant by DSS?
What are all the types of hierarchies?
Teradata 
