Drilldown - three pages
Posted: Mon Apr 27, 2009 9:24 am
Hi, I'm experiencing some issues with creating a drilldown report. The first page works well but when drilling down a further level I get a blank page. Initially I thought I may have some invalid filter or something but I can't figure this one out.
My report structure is as follows:
[Page1]
List report with databands interaction properties set as follows:
DrillDownEnabled=true
DrillDownPage=Page2
DrillDownParameter1.Name="A1", DrillDownParameter1.Value = TableOnPage1.A1
[Page2]
Master detail report with the filter property of the detail band set to:
(int)this["A1"]==TableOnPage2.A1
The Interaction properties on the detail databand are:
DrillDownEnabled=true
DrillDownPage=Page3
DrillDownParameter1.Name="B1", DrillDownParameter1.Value = TableOnPage2.B1
[Page3]
Master detail report with filter property of the detail band set to:
(int)this["B1"]==TableOnPage3.B1
It may be worthwhile mentioning that Page2 and Page3 have similar master-detail structures (ie. Using same tables) but Page2 lists the detail as a listing whereas Page3 lists the detail as a form (ie. Fields are arranged in rows not columns) with a chart.
Thanks in advance
Paul
My report structure is as follows:
[Page1]
List report with databands interaction properties set as follows:
DrillDownEnabled=true
DrillDownPage=Page2
DrillDownParameter1.Name="A1", DrillDownParameter1.Value = TableOnPage1.A1
[Page2]
Master detail report with the filter property of the detail band set to:
(int)this["A1"]==TableOnPage2.A1
The Interaction properties on the detail databand are:
DrillDownEnabled=true
DrillDownPage=Page3
DrillDownParameter1.Name="B1", DrillDownParameter1.Value = TableOnPage2.B1
[Page3]
Master detail report with filter property of the detail band set to:
(int)this["B1"]==TableOnPage3.B1
It may be worthwhile mentioning that Page2 and Page3 have similar master-detail structures (ie. Using same tables) but Page2 lists the detail as a listing whereas Page3 lists the detail as a form (ie. Fields are arranged in rows not columns) with a chart.
Thanks in advance
Paul