|
|
You're in the
sql server reporting services
group:Data in Report Headers
sql server reporting services:
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
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. [quoted text, click to view] "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 [quoted text, click to view] "Lev Semenets [MSFT]" <levs@microsoft.com> wrote in message news:umi8F86LHHA.3588@TK2MSFTNGP06.phx.gbl... value.My favorite solution is to use internal parameters with query-based default -- This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "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 > >
[quoted text, click to view] "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 [quoted text, click to view] "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.
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |