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
- 4394 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 all types of prompt?
Hi is any one having link to download books on datawarehouse tool kit by ralph kimball or any other authors books.
What is the difference between Standard and Metrics folder?
what is an outer join? difference between left outer join right outer join with an example?
why we r using report studio in webbased only and fm windows based only
how can you get the errors in job? when loops are araised we get error?
how u publish the packages in framework manager
What are the types of studio present in Cognos?
suppose i want to do drill through a column only for the values which is having more than > 50000. how can i do that?
In my Report C-id c-name Revenue are the query items I need to display the report has Alternative colors for rows and Revenue >=1000 has display in another color? i.e Both c-id,c-name are applying the alternative color(red,yellow) condition and revenue (blue) u think..How its possible? Iam doing for alternative colors i defined Two dataitems as running-count and Mod... and next in Boolean varaible define as [Query1].[Data Item2] = 1 or 0 and [Query1].[Revenue]>=1000 as like this (it's correct or not) and define in condition explorer yes and no purpose two colors(here how to define 4 revenue color) By selecting the list columns body style its applying only the Body and run report it working only for alternative colors Next i defined by using same Boolean condition for revenue like this. For selecting only the Revenue Body and define as yes 4 one color and no for another color? But here it the revenue column also applying only the alternative color condition and it's taking the >=1000 condition... So,i need to display 2 columns have alternative colors and 3rd column >=1000 cell have another color any body pls give me the replay/answer in step wise..... Thank u Basha
what is repeater table and repeater where to use these? can any one explain with senario greatly helpfull
what is logs in cognos
1 Answers Target, Thomson Reuters,
Teradata 
