Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2016 : Report Design  
Message Icon Topic: String Manipulation Post Reply Post New Topic
Page  of 2 Next >>
Author Message
Teddy555
Newbie
Newbie
Avatar

Joined: 23 Jan 2017
Location: Saint Lucia
Online Status: Offline
Posts: 21
Quote Teddy555 Replybullet Topic: String Manipulation
    Posted: 19 Oct 2017 at 3:42am
Good day ,

Is it Possible to have the last record in a string field print first , rather than it being the other way around . Reason being i have a payslip with deductions and earnings coming from the same field and when the report is generated the deductions column in my report is printed lower than the earnings rather than being level .
T.Calderon
IP IP Logged
kevlray
Admin Group
Admin Group
Avatar

Joined: 29 Oct 2009
Online Status: Offline
Posts: 1345
Quote kevlray Replybullet Posted: 19 Oct 2017 at 6:36am
First off, we need to work on terminology. A record is considered a row in a table of a database.  So your first statement does not make sense.

But further reading, it appears that you have an alignment issue.  with the fields in question.  Which should be easy to resolve.

If the data is in all one field then there should not be an alignment issue.
IP IP Logged
Teddy555
Newbie
Newbie
Avatar

Joined: 23 Jan 2017
Location: Saint Lucia
Online Status: Offline
Posts: 21
Quote Teddy555 Replybullet Posted: 20 Oct 2017 at 4:08am
Let me explain my situation a little better .

I have one field which houses both earnings and deductions .
I am creating a payslip to be run in sage so that the employees can be paid with the ability to see how they are getting paid and what deductions they have incurred.

Example of layout :
Earnings:               Deductions:
Wages                    National Insurance
Service Charge          Bank Charges
Holiday Pay
Overtime


In truth this is what i need to accomplish , the layout above . The problem i am experiencing is that both the data on the left and right come from the same field . Is there a way to seperate the data like listed above . Just incase anyone doesnt understand .
When the field is added to the report it looks like :


Wages                          
Service Charge
Holiday Pay
Overtime
Bank Charges
National Insurance.

I need to split the above into two Columns if thats possible .
T.Calderon
IP IP Logged
Teddy555
Newbie
Newbie
Avatar

Joined: 23 Jan 2017
Location: Saint Lucia
Online Status: Offline
Posts: 21
Quote Teddy555 Replybullet Posted: 20 Oct 2017 at 4:18am
There is no Alignment Issue .

View attached image .

https://ibb.co/nxUYi6

This is what the report looks like currently .
I am able to accomplish this by including a supression formula on the field to say :

if {@Shortdesc} like ['Hoilday Pay','Off With Pay','Overtime','Service Charge','Sick Benefit','Sick Benefit 2','Tips','Wages','ZNet Pay','Comp. Leave','Vacation Pay'] then yes

Every Earning is listed in the Brackets of my Formula.
So when the report is run it basically leaves the line blank if the Earning exists for that employee and prints everything outside the formula range which would be the deductions in this case. However i need it to remove the earnings listed in the formula instead of just leaving it blank.
Hope you do understand.





T.Calderon
IP IP Logged
Teddy555
Newbie
Newbie
Avatar

Joined: 23 Jan 2017
Location: Saint Lucia
Online Status: Offline
Posts: 21
Quote Teddy555 Replybullet Posted: 23 Oct 2017 at 9:22am
Can Somebody Please Assist ?
T.Calderon
IP IP Logged
Teddy555
Newbie
Newbie
Avatar

Joined: 23 Jan 2017
Location: Saint Lucia
Online Status: Offline
Posts: 21
Quote Teddy555 Replybullet Posted: 25 Oct 2017 at 9:21am
Does my Task make no sense to the community ?

:( :(
T.Calderon
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8774
Quote DBlank Replybullet Posted: 25 Oct 2017 at 9:51am
Are you trying to concatenate multiple rows into one field as well? If so then use a shared variable to only concatenate items that fit your earnings category display that in the group footer next similar shared variable formulas that only include 'deductions'
IP IP Logged
Teddy555
Newbie
Newbie
Avatar

Joined: 23 Jan 2017
Location: Saint Lucia
Online Status: Offline
Posts: 21
Quote Teddy555 Replybullet Posted: 30 Oct 2017 at 10:30am
Actually i am trying to achieve the opposite of that , the one field has all the information and i would like to split it into two different fields depending on the Employee Data.
T.Calderon
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 8774
Quote DBlank Replybullet Posted: 31 Oct 2017 at 4:40am
is this all in "one field" or one column and different rows

Wages                           
Service Charge
Holiday Pay
Overtime
Bank Charges
National Insurance.
IP IP Logged
Teddy555
Newbie
Newbie
Avatar

Joined: 23 Jan 2017
Location: Saint Lucia
Online Status: Offline
Posts: 21
Quote Teddy555 Replybullet Posted: 10 Nov 2017 at 4:46am
One Column , Different Rows .
T.Calderon
IP IP Logged
Page  of 2 Next >>
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.047 seconds.