| Author |
Message |
Teddy555
Newbie
Joined: 23 Jan 2017
Online Status: Offline
Posts: 22
|
   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 Logged |
|
|
kevlray
Admin Group
Joined: 29 Oct 2009
Online Status: Offline
Posts: 1587
|
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 Logged |
|
Teddy555
Newbie
Joined: 23 Jan 2017
Online Status: Offline
Posts: 22
|
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 Logged |
|
Teddy555
Newbie
Joined: 23 Jan 2017
Online Status: Offline
Posts: 22
|
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 Logged |
|
Teddy555
Newbie
Joined: 23 Jan 2017
Online Status: Offline
Posts: 22
|
Posted: 23 Oct 2017 at 9:22am |
|
Can Somebody Please Assist ?
|
|
T.Calderon
|
|
IP Logged |
|
Teddy555
Newbie
Joined: 23 Jan 2017
Online Status: Offline
Posts: 22
|
Posted: 25 Oct 2017 at 9:21am |
|
Does my Task make no sense to the community ?
:( :(
|
|
T.Calderon
|
|
IP Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
Teddy555
Newbie
Joined: 23 Jan 2017
Online Status: Offline
Posts: 22
|
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 Logged |
|
DBlank
Moderator
Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
|
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 Logged |
|
Teddy555
Newbie
Joined: 23 Jan 2017
Online Status: Offline
Posts: 22
|
Posted: 10 Nov 2017 at 4:46am |
|
One Column , Different Rows .
|
|
T.Calderon
|
|
IP Logged |
|
|
|
