i want sum of two field in the crystal report

Question

2.50/5 (2 votes)

See more:

Hello sir...i have two field Min & Sec..and its datatype is nvarchar...i want to add summation of this two field....in crystal report....how can i do that....plz help me......

Posted 27-Jan-13 21:26pm

Mrugesh08

Add a Solution

Comments

[no name] 28-Jan-13 3:27am

use running total for the sum in crystal report.

Mrugesh08 28-Jan-13 3:29am

sir....my field type is nvarchar...running total not display sum....its only display in the dropdown to count....and many more...

Mrugesh08 28-Jan-13 3:32am

when datatype is only numeric than the running total is display the sum function...plz sir tell me another way...sir can u tell me using formula workshop???plz sir ..

[no name] 28-Jan-13 3:35am

create one formula and convert your field data to number and use formula for running total

Mrugesh08 28-Jan-13 3:35am

sir plz help me....

Mrugesh08 28-Jan-13 3:36am

sir can u plz tell me how can i write the formula..??

Mrugesh08 28-Jan-13 3:38am

ToNumber({job_table.min } + ":" + {job_table.sec})...i have written this way..but i want colon btween the sum...but above code show me error..plz sir help...how can i write....

Mrugesh08 28-Jan-13 3:45am

sir..plz tell me...how can i do that...

Mrugesh08 28-Jan-13 3:50am

sir..plz help me...

guruprakashc 30-Jan-13 4:10am

ToNumber{job_table.min } + ToNumber{job_table.sec}

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)