Variable Drill through

[dhulbert]

I have a requirement to create a report with drill through capability which in it self is no problem but what I would like to do is to dril through to different reports depending on the value of a field in the first report.
So if Field "Type" = "Widget" then drill thrpugh to the "widget report" but if field "Type" = "Product2" then drill through to the "Product 2 Report"

Hope this makes sense and thanks in advance if anyone has an answer to it.

I love deadlines. I like the whooshing sound they make as they fly by
Douglas Adams
(1952-2001)

 

[paulkeys]

Assuming your doing this via textbox 'Go to report' action you can set the report to 'go to' via an expression.

To carry on your example, the expression would look something like;

iif(Fields!Type.Value="Widget","widget report",iif(Fields!Type.Value="Product2","Product 2 Report",""),"")

If you need to move much past a few different reports, it may be worth checking out the "Switch" function.

Hope this helps...