Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Formatting Or Data Conversion Post Reply Post New Topic
Author Message
JohnS.
Newbie
Newbie
Avatar

Joined: 08 Mar 2007
Location: United States
Online Status: Offline
Posts: 18
Quote JohnS. Replybullet Topic: Formatting Or Data Conversion
    Posted: 28 Mar 2007 at 11:54am
Hey All,
 
I am not sure how to do this. I have tried many ways so far and no luck. One of my reports is a percentage list, That gives percentage of completion of all projects. I have my projects grouped by Project number and in the details section i have the Phases of a project and they list each percentage of the project. For example a project could have 1 - 10 phases that means that there could be 1 or 10 different percentages that need to be totalled. The only problem is that the feilds them selves are not numeric fields the are text fields. I am having trouble trying to come up with a running to total that will total these feilds converted from a string to a Double.  
 
Any ideas on conversion to so i can have my totals.
 
JohnS.
Thanks
IP IP Logged
BrianBischof
Admin Group
Admin Group
Avatar

Joined: 09 Nov 2006
Online Status: Offline
Posts: 2458
Quote BrianBischof Replybullet Posted: 28 Mar 2007 at 2:05pm
Create a formula that simply converts the text to a number using CDouble(). Then create a Running Total field and that formula. It will add up the numeric equivalents for you.

Edited by BrianBischof - 28 Mar 2007 at 2:06pm
Please support the forum! Tell others by linking to it on your blog or website:<a href="http://www.crystalreportsbook.com/forum/">Crystal Reports Forum</a>
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.029 seconds.