New User? Sign Up  |  Sign In  |  Help
Barcode support and
tutorials from IDAutomation
and the community.
Click for the BBB Business Review of this Computers Hardware, Software & Services in Tampa FL
Resolved Questions Bookmark and Share
djdigitald

Issue with QR Code and Crystal Report

I have an issue on a Crystal Report we have for our Packing Slip. The report works fine until I add the QR Code Native Formula to it to convert a couple of fields that our customer wants barcoded. When I add the barcode formula the report duplicates the lines by however many lines we are shipping for each line i.e. 10 lines, each line has 10 duplications! When I remove the formula fields it works perfect again.

Has anyone got any ideas?

Many thanks


Application: Crystal Reports

06-21-19     115 day(s) ago    

  Report Abuse

 

Ben

Best Answer

As a test, set the field that produces a barcode from data source to a string literal such as DataToEncode = "1234567890" and run the report. Let me know what happens.

Does it duplicate the record?

Posted 110 day(s) ago

()
()
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (8)

djdigitald
I have tried what you have suggested with no change. I cannot see how the report is corrupt as I can add any field from existing data tables in the report and newly linked data tables and I have no issues.
It is only happening when I add the native or full barcode.

Posted 111 day(s) ago

()
()
   Report Abuse

Brant
Please try what I suggested below and if that does not work the report may be corrupt and you may have to make a new one from scratch.

Posted 111 day(s) ago

()
()
   Report Abuse

djdigitald
I have to remove all of the barcodes for the report to work how it should.

Posted 111 day(s) ago

()
()
   Report Abuse

Brant
Try adding more space around the barcodes so they do not conflict with other fields or the end of the sections. You can also change the height parameter to reduce the height. If that does not work, try adding the barcodes one by one to determine the one that is causing the problem. After you find the one that is causing the problem, try to move it or size it differently so that the report works properly.

Posted 111 day(s) ago

()
()
   Report Abuse

djdigitald
Before
image
After
image
Design
image


In the design screenshot I have highlighted the 3 barcodes (they do not show in the 'After' picture as it is not the correct customer.

Posted 111 day(s) ago

()
()
   Report Abuse

Brant
Can you attach a screenshot of the before and after so I can get a better idea of what is happening?

Posted 115 day(s) ago

()
()
   Report Abuse

djdigitald
Maybe I should explain it differently.

The pack slip is the shipping document we send to out customers for one of their orders.

If we send out 3 items the pack slip will have 3 lines on it. 1 for each item. When I add the barcode it creates the 3 lines but it also creates 3 instances of the same line. so 3 line 1, 3 line 2 etc...

Posted 115 day(s) ago

()
()
   Report Abuse

Brant
It sounds like the addition of the barcode is making the report larger than it was. Try reducing the size of something else so that the report is the same size and compare with the design and preview rulers.

Posted 115 day(s) ago

()
()
   Report Abuse
Email this question link to friends
You must enter an email address, if name is entered or vice-versa for each friend.
Friend #1 -
Friend #2 -
Friend #3 -
Friend #4 -
Friend #5 -
  Your comment on this question
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allows to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must starts with "http://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always starts with " http:// ")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 Characters are allowed. Current Count: 0
  Your comment on this answer
  |         |  
bold  italic  underline  strike       big  small       superscript  subscript 
  Allow you to add a link. Added links would only be converted to actual clickable link, when the domain of the link is white-listed by administrator.
Caption :
Link URL :
(Must start with "http://" or "https://")
Add  |   Cancel
  Allow to insert an image. Must be among the following file types - *.jpg, *.gif, *.png & *.bmp.
Image Url :   Upload New
(Image url must always start with "http://" or "https://")
Width : pixels
(Must not be greater than 450px. Enter 0px for no resize)
Add  |   Cancel
  Allow to insert YouTube video. Insert the video embed code.
Embed Code :
Add  |   Cancel
Up to 5000 characters are allowed. Current Count: 0

You may answer and comment on any thread according to the Terms and Conditions.

 © Copyright 2019 IDAutomation.com, Inc., All Rights Reserved. Legal Notices.

 Barcode Fonts | Components | Scanners | Support | Contact Us
Training Videos on YouTube Join us on Google Plus Join us on LinkedIn Follow us on Twitter Like us on Facebook