Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Formatting of mailing address Label, not consistent

Formatting of mailing address Label, not consistent

Formatting of mailing address Label, not consistent

I have some code to get address for mailing list.
It all works and the address is pulled out in a field called Contact Address Block which i can drop onto my formatted report which has three columns set up for the labels. All is good and i have a full page of labels ready to print. However, Because some of the labels have 6 lines and others 7 lines the labels are offset and don't print out within the labels.

Can anyone give advice on padding out the 6 line label to 7. I've tried all sorts but keep getting errors and am getting very frustrated now.

This is the code which produces labels.....
select dbo.TblPupilManagementPupils.txtSchoolID, dbo.TblPupilManagementPupils.txtForename AS ForeName, dbo.TblPupilManagementPupils.txtSurname AS Surname,
dbo.TblPupilManagementPupils.txtFullName AS FullName, dbo.TblPupilManagementPupils.txtPreName AS PreferredName, dbo.TblPupilManagementPupils.txtForm AS Form,
dbo.TblPupilManagementPupils.txtSiblingsFormList + char(13) + char(10)
+ dbo.TblPupilManagementAddresses.txtLabelSalutation + char(13) + char(10)
+ dbo.TblPupilManagementAddresses.txtAddress1 + CASE txtAddress2 WHEN '' THEN ' ' ELSE char(13) + char(10)
+ txtAddress2 END + CASE txtAddress3 WHEN '' THEN ' ' ELSE char(13) + char(10) + txtAddress3 END + CASE txtTown WHEN '' THEN ' ' ELSE char(13) + char(10)
+ txtTown END + CASE txtCounty WHEN '' THEN '' ELSE char(13) + char(10) + txtCounty END + CASE txtCountry WHEN '' THEN '' ELSE char(13) + char(10)
+ txtCountry END + CASE txtPostcode WHEN '' THEN '' ELSE char(13) + char(10)+ txtPostcode END AS ContactAddressBlock
FROM dbo.TblPupilManagementAddresses

RE: Formatting of mailing address Label, not consistent

Many apologies. Please disregard thread. I've spent to many years working with Crystal Reports and didnt realise SSRS had a similar function to fix the length of the output. I'm sorted now.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close