how to Add value in Crystal report ?

Question

0.00/5 (No votes)

See more:

I have a table like this

HTML

slip_no    Productname     Price
  1         Addidas        1500
  2         Bata           1000
  3         Bata           1000
  4         Reebook        1200
  5         Reebook        1200

I need to show this table in crystal report like this

HTML

Product Name   total Price
Addidas          1500
Bata             2000
Reebook          2400

I want to show product name with no duplicate value and add price column in group for example all addidas product price will add all bata price will add and show.

I use groupnamefield for productname and its work but not for price ...
sorry for my bad english Hope you understand
Help me plz.
thanks in advance

Posted 31-Aug-13 0:00am

varuncodee

Updated 31-Aug-13 0:01am

v2

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)

manikjeyam · Answer 1 · 2013-08-31T00:07:00

Solution 1

set formula filed sum({Product name(Groupid),Price))

Posted 31-Aug-13 0:07am

manikjeyam

Comments

varuncodee 31-Aug-13 6:25am

when i try this formula i get error ..it says "a number field or currency field is required here"
even Price field is number field.

manikjeyam 31-Aug-13 6:31am

1.Check this first Price filed is a integer file or varchar filed
2.If this correct mean
check ur formula filed
sum({ur groupid},pricecolun)

varuncodee 31-Aug-13 6:53am

thank you soo much for d reply :)
i use this formula
sum(GroupName ({SellProduct.P1Name}),{SellProduct.Price})

my price field is integer .. but when i got error "a number field or currency field is required here" The "GroupName ({SellProduct.P1Name})" field got highlighted and this "GroupName ({SellProduct.P1Name})" field is string ..

manikjeyam 31-Aug-13 6:56am

Ok you save Produt id replace proct name Product id I mean
Example
Producid product Name
1 addidas
you group with product id only not product name

varuncodee 31-Aug-13 7:33am

sorry but how can i use productid as group because i use productname as group so value will not repeat ..

manikjeyam 31-Aug-13 7:54am

Ok now report working or not