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
- 4404 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
Can you explain model durability?
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.
can anybody explain me about sales project in cognos..wt is the requirement,how u get the requirement..explain me any one based on ur experience as a report developer..how much time u will take to complete one project,single person in a team have to do how many reports..in a real time how much time will take to complete reports ie..one single report.. (simple and complex report)and in real time ur project contains how many fact tables and dimension tables..how many query subjects and query items..wt functional area u worked on.. hope u vl respond as soon as possible ..my mail- id is ammu2india@gmail.com
What is Online View?
what is log in cognos?
Explain difference between powerplay transformer and power play reports?
I have two queries in first query i have to show all values,in second query i have to show 3 values and want to hide 3 values what prompt ur going to use, why that prompt
my report ended at the half of the last page but i don't want that matter in the last page I would like to adjust the matter in the previous page .how can i do this?
What are shortcuts? Where it can be used? What are the advantages?
What project,model,parameter maps,namespace and database definitions....... what these are all contains? what are differences b/w them?
What is difference between primary key and unique key constraints?
what is requery in cognos?
What is catalog and types of catalogs in cagonos and which is better?
What r the names of the reports that you prepared?
What errors and types of errors you faced in Cognos ReportNet?
