locked
go to report with conditions RRS feed

  • Question

  • Greetings.
    I am using the action tab of a texbox to send me to another report and the option to report selected Specify the report where I want to send me.
    Now I need esque Anvi me to different reports according to a condition but not how to write or even if possible
    something like
    if = Fields! Año.Value = 3000
    gotoreport1
    elseif = Fields! Año.Value = 4011
    gotoreportstock
    else
    gotoanotherreport

    How I can do? Give me a help
    Friday, August 12, 2011 4:52 PM

Answers

  • Use this

    =iif(Fields!Ano.Value = 3000,

    "gotoreport1",iif(Fields!Ano.Value =4011 ,"gotoreportstock","gotoanotherreport"))
    • Proposed as answer by Arun..Singh Friday, August 12, 2011 4:58 PM
    • Marked as answer by Augusto C Friday, August 12, 2011 11:50 PM
    Friday, August 12, 2011 4:58 PM

All replies

  • Use this

    =iif(Fields!Ano.Value = 3000,

    "gotoreport1",iif(Fields!Ano.Value =4011 ,"gotoreportstock","gotoanotherreport"))
    • Proposed as answer by Arun..Singh Friday, August 12, 2011 4:58 PM
    • Marked as answer by Augusto C Friday, August 12, 2011 11:50 PM
    Friday, August 12, 2011 4:58 PM
  • Hi!

    You almost have it.

    Here's what you do:

    1. Click on the Action button
    2. Choose "Go to report"
    3. Click on the Fx tool.
    4. Create a function:  =Switch(Fields!Ano.Value = 3000, "report1", Fields!Ano.Value = 4011, "reportstock", True, "anotherreport")
    5. (True) in the above example functions like an ELSE statement.
    6. Done!

    The above example assumes that the drilldown reports are in the same directory parent report.  If not, you will have to create relative directory offsets to navigate to the reports.

    Good luck!


    DJAnsc
    Friday, August 12, 2011 5:04 PM
  • thanks a lot
    your fix everything with the expression iif

    eh?

    thanx again

    Friday, August 12, 2011 11:51 PM