Jumping To Reports
Hi, I have 2 reports - a summary and a detail. When I select one of the values in the summary report I want it to jump to the detail report showing me what the 'summary' values consist of. I have set the parameters up on both reports and am able to pass them between the two.
I do not have any issues with any of the above but how do I stop jumping from the summary report to the detail when there is no value in the summary report? Any ideas.
[589 byte] By [
Quarry] at [2008-1-2]
Hi Shyam. I have previously tried this, so in the 'Navigation' tab and in the 'Jump to Report' action I entered the following IIF statement:
=iif(count(Fields!product_code.Value) > 0,
"Price Comparison Product", "Price Comparison Summary")
(Price Comparison Product is my detail report). I think the problem is that with both reports I have four parameters which the user can select:
Market,
Competitor,
Brand and
Sub Section
If the user tries to jump to the detail report where the value in the summary report is 0, then the parameters that I have created to pass to the
detail report are not valid for the summary report. I think this is the point where I am coming unstuck!! I hope you follow this.
