Drill-through report

Hi,
I am trying to set up drill-through reports by passing parameters from
one report to the next.
The first layer works: when the user clicks on the field (the
department in this case) the second report comes up for that
department.
But when I try to pass the same parameter to the third report from a
text box, I get a warning: 'The expression referenced a non-existing
field in the fields collection.' The field is listed in the Fields
list and the text box is referencing it using the aggregate function:
=First(Fields!x_department.Value, "DataSetName")
What am I doing wrong? Thanks for any help you can provide...Is the "DataSetName" a part of the third report?
"Hella" wrote:
> Hi,
> I am trying to set up drill-through reports by passing parameters from
> one report to the next.
> The first layer works: when the user clicks on the field (the
> department in this case) the second report comes up for that
> department.
> But when I try to pass the same parameter to the third report from a
> text box, I get a warning: 'The expression referenced a non-existing
> field in the fields collection.' The field is listed in the Fields
> list and the text box is referencing it using the aggregate function:
> =First(Fields!x_department.Value, "DataSetName")
> What am I doing wrong? Thanks for any help you can provide...
>|||well it's a well known problem.
Insted of using Jump to Report use the Jump to URL.
"Ben Sullins" wrote:
> Is the "DataSetName" a part of the third report?
> "Hella" wrote:
> > Hi,
> >
> > I am trying to set up drill-through reports by passing parameters from
> > one report to the next.
> > The first layer works: when the user clicks on the field (the
> > department in this case) the second report comes up for that
> > department.
> > But when I try to pass the same parameter to the third report from a
> > text box, I get a warning: 'The expression referenced a non-existing
> > field in the fields collection.' The field is listed in the Fields
> > list and the text box is referencing it using the aggregate function:
> > =First(Fields!x_department.Value, "DataSetName")
> >
> > What am I doing wrong? Thanks for any help you can provide...
> >
> >|||Thanks for responding!
I am finally able to try the 'Jump to URL', but the parameter is still
not getting passed.
This is what I have in the URL:
=Globals!ReportServerUrl &
"/Incoming+Types+By+Department/Quarterly+Incoming&Department="+=First(Fields!x_department.Value,
"MonthlyIncoming")
I tried using the Parameter!Department.Value instead of First(Fields!
etc.) but it doesn't work either - (FYI: the report parameter is also
defined in the third report.)
The field x_department is being passed from the parent report (Incoming
Types By Department) to the first child report (Monthly Incoming). It
is the field I am trying to pass to the third report (Quarterly
Incoming.) from the 'Monthly Incoming' report.
Thanks!|||Never mind! it works now.
For whoever might be interested, this is the URL I entered in the Jump
to Url box:
=Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/Quarterly
Incoming" & "&Department="&Parameters!Department.Value
Hella