New User? Sign Up  |  Sign In  |  Help
IDAutomation Logo
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

Issue with QR Code and Crystal Report

I have an issue with 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 perfectly again.

Has anyone got any ideas?

Many thanks


Application: Crystal Reports

06-21-19     4.8 year(s) ago    

  Report Abuse

 

Ben

Best Answer

As a test, set the field that produces a barcode from the 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 4.7 year(s) ago

(0)
(0)
  Report Abuse
 
Find Interesting
 
Email to Others
 
Bookmark
 
Subscribe to Answer Alert
No comments yet.     Be the first to comment.
Other Answers (8)
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 4.8 year(s) ago

(0)
(0)
   Report Abuse
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 4.8 year(s) ago

(0)
(0)
   Report Abuse
I have to remove all of the barcodes for the report to work how it should.

Posted 4.8 year(s) ago

(0)
(0)
   Report Abuse
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 4.8 year(s) ago

(0)
(0)
   Report Abuse
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 4.8 year(s) ago

(0)
(0)
   Report Abuse
Can you attach a screenshot of the before and after so I can get a better idea of what is happening?

Posted 4.8 year(s) ago

(0)
(0)
   Report Abuse
Maybe I should explain it differently.

The packing slip is the shipping document we send to our 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 4.8 year(s) ago

(0)
(0)
   Report Abuse
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 it with the design and preview rulers.

Posted 4.8 year(s) ago

(0)
(0)
   Report Abuse
 Categories
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 2021 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