Click here to Skip to main content
14,880,672 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
Hi friends,
I am new in crystal report.I have this months presenty report of employees & i want to count the present days and absent days for particular employee.
I can arrange there presenty in a single row with 31 columns and create two extra columns for present days and absent days.

please help me to count the total present and absent days in that row.

I can also use the running fields but it doesn't work.
please help me

1 solution

If running fields aren't an option (why not, how does it not work?)...

Create a formula field for summing the values. In the formula, you can query other fields and sumarize only the values that meet some criteria.

I don't have CR installed at my new workplace, but the instructions are something along the lines:

For plain summary: right click the field, select formula / summary or something like that and select the operation SUM, field present_days

For formula, expand formula in the document layout on the left side (usually), right click and select new formula, give it a name and write your code.

Here is comprehensive tutorial with most common formula examples[^]

If this helps please take time to accept the solution. Thank you.

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