Grouping In Crystal Report.

Question

0.00/5 (No votes)

See more:

I have some fields in a table, in which 'ID' column is also there. And I want to group the records according to the same.eg,

Table1

ID Start   End      Total
----------------------
1  101     200       100
1  201     300       100
2  301     400       100
2  401     500       100

This is a table, on which I want to generate Crystal Report as follows,
Grouping will perforn on column 'ID', Total will get added.

ID  Start  End  Total
--------------------
1   101    300   200
2   301    500   200

Please help asap, thanks in adv.

Posted 28-Aug-11 23:17pm

Harshad-HBK

Updated 28-Aug-11 23:18pm

v2

Add a Solution

2 solutions

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)

satyanarayana p.j · Answer 1 · 2011-08-28T23:31:00

Solution 1

First prepare ADO.NET Dataset in your Application.

Then Drag & Drop the Column required for U.

& in code Send the SQL Select Statement with Group by Clause.

Posted 28-Aug-11 23:31pm

satyanarayana p.j

Comments

Harshad-HBK 29-Aug-11 6:10am

Thanks 4 the solution...
still getting error to retrieve group total.

Yogesh Pednekar · Answer 2 · 2011-08-28T23:33:00

Solution 2

Create a group for ID column in crystal report.

Drag column ID, Start, End on crystal report between the group header and footer.

After that create a running total for column total.

Then drag the running total variable on crystal report

Posted 28-Aug-11 23:33pm

Yogesh Pednekar

Comments

Harshad-HBK 29-Aug-11 5:47am

Thanks 4 the solution...
still getting some error in getting running total.
It displays all total, instead group total.

Yogesh Pednekar 29-Aug-11 6:23am

On running total box you will find evaluate

select the change of group radio button and select the id group

do same with reset of running total