Drilling thru to a re-ran report view and filtering?

[mikegreen]

I have a report that has 5 possible prompts.  I have a job setup to run the report will all prompts and save them as report views. Thus, the run history/versions of the report list these 5 which I can call up without re-executing to the DB.

In brief testing, if I try to drill to these versions and pass one of the 5 prompts, it always returns the latest report version..And doesnt care about what prompt is being passed.

Is there anyway to drill thru to a version and have it pick the version based on the prompt value?  If not, it seems I am stuck with hyperlinking a static table to 5 different report views (which is not optimal...).

Cheers,

Mike

[bdybldr]

Mike, since there are 5 possible options, why don't you append the name of the prompt values to each of the saved views so you can identify them easily?

I'm going to use Sales reps for this example... 10, 20, 30, 40, 50.

Then create a variable in your parent report: ParamDisplayValue("paramSalesRepID") and define your values.

Next, add a conditional block to the field that you want to drill through on, say RepID (you'll have to unlock the report items).  Base your conditional block on your variable and set the current value of the block to your first parameter value (10).

Then, set your drill-through to "SalesRepDetail_10" (or something like that) for SalesRepID 10.  Then copy that field into the conditional block.  Do the same for the other values.

HTH...Let me know if you need clarification.