Problem creating Page Header

I'm trying to create a page header in a report. The report is a simple list
of participants in one of our training programs. I'm trying to put the title
of the training program in the header of the report. According to
directions, I placed the field textbox in the body of the report. eg.
=First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
text box into the header section of the report. I then right click the empty
text box and in the expression builder type
=First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
and recompile, I get the following error message:
The value expression for the textbox â'textbox4â' uses a scope parameter for
an aggregate function. The scope parameter cannot be used in page headers or
footers.
I would appreciate any help with this. I'm just learning and I can't find
any documentation on this error message.
--
MelissaIn the page header, you need to reference the textbox name, not the dataset
field. Which textbox is named textbox4?
"Melissa" wrote:
> I'm trying to create a page header in a report. The report is a simple list
> of participants in one of our training programs. I'm trying to put the title
> of the training program in the header of the report. According to
> directions, I placed the field textbox in the body of the report. eg.
> =First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
> text box into the header section of the report. I then right click the empty
> text box and in the expression builder type
> =First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
> and recompile, I get the following error message:
> The value expression for the textbox â'textbox4â' uses a scope parameter for
> an aggregate function. The scope parameter cannot be used in page headers or
> footers.
> I would appreciate any help with this. I'm just learning and I can't find
> any documentation on this error message.
>
> --
> Melissa|||Thank you, DAW. You pointed me in the right direction. For anyone else who
is encountering the same problem, here's the solution. The text box in the
report header (e.g. textbox4) should reference the textbox name that holds
the field value you want in the report header (e.g. Event_Title_1). This
field value text box must exist in the report body. In the report header
textbox (e.g. textbox4), create an expression using the global collection
(ReportItems). Here is the syntax for my solution
=(ReportItems!Event_title_1.Value)
--
Melissa
"Melissa" wrote:
> I'm trying to create a page header in a report. The report is a simple list
> of participants in one of our training programs. I'm trying to put the title
> of the training program in the header of the report. According to
> directions, I placed the field textbox in the body of the report. eg.
> =First(Fields!Event_Title.Value, "EventListHeader"). I then placed an empty
> text box into the header section of the report. I then right click the empty
> text box and in the expression builder type
> =First(ReportItems!Event_Title.Value, "EventListHeader"). After I save this
> and recompile, I get the following error message:
> The value expression for the textbox â'textbox4â' uses a scope parameter for
> an aggregate function. The scope parameter cannot be used in page headers or
> footers.
> I would appreciate any help with this. I'm just learning and I can't find
> any documentation on this error message.
>
> --
> Melissa