Hi i have created a drilldown report. where the values for the chosen route only appear when the user drills down to the thrid level.

One the user can see the values they can then select teh number which will jump to a chart for more detail. this all works perfectly.

Now the problem...I have another column which the user can select an image that i have uploaded and view a daily chart.... however i would like this to act like the other colums, whereby the image is only veiwable and clickable on the third level. here is the code i have been playing around with with no luck



=Iif(InScope("matrix1_ServerName"),

                                (Iif(InScope("matrix1_MeasureCode"),THIS IS WHERE I NEED HELP, "")),

                                "")
the report i want to jump to is called  'KPIDaily Drilldown Report_v1'


Does anyone have any ideas?

thanks in advance