Tips and Tricks
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Tips and Tricks
Message Icon Topic: joining text and field data Post Reply Post New Topic
Author Message
Pete Plumer
Newbie
Newbie


Joined: 22 Jul 2010
Online Status: Offline
Posts: 1
Quote Pete Plumer Replybullet Topic: joining text and field data
    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. 
IP IP Logged
Emir_W
Senior Member
Senior Member
Avatar

Joined: 25 Apr 2010
Online Status: Offline
Posts: 228
Quote Emir_W Replybullet 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
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.031 seconds.