generate summary report using crystal report

Question

0.00/5 (No votes)

See more:

I want to create a summary sales report with crystal report 10.
please help as i am new in crstal report.

ProductName Sale(2009) Sale(2010)
ProdA 250 561
ProdB 360 150
----------------------------------------------
Grand Totral 610 711

I have two table
1. product master
2. Sales

ProductMaster
-------------
ProdName ProdCode
ProdA 01

Sales
-------
ProdCode Sale City Year
01 35 Mumbai 2009
01 60 Delhi 2008
02 150 Delhi 2009

Posted 15-Dec-10 0:58am

asad1605

Add a Solution

3 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)

Goutam Patra · Answer 1 · 2010-12-15T01:05:00

Solution 1

You need PIVOT[^] to get the result. Or may be a cross tab report will help you.

Posted 15-Dec-10 1:05am

Goutam Patra

Toniyo Jackson · Answer 2 · 2010-12-15T01:07:00

Solution 2

Try this,
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-stepbystep.htm[^]
http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-without-database.htm[^]

Posted 15-Dec-10 1:07am

Toniyo Jackson

thatraja · Answer 3 · 2010-12-15T09:33:00

Solution 3

You can achieve that using Crosstab Report in Crystal reports.

Nice article with step by step explanations. Go ahead.

Creating a Crosstab Report in Visual Studio 2005 Using Crystal Reports[^]

Do customizations based on your need.

Posted 15-Dec-10 9:33am

thatraja

Updated 15-Dec-10 13:42pm

v2