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 |
|
rcr69er
Constraint Violating Yak Guru
327 Posts |
 Posted - 2009-05-18 : 05:37:54
|
| Hi GuysI have a report with a navigation link to another report., which will open up in a new window. The other report has a parameter called VoidReason which needs to be passed. I’ve tried to use an expression within my code (posted below) but it doesn’t seem to be working! Does anyone know what is wrong with it?="javascript:void window.open('http://testreportserver.backoffice.com/Reports/Pages/Report.aspx?ItemPath=%2fCustomer+Care+Reports%2fLIT+SKUs&rs:Command=Render&VoidReason="&IIF(Fields!ReasonName.Value = "Lost in Transit (Not left warehouse)","51" ,IIF(Fields!ReasonName.Value = "Lost in Transit (Carrier at fault)","50" ,IIF(Fields!ReasonName.Value = "Lost in Transit (In dispute)","14" ,"58")))&"')"Thanks |
|
|
|
|
|
Navigating to Another Report