Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
samanthab
Starting Member
10 Posts |
 Posted - 2009-04-20 : 11:26:16
|
| 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.Once the user can see the values they can then select the 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 |
|
|
samanthab
Starting Member
10 Posts |
Posted - 2009-04-21 : 07:16:24
|
| I figured out the answer, incase anyone is interested it is as follows....=Iif(InScope("matrix1_MeasureCode"),"KPIDaily Drilldown Report_v1", Nothing) |
 |
|
|
|
|
|
drilldown to an image,that jumps to another report