Print Page | Close Window

joining text and field data

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Tips and Tricks
Forum Discription: Have you learned some great tricks to share with the group? Post them here!
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=10610
Printed Date: 02 May 2025 at 12:13pm


Topic: joining text and field data
Posted By: Pete Plumer
Subject: joining text and field data
Date Posted: 22 Jul 2010 at 8:17am
First of all, I am not an educated IT type, just doing the best that I can, that was saddled with modifying some canned reports to meet a customer's requirements.  Our customer is requiring bar-coded packing slips with their shipments, and these are not supported by the canned reports in our ERP system.  I need to join a prefix to report data, and in most cases add place-holding characters  for items that may vary in length.  The prefix is unique such that it will distinguish purchase order from part number from quantity, etc. etc.  Can someone help me out?  I will give up my next-born child for some assistance.  Sorry, the first two are already spoken for. 


Replies:
Posted By: Emir_W
Date Posted: 22 Jul 2010 at 10:33am
you can combine the fields that you want to printed as barcode in a formula.
 
create a formula which contains all fields that you want.
e.g.:  trim({tbl.partno})+trim({tbl.itmcode})
 
and change the font with barcode font.
 
some cases, you will need to add '*' in front of this formula and at the end of it.
so, it will be printed as '*'+trim({tbl.partno})+trim({tbl.itmcode})+'*'
 
 
hope it help.
 


-------------
Emir W


Print Page | Close Window