Report Record Count in Header Section

Do anyone know how to do a count on the number of records in a data set and
display the information in the header section of the report? I can easily
perform this operation in the data section using the Count() method against
the data set, but RS does not allow datasets/fields to be referenced in the
header section. By required design, this record count textbox is above a
page count textbox (which must also be in the header since it's a global
variable), so I can't cheat by moving the field to the data section - it must
live in the header. Any help would be appreciated.
The only alternatives that I can think of are:
-Somehow reference a textbox that is using the Count() method in the data
section, and display the same text in the header section. (I have no idea
how I would do this.)
-Determine the record count and page count in SQL to move both fields to the
data section. I didn't want to do this because if the report layout changes,
the page count might not be correct.You can achieve this by using scope. Get the count of records for the table
level as follows:
In the header section add an expression as follows:
=Count(<field>, "<table name>")
Regards,
SaraS|||Unfortunately, you can't use Count() or CountRows() in headers or footers.
"saras" wrote:
> You can achieve this by using scope. Get the count of records for the table
> level as follows:
> In the header section add an expression as follows:
> =Count(<field>, "<table name>")
> Regards,
> SaraS
>|||Have you tried to use Report!Items.whatever.Value?
These fields are used in headers and footers. If you manage to get this data
in data section you can copy it to header section by
Report!Items.fieldname.Value.
"Bryan" wrote:
> Do anyone know how to do a count on the number of records in a data set and
> display the information in the header section of the report? I can easily
> perform this operation in the data section using the Count() method against
> the data set, but RS does not allow datasets/fields to be referenced in the
> header section. By required design, this record count textbox is above a
> page count textbox (which must also be in the header since it's a global
> variable), so I can't cheat by moving the field to the data section - it must
> live in the header. Any help would be appreciated.
> The only alternatives that I can think of are:
> -Somehow reference a textbox that is using the Count() method in the data
> section, and display the same text in the header section. (I have no idea
> how I would do this.)
> -Determine the record count and page count in SQL to move both fields to the
> data section. I didn't want to do this because if the report layout changes,
> the page count might not be correct.
>