Data in Report Headers

I'm having the devil of a time working around RS limitations here.
I have a report that displays a purchase order. ON all pages but the first I'm supposed to display a header like this:
From: OUR NAME To: Vendor Name
PO 123456 Page 2 of 4 Date: 01 January 2007
The three non-date fields in the header appear in the datasets used in the report. After much trial and error I ended up
creating three hidden textboxes in the report body that contain the data I want to use in the header. I then use separate
textboxes in the header which refer to those textboxes in the body.
Aside from the fact that this is a huge PITA, I find that this header only works properly on the first page of the report!
ON pages 2 and later the fields are empty!
Any suggestions? I'm pulling my hair out here on something that should be quite simple...
BarryMy favorite solution is to use internal parameters with query-based default
value.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry Seymour" <bseymour@.spamcop.net> wrote in message
news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> I'm having the devil of a time working around RS limitations here.
> I have a report that displays a purchase order. ON all pages but the first
> I'm supposed to display a header like this:
> From: OUR NAME To: Vendor Name
> PO 123456 Page 2 of 4 Date: 01 January 2007
> The three non-date fields in the header appear in the datasets used in the
> report. After much trial and error I ended up
> creating three hidden textboxes in the report body that contain the data I
> want to use in the header. I then use separate
> textboxes in the header which refer to those textboxes in the body.
> Aside from the fact that this is a huge PITA, I find that this header only
> works properly on the first page of the report!
> ON pages 2 and later the fields are empty!
> Any suggestions? I'm pulling my hair out here on something that should be
> quite simple...
> Barry
>|||Otay... lemme research what the heck you mean and I'll come back if I don't get it. <g>
Barry
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:umi8F86LHHA.3588@.TK2MSFTNGP06.phx.gbl...
My favorite solution is to use internal parameters with query-based default
value.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"Barry Seymour" <bseymour@.spamcop.net> wrote in message
news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> I'm having the devil of a time working around RS limitations here.
> I have a report that displays a purchase order. ON all pages but the first
> I'm supposed to display a header like this:
> From: OUR NAME To: Vendor Name
> PO 123456 Page 2 of 4 Date: 01 January 2007
> The three non-date fields in the header appear in the datasets used in the
> report. After much trial and error I ended up
> creating three hidden textboxes in the report body that contain the data I
> want to use in the header. I then use separate
> textboxes in the header which refer to those textboxes in the body.
> Aside from the fact that this is a huge PITA, I find that this header only
> works properly on the first page of the report!
> ON pages 2 and later the fields are empty!
> Any suggestions? I'm pulling my hair out here on something that should be
> quite simple...
> Barry
>|||"Barry Seymour" wrote:
> Otay... lemme research what the heck you mean and I'll come back if I don't get it. <g>
> Barry
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:umi8F86LHHA.3588@.TK2MSFTNGP06.phx.gbl...
> My favorite solution is to use internal parameters with query-based default
> value.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Barry Seymour" <bseymour@.spamcop.net> wrote in message
> news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> > I'm having the devil of a time working around RS limitations here.
> >
> > I have a report that displays a purchase order. ON all pages but the first
> > I'm supposed to display a header like this:
> >
> > From: OUR NAME To: Vendor Name
> > PO 123456 Page 2 of 4 Date: 01 January 2007
> >
> > The three non-date fields in the header appear in the datasets used in the
> > report. After much trial and error I ended up
> > creating three hidden textboxes in the report body that contain the data I
> > want to use in the header. I then use separate
> > textboxes in the header which refer to those textboxes in the body.
> >
> > Aside from the fact that this is a huge PITA, I find that this header only
> > works properly on the first page of the report!
> > ON pages 2 and later the fields are empty!
> >
> > Any suggestions? I'm pulling my hair out here on something that should be
> > quite simple...
> >
> > Barry
> >
> >
>
>|||Did you find out how to fix this? I'm having the same problem.
Ken
"Barry Seymour" wrote:
> Otay... lemme research what the heck you mean and I'll come back if I don't get it. <g>
> Barry
> "Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message news:umi8F86LHHA.3588@.TK2MSFTNGP06.phx.gbl...
> My favorite solution is to use internal parameters with query-based default
> value.
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Barry Seymour" <bseymour@.spamcop.net> wrote in message
> news:Oa2GTf4LHHA.5016@.TK2MSFTNGP04.phx.gbl...
> > I'm having the devil of a time working around RS limitations here.
> >
> > I have a report that displays a purchase order. ON all pages but the first
> > I'm supposed to display a header like this:
> >
> > From: OUR NAME To: Vendor Name
> > PO 123456 Page 2 of 4 Date: 01 January 2007
> >
> > The three non-date fields in the header appear in the datasets used in the
> > report. After much trial and error I ended up
> > creating three hidden textboxes in the report body that contain the data I
> > want to use in the header. I then use separate
> > textboxes in the header which refer to those textboxes in the body.
> >
> > Aside from the fact that this is a huge PITA, I find that this header only
> > works properly on the first page of the report!
> > ON pages 2 and later the fields are empty!
> >
> > Any suggestions? I'm pulling my hair out here on something that should be
> > quite simple...
> >
> > Barry
> >
> >
>
>|||We had a similar problem.
My workaround was to dump the Report Header and setup a 'dummy' group, it
must be the first group. 'Include Group Header' don't 'Repeat Group Header'
and don't 'Include Group Footer'.
Whatever you put it this group, it will accept parameters and dataset data
will only appear once at the beginning of the report.
Hope this helps