Print Page | Close Window

Left, Mid, Right

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21143
Printed Date: 27 Apr 2024 at 6:59pm


Topic: Left, Mid, Right
Posted By: Kitty1
Subject: Left, Mid, Right
Date 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!


Replies:
Posted By: DBlank
Date 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?

Posted By: Kitty1
Date Posted: 03 Nov 2014 at 10:16am
hi, thanks for the reply. it displays correctly

Posted By: DBlank
Date 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?

Posted By: Kitty1
Date Posted: 06 Nov 2014 at 11:21am
Thanks!


Print Page | Close Window