May 18, 2009 at 3:43 am
I 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?
="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
May 18, 2009 at 8:01 am
What is not working? Is the report opening, but the parameter value not being recognized?
Have you tried putting the url expression in a textbox and then copied the value out and put it in the address box of IE to see if it works? It looks right to me, but I'd try this first.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
May 18, 2009 at 8:34 am
Hi
It opens the report but doesnt pass the parameter through!
I've tried giving the parameter a value:
="void window.open('http://testreportserver.backoffice.com/Reports/Pages/Report.aspx?ItemPath=%2fCustomer+Care+Reports%2fLIT+SKUs&rs:Command=Render&VoidReason=50')"
And this doesnt seem to be working either!
May 19, 2009 at 1:58 am
Hi
I managed to solve the problem using a differnt url to access the report server:
="void window.open('http://testreportserver.backoffice.com/Reportserver?%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"))) &
"')"
And it seems to work fine now.
The one thing I was going to ask is, is it possible to open up the report in a new tab instead of window?
Thanks
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply