COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Revathi_M on 22 Dec 2014 09:40:23 AM

Title: drill through removing hyper link when coloum values are zero
Post by: Revathi_M on 22 Dec 2014 09:40:23 AM
hi Anybody export explain me,


i am using 10.2.1 version
Employee              EnglishMarks   Maths Marks
REVATHI     (http://revathi)           12   22
EEER                               0   0
MMAAA (http://mmaaa)                   0   43
RAAAA (http://raaaa)                     28   0
RANNNNN                  0   0


above tables are attached in excel please check
here i am using drill through and diplay employee details it is working fine.

but i need to EEER and RANNNNN    both employee no need hyper link symbol becoz both subject zero


when i am click both employee drill through report no data available thatway  client decide remove the hyper links


please anybody help me that is possible or not if any java scripts


Title: Re: drill through removing hyper link when coloum values are zero
Post by: Lynn on 22 Dec 2014 09:49:31 AM
I would suggest you try putting the employee into the layout twice, one with the drill through and once without the drill through, and then use a render variable or an advanced conditional style to only display one based on the presence or absence of zeros in the marks.

Title: Re: drill through removing hyper link when coloum values are zero
Post by: Revathi_M on 22 Dec 2014 11:02:15 AM
Hi Thanks you replay,
but i need  non zero rows need drill through display new window ,if zero  no need hyperlink like attached excel sheet


thanks
revathi_M
Title: Re: drill through removing hyper link when coloum values are zero
Post by: Lynn on 22 Dec 2014 11:47:13 AM
Quote from: Revathi_M on 22 Dec 2014 11:02:15 AM
Hi Thanks you replay,
but i need  non zero rows need drill through display new window ,if zero  no need hyperlink like attached excel sheet


thanks
revathi_M

That is exactly what I gave you a solution for. Attached is an example using the sample data. I made the values zero for the "Special" order method type and you can see the drill through links appear only for the non-zero methods. Did I misunderstand your requirement?
Title: Re: drill through removing hyper link when coloum values are zero
Post by: Revathi_M on 22 Dec 2014 09:43:20 PM
Thanks LYNN,

yes i am looking same,please can send me step by step pleae...............................
thanks
Revathi_M
Title: Re: drill through removing hyper link when coloum values are zero
Post by: HalfBloodPrince on 23 Dec 2014 03:24:31 AM
Try this out

Click on unlock button and add same marks column next to on which you have created a drill through.

Then create render variable as if( marks=0 ) then ( 'Y') else ('N')

then for 0 reder column with no drill through defination while for others render marks column with drill through
Title: drill through removing hyper link when coloum values are zero
Post by: MFGF on 23 Dec 2014 04:44:10 AM
Quote from: Revathi_M on 22 Dec 2014 09:43:20 PM
Thanks LYNN,

yes i am looking same,please can send me step by step pleae...............................
thanks
Revathi_M

Lynn already gave you the steps, plus a report you can look at to see what she did. I think she's been hugely generous in taking the time to do this. Isn't it enough for you that you have the approach and a completed example to look at? Did you try her approach? If so, what part are you having issues with? If not, why not? If she spends more time detailing every single little click and step you need to take, are you going to pay her your salary?


Sent from my iPad using Tapatalk HD
Title: Re: drill through removing hyper link when coloum values are zero
Post by: Revathi_M on 23 Dec 2014 10:00:54 PM
Thanks  all .....................