Resolved Questions

accusent

Is there a faster way to generate the QR Code in Crystal Rep

I am wondering if there is a way to run the barcode generation in the background and append it to my MySQL database. I think that this would speed up the report generation. Maybe there are some other ways to improve speed.

Operating System: Windows 11 pro,

Application: Crystal Reports 2020

07-03-24 171 day(s) ago

Report Abuse


Jacque	Best Answer Generating QR codes natively within Crystal Reports for a large volume of invoices can indeed be resource-intensive, there are a couple of potential alternatives to generating the QR Codes directly in Crystal Reports. To preface, we would only recommend an experienced SQL and C# (or other language depending on the encoder) developer try this and cannot support these recommendations. One option is to use the QR Code Font and Encoder suite to generate encoded data, store it in the database, and then in the report the encoded data would just need the 2D font applied to it in a text box object. Another option is the .NET Barcode Generator, where you could generate the QR Code image, store it in the database, and call upon it to generate the reports. We cannot advise directly on MSSQL nor help implement this solution. So, there might not be a way to speed up the Native Generator for Crystal Reports for the 1000's of barcodes, but with our other products, there is more flexibility offered. Let me know if you have any further questions and I hope this information has been helpful. Posted 171 day(s) ago (0) (0) Report Abuse

Find Interesting

Email to Others

Bookmark

Subscribe to Answer Alert

Add Comment

No comments yet. Be the first to comment.

Other Answers (1)

Brant

I should also mention that you can stream images into Crystal Reports with our Dynamic Barcode Generator Service which may be an easier implementation and should still be fast.

Posted 170 day(s) ago

(0)

Report Abuse

Categories

» Barcode Applications » Barcode Components ● Barcode FAQ » Barcode Fonts » Barcode Hardware ● Barcode Learning » Font Encoders ● General License Questions ● General Sales Questions » MICR & OCR Fonts » Other ● Product Updates » Saas Hosted Products

Email this question link to friends

Your comment on this question

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

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

My Profile

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