Earn Points & Redeem with attractive offers!
You can earn points, by asking, answering, voting questions and redeem with
attractive offers
. To view various available redemption schemes, please visit
"My Profile".
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
Ask
Ask a question. Make sure you select the correct category for the question.
Answer
Like to help others? Then browse through the open questions to answer their questions.
Find
Find answer by browsing the resolved questions.
     
Search for Questions:
My Profile

ElCuervoJP

Resolved Questions Bookmark and Share

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 in my computer, and I could register the "IDAutomation.com.FontReportFunctions" DLL with de GACUtil and I could preview locally the report perfect.

My problem is to deploy 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 begin.

Could you tell me what to do, because I can't find the way to my report 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 follow this steps (http://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     1415 day(s) ago     Views: 4991

    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 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:
http://www.idautomation.com/barcode-components/aspx-generator-script/report-builder-streaming.html



Posted 1414 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 (4)

Ben
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 1413 day(s) ago

()
()
   Report Abuse

ElCuervoJP
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 1414 day(s) ago

()
()
   Report Abuse

ElCuervoJP
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 fulfils the requirements, as I checked the font properties and it states to be True Type and to allow being embedded.

Besides, inside the 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 1414 day(s) ago

()
()
   Report Abuse

Ben
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 1414 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://")
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:// ")
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 2017 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