drill through removing hyper link when coloum values are zero

[Revathi_M]

hi Anybody export explain me,


i am using 10.2.1 version
Employee              EnglishMarks   Maths Marks
REVATHI               12   22
EEER                               0   0
MMAAA                   0   43
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

[Lynn]

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.

[Revathi_M]

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

[Lynn]

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?

[Revathi_M]

Thanks LYNN,

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

[HalfBloodPrince]

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

[MFGF]

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

[Revathi_M]

Thanks  all .....................