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
- 5153 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
------------- How to identify the Revenue Column in Report?
What are all the types of gateway used in Cognos?
please can you give me some banking domine calculations developed in framework manager plzzzzz thank you.
What do you understand by the term 'dynamic cube'?
What is the difference between a data mart and a data warehouse?
what is the difference between querystudio in reportnet and cognos8
Hi All, Is there any way to check whether a value is selected in a Multi-select tree prompt? I have a tree prompt and want to get to know whetehr which values user has selected,i want to so that values on the top of the report. I Have used that paramDisplayValue('paramername'),But it will display only last selected value. For Example i have tree prompt with one level Region- >country->states If user select region Asia it will dislay the all the Countries in that region and then if user select India it will display the states related to india only Suppose Hierachy look like this: Asia->India->Andhra Pradesh. I want to show this hierachy on the top of the report How it is possible? Can you please help me?
What are the main services provided by application tier?
what is model and say about process how to create model and how to test model?
If we are migrating lower version of Cognos reports (e.g. from Ver 7.0 to Cognos 8) then how we migrate Impromptu Catalog (ver 7.0) in Cognos 8? Do we create FM model for that? Please explain.
is cognos 7 is better than cognos 8
Write various indexes used in cognos?
What r the names of the reports that you prepared?
What is catalog and types of catalogs in cagonos and which is better?
How do you Parametermap variables in Quiries?
