Computing data total by field value

Question

0.00/5 (No votes)

See more:

I am trying to make an application that's using crystal report that generates report
i am confused how to use the formula function
I tried the Parameter Function but It only shows the details with the same value with the textbox

What im trying to make is
To compute the Total Number of Employees from all Department but diplayed and sorted/filtered by department.

e.g.

Employee Profile

HR Department
            Male     Female    Total:
             5         6         11
             6         3         9
Total :     11         9         20

What I have tried:

Can i do the computations and sorting/filtering in the crystal report or should i do it in the database using vb?
thanks!

Posted 1-Sep-21 15:29pm

Beginner213456

Updated 1-Sep-21 17:29pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Wendelius · Answer 1 · 2021-09-01T17:29:00

Solution 1

Based on the example it looks like you could use a crosstab report to do the calculation fot both rows and columns.

For example, have a look at Crystal Reports Tutorial - Cross-tab report (Lesson 7) - YouTube[^]

Posted 1-Sep-21 17:29pm

Wendelius

Comments

Beginner213456 2-Sep-21 20:03pm

can i apply this in my vb.net winforms?
i think the toturial is application in sql?

Wendelius 2-Sep-21 23:21pm

Not sure what you mean. The tutorial shows how to organize the report. The data can come from a SQL database, a dataset in the program etc. That depends how the connection on your report is defined.

Beginner213456 5-Sep-21 20:03pm

I am using ms access as my database,
in the Total Fields.
Its not saved in the database
my only fields are male,female,total and the Department Total can only be seen in the Crystal Report.
is there a way to achieve this.
or should i add a fields with the department total?

Wendelius 5-Sep-21 23:16pm

Storing a calculated field in the database should not be done. Instead the calculation can be done when the data is fetched or shown, as in your case.

Did you go through the tutorial link? It shows how summary fields are selected in a crosstab