"Terry Mulvany" <terry.mulvany@rouseservices.com> wrote in message
news:en7UJiFwEHA.728@TK2MSFTNGP11.phx.gbl...
> Group,
> I would like to have a value (basically a scalar from a stored proc) in my
> header but I keep getting the compile error:
>
> 'The value expression for the textbox 'LastSale' refers to a field.
> Fields cannot be used in page headers or footers.'
>
> I tried putting a subreport in the header and that does not work either.
> It would be very limiting to not allow database data in the header of a
> report! (Very easy to do in Crystal Reports)
> Also keep in mind that I do not want my header in the 'body' region.
>
> Thanks everyone.
>
>

"angi" <angi@microsoft.public.sqlserver.olap> wrote in message
news:um99qaLwEHA.4048@TK2MSFTNGP15.phx.gbl...
> Hi, Ponnurangam..
>
> This way only can show the field value in first page,
> the second page, cause the textbox doesn't exist,
> so the value of reportitems become null...
> I want the value of reportitems can keep in whole report,
> no mattter report has how many pages!
>
> Any idea about this?
> Thanks!
>
> Angi
>
> "Ponnurangam" <ponnurangam@trellisys.net> ¼¶¼g©ó¶l¥ó·s»D
> :eTA7VcKwEHA.2908@tk2msftngp13.phx.gbl...
>> Place the field in any of the textbox(say textbox10) in body section
>>
>> Then use =ReportItems!textbox10.value in pageheader section
>>
>> Ponnurangam
>>
>> "Terry Mulvany" <terry.mulvany@rouseservices.com> wrote in message
>> news:en7UJiFwEHA.728@TK2MSFTNGP11.phx.gbl...
>> > Group,
>> > I would like to have a value (basically a scalar from a stored proc) in
> my
>> > header but I keep getting the compile error:
>> >
>> > 'The value expression for the textbox 'LastSale' refers to a field.
>> > Fields cannot be used in page headers or footers.'
>> >
>> > I tried putting a subreport in the header and that does not work
>> > either.
>> > It would be very limiting to not allow database data in the header of a
>> > report! (Very easy to do in Crystal Reports)
>> > Also keep in mind that I do not want my header in the 'body' region.
>> >
>> > Thanks everyone.
>> >
>> >
>>
>>
>
>

> Place the field in any of the textbox(say textbox10) in body section
>
> Then use =ReportItems!textbox10.value in pageheader section
>
> Ponnurangam
>
> "Terry Mulvany" <terry.mulvany@rouseservices.com> wrote in message
> news:en7UJiFwEHA.728@TK2MSFTNGP11.phx.gbl...
> > Group,
> > I would like to have a value (basically a scalar from a stored proc) in
my
> > header but I keep getting the compile error:
> >
> > 'The value expression for the textbox 'LastSale' refers to a field.
> > Fields cannot be used in page headers or footers.'
> >
> > I tried putting a subreport in the header and that does not work either.
> > It would be very limiting to not allow database data in the header of a
> > report! (Very easy to do in Crystal Reports)
> > Also keep in mind that I do not want my header in the 'body' region.
> >
> > Thanks everyone.
> >
> >
>
>