rowcount in header not printing

I have figured out that you really can't place a function like
CountRows directly in a report header. So I tried creating a textbox in
the header that points to a textbox in the body that does the
calculation. There expression for this new textbox looks like the
following:
ReportItems!tbRowCount.value
Since I don't want to display two row counts in a report... I have set
the textbox in the page body to Hidden = True.
Interestingly... the following is what happens:
- In VS.NET preview: header row count renders on the first page, but
none of the others.
- In IE 6: header row count renders on all pages like I was hoping.
Yay!
- When printing from IE 6: header row count renders on the first page,
but none of the others.
What matters the most to me is that the row count shows up in on all
pages in both IE and IE printing. BTW... I tried moving the calculation
into the body and setting its repeat with to the correct dataset. This
resulted in similar behavior: print 1st page... then not again for the
rest.
So has anyone figured this out? BTW I'm using RS 2003 and not the new
version.Hi Scott,
How did you link the TextBox in the header with the one in the body?
Bryan
"scott.d" wrote:
> I have figured out that you really can't place a function like
> CountRows directly in a report header. So I tried creating a textbox in
> the header that points to a textbox in the body that does the
> calculation. There expression for this new textbox looks like the
> following:
> ReportItems!tbRowCount.value
> Since I don't want to display two row counts in a report... I have set
> the textbox in the page body to Hidden = True.
> Interestingly... the following is what happens:
> - In VS.NET preview: header row count renders on the first page, but
> none of the others.
> - In IE 6: header row count renders on all pages like I was hoping.
> Yay!
> - When printing from IE 6: header row count renders on the first page,
> but none of the others.
> What matters the most to me is that the row count shows up in on all
> pages in both IE and IE printing. BTW... I tried moving the calculation
> into the body and setting its repeat with to the correct dataset. This
> resulted in similar behavior: print 1st page... then not again for the
> rest.
> So has anyone figured this out? BTW I'm using RS 2003 and not the new
> version.
>