Click here to Skip to main content
15,851,902 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
Can We use CountRows Function in Page Header or Page Footer in SSRS?Because when i'm using Count function in Page Header,Its working fine, but when i'm using the Same with CountRows Its Giving error like "CountRows Cannot be used in page headers or footers "

1 solution

As error states, you cannot put aggregate methods in header or footer!

Alternative though can be to put a hidden field in body of report doing the same and then access that control in header/footer.
Share this answer
Dalek Dave 25-Nov-10 9:20am    
Good Call.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900