Crystal Report ASP.NET

See more:

VB

ASP.NET

database

, +

Hi all, i currently have a crystal report in my project and creating a formula field which counts the total number of users and display on te rerport. However, i've deleted some data in the user table in the db before and created new ones, so the data of the user tables looks currently like:

ID UserName . .. .. . . ..

1 user1
2 user2
11 user3
..
..

In my formula field, i put the code COUNT({USERSTABLE.USERNAME}) to count the number of users inside. Hoever, the result is always 2. whether i change to count by userid or username is still 2. I think it gets stucked at 2 because i've deleted id 3-10 before in my user db. How can i make it such that it continues counting the number of usernames ignoring the deleted 3-10 userid? Thanks in advance.