Post reply

Navigating To Another Report

  • May 18, 2009 at 3:43 am

    #209782

    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

    #996340

    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

    #996381

    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

    #996768

    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