ReportItems in Header/Footer

Hi there,
probably the most common problem with srs: how to insert data fields in page
header or footer?
The described workaround to reference ReportItems in the body does not work
for me, don´t know why.
Here is what I did:
I have a footer that must display fields from a query.
I placed a textbox named textbox1 in the body with a value of
=First(Fields!Field123.Value
I added a textbox in the footer with a value of =ReportItems!textbox1
When I render the report the textbox in the body contains the data as
expected, but the textbox in the footer is just empty. No Errors, no
warnings!
I use SQL2000 SP4 with Reporting Services SP2.
Any suggestions are highly appreciated :)
greetinx,
Joerg KrummTry:
=ReportItems!textbox1.value
"Jörg Krumm" <jeykey-news@.justmail.de> wrote in message
news:e5MI%23WiCHHA.4016@.TK2MSFTNGP02.phx.gbl...
> Hi there,
> probably the most common problem with srs: how to insert data fields in
> page header or footer?
> The described workaround to reference ReportItems in the body does not
> work for me, don´t know why.
> Here is what I did:
> I have a footer that must display fields from a query.
> I placed a textbox named textbox1 in the body with a value of
> =First(Fields!Field123.Value
> I added a textbox in the footer with a value of =ReportItems!textbox1
> When I render the report the textbox in the body contains the data as
> expected, but the textbox in the footer is just empty. No Errors, no
> warnings!
> I use SQL2000 SP4 with Reporting Services SP2.
> Any suggestions are highly appreciated :)
> greetinx,
> Joerg Krumm
>|||Hi Chris,
thanks for your hint. I do have a value of =ReportItems!textbox1.value . I
just made a mistake in the posting :)
Joerg
"Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> schrieb im
Newsbeitrag news:%23fEyGglCHHA.3476@.TK2MSFTNGP04.phx.gbl...
> Try:
> =ReportItems!textbox1.value
>
> "Jörg Krumm" <jeykey-news@.justmail.de> wrote in message
> news:e5MI%23WiCHHA.4016@.TK2MSFTNGP02.phx.gbl...
>> Hi there,
>> probably the most common problem with srs: how to insert data fields in
>> page header or footer?
>> The described workaround to reference ReportItems in the body does not
>> work for me, don´t know why.
>> Here is what I did:
>> I have a footer that must display fields from a query.
>> I placed a textbox named textbox1 in the body with a value of
>> =First(Fields!Field123.Value
>> I added a textbox in the footer with a value of =ReportItems!textbox1
>> When I render the report the textbox in the body contains the data as
>> expected, but the textbox in the footer is just empty. No Errors, no
>> warnings!
>> I use SQL2000 SP4 with Reporting Services SP2.
>> Any suggestions are highly appreciated :)
>> greetinx,
>> Joerg Krumm
>|||You could create a report parameter, probably internal, and have its value be
the data field. Then you can put that parameter in the header.
Carmine
"Jörg Krumm" wrote:
> Hi Chris,
> thanks for your hint. I do have a value of =ReportItems!textbox1.value . I
> just made a mistake in the posting :)
> Joerg
> "Chris Conner" <Chris.Conner@.NOSPAMPolarisLibrary.com> schrieb im
> Newsbeitrag news:%23fEyGglCHHA.3476@.TK2MSFTNGP04.phx.gbl...
> > Try:
> > =ReportItems!textbox1.value
> >
> >
> > "Jörg Krumm" <jeykey-news@.justmail.de> wrote in message
> > news:e5MI%23WiCHHA.4016@.TK2MSFTNGP02.phx.gbl...
> >> Hi there,
> >>
> >> probably the most common problem with srs: how to insert data fields in
> >> page header or footer?
> >>
> >> The described workaround to reference ReportItems in the body does not
> >> work for me, don´t know why.
> >>
> >> Here is what I did:
> >>
> >> I have a footer that must display fields from a query.
> >> I placed a textbox named textbox1 in the body with a value of
> >> =First(Fields!Field123.Value
> >> I added a textbox in the footer with a value of =ReportItems!textbox1
> >>
> >> When I render the report the textbox in the body contains the data as
> >> expected, but the textbox in the footer is just empty. No Errors, no
> >> warnings!
> >>
> >> I use SQL2000 SP4 with Reporting Services SP2.
> >>
> >> Any suggestions are highly appreciated :)
> >>
> >> greetinx,
> >>
> >> Joerg Krumm
> >>
> >
> >
>
>