Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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


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


Please Help Members By Posting Answers For Below Questions

What is the information present in the cognos configuration file?

1015


how you create security to reports?

1100


What is a Framework manager?

1079


What is a Folder?

1238


what is the difference between querystudio in reportnet and cognos8

2192


What are the two types of framework manager?

1432


What are the advantages of cognos?

1031


how many reports do u create in ur project?i don't have real time exp..tell me based on ur exp..for interview pt of view,don't say it depends on ur project and u? thanks in advance..

2159


What is a Pivot?

1238


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

2326


What is the diff between the following Report output-- HTML O/P, PDF O/P, EXCEL 2000 and EXCEL 2003 of report outputs? Listout main differences?

2130


what are the names of the reports that you prepared?

1159


What are the steps to import the two data sources in framework manager?

1093


how to test reports in cognos?

1078


Hi experts,Recently I faced one questions in MNC,They having 4 tables in FM ..One fact table CALLING X, Remaining 3 tables are there not fact calling y,z etc...We want to join individually from X to Y..please suggest.

1431