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

How to stream barcodes into SQL Server Reporting Services?


How can I do this? What products can I use?

Operating System: Windows Server

Application: SQL Server Reporting Services

09-19-13     11.1 year(s) ago    

  Report Abuse

 

Ben

Best Answer

2019 Update: The (SSRS Native Barcode Generator) now includes an embedded native generator that stays in the report and runs locally. This is provided in all 2019 and greater versions of this product and is usually more efficient than streaming barcodes into SSRS.

It is possible to stream barcodes such as (QR-Code, Data Matrix, PDF417, Code 3 of 9, Code 128, GS1-128, GS1 DataBar, Interleaved 2 of 5, MSI, ITF and USPS IMb in SQL Server Reporting Services using the SSRS Barcode Generator Service (SaaS) or the ASPX Barcode Generator Script.

The components are fast and efficient - stream server-side 1-bit bitmap files to the browser without any temp files generated on the server.
___________________________________________________________

The example explains how to implement the ASPX Generator Script into SQL Server Reporting Services 2008.

1. Once the report is set up, add an Image to the report.
image
___________________________________________________________

2. Hard coded Example:
image

The D parameter is DataToEncode (the data to format as the barcode). View additional ASPX Generator Properties.

Set Source as External
Set Value as: ="http://www.bcgen.com/aspxscripts/idautomation-code128.aspx?D=" + "1234"



Database Example:
(Generates a barcode based on a field named IDNumber)
image

Set Source as External
Set Value as: ="http://www.bcgen.com/aspxscripts/idautomation-code128.aspx?D=" + Fields!IDNumber.Value

___________________________________________________________

3. Click the "Preview" tab to view the generated report.
image

___________________________________________________________

HOSTING THE PHP, ASP, ASPX GENERATOR SCRIPTS

If you would like IDAutomation to host the generator script, on our server, Contact Us for details and pricing.


NOTES:

Other versions of Reporting Services (2012) may require additional property modifications.

In some cases, to display external images, the EnableExternalImages Property must be set to True.

image

Posted 11.1 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.

 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