Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Label Torture!! Post Reply Post New Topic
Author Message
esther31
Groupie
Groupie


Joined: 19 Dec 2011
Online Status: Offline
Posts: 50
Quote esther31 Replybullet Topic: Label Torture!!
     Posted: 16 Nov 2012 at 1:37am
Hello
 
I am trying to setup a label run for Avery L7163 labels. i have setup the below:
 
Details A - STU_NAME
Details B - @ADD1 (formula converting field to Propercase)
Details C - @ADD2
Details D - @ADD3
Details E - @ADD4
Details F - @ADD5
Details G - STU_HAPC
 
I have then grouped by DPT_CODE and then STU_CODE. I have also suppresed blank sections.
 
When i run the report from Infoview the first few are fine but then the alignment goes out so the name of STU X is appearing on the previous label etc.
 
Any ideas?
 
I've tried everything i can think of and am now tearing my hair out as I know it's going to be something simple!
 
Thanks
 
IP IP Logged
shanth
Groupie
Groupie


Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Quote shanth Replybullet Posted: 16 Nov 2012 at 5:06am
Right Click on the Field in Crystal Application->Format Field-> Common Tab->Check Can Grow Box->Enter 1 in Maximum Number of lines
OR
Check Lock position and size Box in same Tab
IP IP Logged
esther31
Groupie
Groupie


Joined: 19 Dec 2011
Online Status: Offline
Posts: 50
Quote esther31 Replybullet Posted: 16 Nov 2012 at 5:43am
Hello
 
Neither of these have worked, any other suggestions? it's literally driving me mad!
 
Thanks
IP IP Logged
shanth
Groupie
Groupie


Joined: 06 Aug 2012
Location: United States
Online Status: Offline
Posts: 75
Quote shanth Replybullet Posted: 16 Nov 2012 at 6:11am
Please clear me that, Details A-G are columns in Details Section, Right?
And You have 2 Groups, Can you explain a bit, which fields going out of alignment and where they are located(section)? Thanks
IP IP Logged
comatt1
Senior Member
Senior Member
Avatar

Joined: 19 May 2011
Online Status: Offline
Posts: 337
Quote comatt1 Replybullet Posted: 16 Nov 2012 at 9:27am
try using trim or rtrim on the text from the formula
IP IP Logged
esther31
Groupie
Groupie


Joined: 19 Dec 2011
Online Status: Offline
Posts: 50
Quote esther31 Replybullet Posted: 18 Nov 2012 at 9:21pm

Hello

It's not exactly the alignment, basically what is happening is the first few labels are fine but then the name and address on the next label startss to creep onto the previous label. I've checked the label dimensions on page setup and it is all fine. Completely stumped now!
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 19 Nov 2012 at 10:29am
Do you have the address fields in separate sections, with the sections set to suppress if blank?  If so, that is what is causing the addresses to creep up.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
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

HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | PRIVACY | CLICK PLAYS | BAEZL

© 2004-2026 Brian Bischof. All Rights Reserved.