Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: Left, Mid, Right Post Reply Post New Topic
Author Message
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Topic: Left, Mid, Right
    Posted: 29 Oct 2014 at 5:27am
Hi, I am trying to do a formula to add 3 fields into one.

this is my formula: left ({V_JOB_HEADER.JOB},6)+mid ({V_JOB_HEADER.SUFFIX},3)+right ({V_JOB_DETAIL.SEQ},6)

This is the result I am getting: 0185000000100

The first 6 are correct (018500) the second 3 are correct (000) but the third number is chopping off 3 zeros. (should be 000100)

Can anyone see what I am doing wrong?

Thanks!
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 29 Oct 2014 at 5:36am

if you display V_JOB_DETAIL.SEQ on the same location you are placing the formula field (header, detail or footer) in the report what is shown in that original field?

IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 03 Nov 2014 at 10:16am
hi, thanks for the reply. it displays correctly
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 03 Nov 2014 at 1:57pm
i would break it into 3 formulas and test these out to see what each is returning.
it may be the mid() formula that is actually not returning the correct values.
what happens when you make each part its own formula and display these on the desired section?
IP IP Logged
Kitty1
Senior Member
Senior Member
Avatar

Joined: 14 Apr 2010
Online Status: Offline
Posts: 159
Quote Kitty1 Replybullet Posted: 06 Nov 2014 at 11:21am
Thanks!
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.047 seconds.