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

Report Server problem exporting to PDF


Hi

My name is Juan Pablo and I am writing because I have a problem with the "IDAutomationHC39M_FREE" font with Microsoft Reporting Services.

I have a report on my computer, and I could register the "IDAutomation.com.FontReportFunctions" DLL with de GACUtil and I could preview locally the report perfectly.

My problem is deploying the report on the ReportServer. The Report Server is Microsoft SQL Server 2012 Web Edition. I have copied the DLL to the "E:Program FilesMicrosoft SQL ServerMSRS11.MSSQLSERVERReporting ServicesReportServerbin" folder and then, I could deploy the report.

Now when I get the report, I can export it to Excel Perfectly (the same previous to copy the DLL), but when I export the report to PDF it is rendered with numbers. (not the barcode).

Finally, I try to register with the Visual Studio GACUtility the DLL and now, it is rendered with the same numbers indeed! symbols at the end and the beginning.

Could you tell me what to do, I can't find the way to my report to show me the barcode when I export it to PDF. I tried to install the font, then reboot the server but it still doesn't work.

I have strictly followed these steps (https://www.idautomation.com/font-encoders/sql-reporting-services/) and it is still the same. Could you help me?

Thank you.

Operating System: Windows 2008 Server Standard Ed.

11-05-13     10.3 year(s) ago    

  Report Abuse

 

Ben

Best Answer

Because the font is not responsible for the actual embedding process, there is not much information we can provide on how to resolve the Report Server issue.

It is also possible to stream barcodes into Reporting Services with our Generator Script products. This may be a good alternative to the font solution which must be embedded into the PDF.
You may also refer to the Report Builder Streaming Guide:
https://www.idautomation.com/barcode-components/aspx-generator-script/report-builder-streaming/

Posted 10.3 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 (4)
Though may have seen a similar issue with other clients, the issue is out of the scope of our support. You could attempt to learn more by reaching out to Microsoft.

Posted 10.3 year(s) ago

(0)
(0)
   Report Abuse
Ben, thank you again.

I think, after a lot of tries I have done, the problem is the Report Server Edition. I have tried Report Server (SQL Server 2012 Web Edition) and Standard Edition (SQL Server 2008 R2 Edition) with no success.

Then, I tried with Report Server Data Center Edition (SQL Server 2008 R2 Edition) and it works.

Do you know if this is possible? Do you have any problem with that SQL Server Editions?

Posted 10.3 year(s) ago

(0)
(0)
   Report Abuse
Ben, thanks for your reply.

I'm not sure if there is any particular step to force the font to be embedded.

I read that link you posted before, and it seems that the font fulfills the requirements, as I checked the font properties and it states to be True Type and allows being embedded.

Besides, inside Visual Studio 2012, in the Report Designer, when generating the report with the Preview tab and then exporting it to PDF it works.

The problem is happening when exporting the PDF through the Report Server (although it works when exporting to Excel).

I'm not sure what might be different between the export in the report designer and through de RS Server.

Many Thanks

Posted 10.3 year(s) ago

(0)
(0)
   Report Abuse
Embed fonts in PDF files

A key aspect of PDF files is their ability, when created, to embed fonts in the Microsoft Reporting Services document. Embedding the fonts allows PDF documents to be distributed and/or displayed properly without the need to have the fonts installed on the machine using the document.
Solution:

The PDF rendering extension does not embed fonts in Reporting Services 2000. Fonts that are used in the report must be installed on the report server and on the client computers used to view the report. In Reporting Services 2005 and greater, fonts may be embedded in PDFs.

Refer to the TechNet documents from Microsoft below for more information and specifics.

Reporting Services 2000:
http://technet.microsoft.com/en-us/library/aa178934(SQL.80).aspx

Reporting Services 2005:
http://technet.microsoft.com/en-us/library/ms159713.aspx

Reporting Services 2008:
http://technet.microsoft.com/en-us/library/ms159713(SQL.100).aspx

Posted 10.3 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