all groups > sql server reporting services > july 2005 >
You're in the

sql server reporting services

group:

record count, page header, not working


record count, page header, not working Eskimo
7/11/2005 1:53:17 PM
sql server reporting services:
I have a text box field on my report, it's value =Count(Fields!IdItem.Value)
why can't I put this on my page header?

the error message:
c:\sql reports\items report\Items Report.rdl The value expression for the
textbox ‘textbox39’ refers to a field. Fields cannot be used in page headers
or footers.

When I put it on the body of the report it works fine...
why can't I get the dataset.rows.count?

--
Re: record count, page header, not working Chris McGuigan
7/15/2005 2:09:42 AM
Eskimo,
You can't refer to data items in the header or footer. It's a
limitation of RS.

You can create a 'pseudo-header' in the body and set controls to
'RepeatWith' another data region.

Hope that helps
Chris



[quoted text, click to view]
AddThis Social Bookmark Button