Hi all, i currently have a crystal report in my project and i'm 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.
carrotop
Member
73 Points
81 Posts
Crystal Report Formula
Apr 09, 2012 07:19 AM|LINK
Hi all, i currently have a crystal report in my project and i'm 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.
Basquiat
Contributor
2382 Points
634 Posts
Re: Crystal Report Formula
Apr 09, 2012 03:20 PM|LINK
carrotop
Member
73 Points
81 Posts
Re: Crystal Report Formula
Apr 10, 2012 03:20 AM|LINK
hi basquiat, yea i am not grouping them..