Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Technical Questions
Message Icon Topic: field delimited with semicolons Post Reply Post New Topic
Author Message
elie234
Groupie
Groupie


Joined: 21 Aug 2009
Online Status: Offline
Posts: 68
Quote elie234 Replybullet Topic: field delimited with semicolons
    Posted: 02 Oct 2009 at 11:21am
I am dealing with a table that holds a field for the opening balance of an account at the start of a year and then in a semi colon delimited field lists the period balance (i.e. net change) of that account for each month of the year. On the report I would like to display the current balance for the account which would mean I would have to sum up all of the values in the semi colon delimited field and add the sum to the opening balance.
My question then is how to parse the field to separate out each of these period balance values. Thanks for any help.
IP IP Logged
FrnhtGLI
Senior Member
Senior Member
Avatar

Joined: 22 May 2009
Online Status: Offline
Posts: 347
Quote FrnhtGLI Replybullet Posted: 02 Oct 2009 at 11:40am
13 formulas:
 
split({periodbalance}, ';')[1]
 
for January on through [12] for December (if that's how they're split).
 
Last formula to add the 12 fields and the opening balance. That's how I would do it, may be an easier way, may not. Give it a shot.
 
 
EDIT:
 
I haven't tried this but you may be able to just make one formula:
 
split({periodbalance}, ';')[1]
+
split({periodbalance}, ';')[2]
+......
+
{openingbalance}
 
 
I've never tried it but would be interrested to see if it works.
 
 


Edited by FrnhtGLI - 02 Oct 2009 at 11:44am
IP IP Logged
elie234
Groupie
Groupie


Joined: 21 Aug 2009
Online Status: Offline
Posts: 68
Quote elie234 Replybullet Posted: 09 Oct 2009 at 12:01pm
Thanks! The single formula worked.
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.031 seconds.