OCRA, ZipcodeBarcode-regular and Skandata fonts not working when exporting

Hi,
I am having problems displaying OCR-A, zipcodebarcode-regular and
(third party)SKANDATA-C39 fonts on my application.
The way I am trying to render the fonts is by running a MS SQL
Reporting Services application and then doing an export to adobe
acrobat.
In reporting services, all the fonts are displayed correctly but when
I do the export to adobe, they are replaced by other fonts.
I checked the distiller and found out that for the OCR-A and
ZipcodeBarcode-regular fonts, the message "This font's license does
not permit embedding" appears. If I'm not mistaken, they are
microsoft fonts that should be displayed like any other font.
For the SKANDATA.TTF font, it does not even get displayed on the list
of fonts from adobe disteller.
Thanks is advance for all your help
AlRS doesn't do font embedding when rendering to PDF.
The font must be installed both on the RS server (so that we have access to
the font metrics when laying out the pages) and on the client machine where
you are trying to view the PDF (so that Acrobat can load the glyphs).
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"A Gutie" <fiututor@.yahoo.com> wrote in message
news:eca873f7.0408270336.195d11c@.posting.google.com...
> Hi,
> I am having problems displaying OCR-A, zipcodebarcode-regular and
> (third party)SKANDATA-C39 fonts on my application.
> The way I am trying to render the fonts is by running a MS SQL
> Reporting Services application and then doing an export to adobe
> acrobat.
> In reporting services, all the fonts are displayed correctly but when
> I do the export to adobe, they are replaced by other fonts.
> I checked the distiller and found out that for the OCR-A and
> ZipcodeBarcode-regular fonts, the message "This font's license does
> not permit embedding" appears. If I'm not mistaken, they are
> microsoft fonts that should be displayed like any other font.
> For the SKANDATA.TTF font, it does not even get displayed on the list
> of fonts from adobe disteller.
> Thanks is advance for all your help
> Al|||Hi Chris,
We'd already installed all the fonts we are using on the server and on
the local machines.
What you have suggested has not work for us. Any other ideas?
I found a free font on the net. If you search for free3of9.ttf you
can download the font and then try using it to see if you are lucky
getting the results. Other fonts are zipcode.ttf, zipcodebarcode.ttf
- to name a few.
Again, everything is ok on RS, is just exporting to PDF the issue with
not rendereing eventhough the font is on the local and server
machines.
BTW, this is just one of the many fonts I have tried using but no luck
so far.
Thanks again,
Al
"Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message news:<#ZwU1tsjEHA.704@.TK2MSFTNGP10.phx.gbl>...
> RS doesn't do font embedding when rendering to PDF.
> The font must be installed both on the RS server (so that we have access to
> the font metrics when laying out the pages) and on the client machine where
> you are trying to view the PDF (so that Acrobat can load the glyphs).
> --
> This post is provided 'AS IS' with no warranties, and confers no rights. All
> rights reserved. Some assembly required. Batteries not included. Your
> mileage may vary. Objects in mirror may be closer than they appear. No user
> serviceable parts inside. Opening cover voids warranty. Keep out of reach of
> children under 3.
> "A Gutie" <fiututor@.yahoo.com> wrote in message
> news:eca873f7.0408270336.195d11c@.posting.google.com...
> > Hi,
> >
> > I am having problems displaying OCR-A, zipcodebarcode-regular and
> > (third party)SKANDATA-C39 fonts on my application.
> >
> > The way I am trying to render the fonts is by running a MS SQL
> > Reporting Services application and then doing an export to adobe
> > acrobat.
> > In reporting services, all the fonts are displayed correctly but when
> > I do the export to adobe, they are replaced by other fonts.
> >
> > I checked the distiller and found out that for the OCR-A and
> > ZipcodeBarcode-regular fonts, the message "This font's license does
> > not permit embedding" appears. If I'm not mistaken, they are
> > microsoft fonts that should be displayed like any other font.
> >
> > For the SKANDATA.TTF font, it does not even get displayed on the list
> > of fonts from adobe disteller.
> >
> > Thanks is advance for all your help
> > Al|||I was able to reproduce the problem with free3of9.ttf. Thanks!
I'll send it over to the dev team and let them know to contact you if they
find a workaround while they're fixing the bug.
--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
"A Gutie" <fiututor@.yahoo.com> wrote in message
news:eca873f7.0409011037.50fbec88@.posting.google.com...
> Hi Chris,
> We'd already installed all the fonts we are using on the server and on
> the local machines.
> What you have suggested has not work for us. Any other ideas?
> I found a free font on the net. If you search for free3of9.ttf you
> can download the font and then try using it to see if you are lucky
> getting the results. Other fonts are zipcode.ttf, zipcodebarcode.ttf
> - to name a few.
> Again, everything is ok on RS, is just exporting to PDF the issue with
> not rendereing eventhough the font is on the local and server
> machines.
> BTW, this is just one of the many fonts I have tried using but no luck
> so far.
> Thanks again,
> Al
>
> "Chris Hays [MSFT]" <chays@.online.microsoft.com> wrote in message
news:<#ZwU1tsjEHA.704@.TK2MSFTNGP10.phx.gbl>...
> > RS doesn't do font embedding when rendering to PDF.
> > The font must be installed both on the RS server (so that we have access
to
> > the font metrics when laying out the pages) and on the client machine
where
> > you are trying to view the PDF (so that Acrobat can load the glyphs).
> >
> > --
> > This post is provided 'AS IS' with no warranties, and confers no rights.
All
> > rights reserved. Some assembly required. Batteries not included. Your
> > mileage may vary. Objects in mirror may be closer than they appear. No
user
> > serviceable parts inside. Opening cover voids warranty. Keep out of
reach of
> > children under 3.
> > "A Gutie" <fiututor@.yahoo.com> wrote in message
> > news:eca873f7.0408270336.195d11c@.posting.google.com...
> > > Hi,
> > >
> > > I am having problems displaying OCR-A, zipcodebarcode-regular and
> > > (third party)SKANDATA-C39 fonts on my application.
> > >
> > > The way I am trying to render the fonts is by running a MS SQL
> > > Reporting Services application and then doing an export to adobe
> > > acrobat.
> > > In reporting services, all the fonts are displayed correctly but when
> > > I do the export to adobe, they are replaced by other fonts.
> > >
> > > I checked the distiller and found out that for the OCR-A and
> > > ZipcodeBarcode-regular fonts, the message "This font's license does
> > > not permit embedding" appears. If I'm not mistaken, they are
> > > microsoft fonts that should be displayed like any other font.
> > >
> > > For the SKANDATA.TTF font, it does not even get displayed on the list
> > > of fonts from adobe disteller.
> > >
> > > Thanks is advance for all your help
> > > Al|||I am able to show the 4 of 9 font on the pdf as long as I view the pdf on the
same machine that has the font installed. Place the text between '*' like
*text* and it will work. It still wont show on a machine that doesnt have the
font installed though.

OBJECTPROPERTY problem

Why does the first query work properly and return 1 for the IsMsShipped
column when the second and third query do not?
use Northwind
go
SELECT convert(varchar,name) as ObjectName, id, OBJECTPROPERTY(id,
N'IsMSShipped') as IsMSShipped
FROM sysobjects
WHERE name='dt_adduserobject'
use Model
go
SELECT convert(varchar,name) as ObjectName, id, OBJECTPROPERTY(id,
N'IsMSShipped') as IsMSShipped
FROM Northwind..sysobjects
WHERE name='dt_adduserobject'
SELECT convert(varchar,name) as ObjectName, id,
OBJECTPROPERTY(1157579162, N'IsMSShipped') as IsMSShipped
FROM Northwind..sysobjects
WHERE name='dt_adduserobject'
'dt_adduserobject' is just an example of an object that I'd like to
exclude from my results using the IsMSShipped property. I'm querying
sysobjects for every database from a stored proc that uses dynamic sql
to supply the database name. I need to exclude system objects without
resorting to sysobjects.name not like 'dt%'. Unfortunately, this
OBJECTPROPERTY function ignores the database in my FROM clause. Any
ideas?Because OBJECTPROPERTY is resolved to the current datanase. So, it is
trying to find a local object in Model, with whatever id is assigned to
dt_adduserobject in the Northwind database.
<drink.the.koolaid@.gmail.com> wrote in message
news:1140185167.395442.186560@.f14g2000cwb.googlegroups.com...
> Why does the first query work properly and return 1 for the IsMsShipped
> column when the second and third query do not?
> use Northwind
> go
> SELECT convert(varchar,name) as ObjectName, id, OBJECTPROPERTY(id,
> N'IsMSShipped') as IsMSShipped
> FROM sysobjects
> WHERE name='dt_adduserobject'
>
> use Model
> go
> SELECT convert(varchar,name) as ObjectName, id, OBJECTPROPERTY(id,
> N'IsMSShipped') as IsMSShipped
> FROM Northwind..sysobjects
> WHERE name='dt_adduserobject'
> SELECT convert(varchar,name) as ObjectName, id,
> OBJECTPROPERTY(1157579162, N'IsMSShipped') as IsMSShipped
> FROM Northwind..sysobjects
> WHERE name='dt_adduserobject'
> 'dt_adduserobject' is just an example of an object that I'd like to
> exclude from my results using the IsMSShipped property. I'm querying
> sysobjects for every database from a stored proc that uses dynamic sql
> to supply the database name. I need to exclude system objects without
> resorting to sysobjects.name not like 'dt%'. Unfortunately, this
> OBJECTPROPERTY function ignores the database in my FROM clause. Any
> ideas?
>|||Read under the Remarks of the BOL (OBJECTPROPERTY) what the cause is:
"The Database Engine assumes that object_id is in the current database
context."
HTH, Jens Suessmeyer.|||Is there any way to change the "current database context" from within a
procedure? I think I've tried "USE Northwind GO" without
success...
Can I somehow create my own OBJECTPROPERTY function that is not
sensitive to the current database context?
Can I use some other method to determine if an object is a "system
object" that doesn't depend on the current database context?
Thanks for your help.|||> Is there any way to change the "current database context" from within a
> procedure?
No. Only option would be to construct the query in a string and use dynamic
SQL. This has several
drawbacks, see the articles at www.sommarskog.se.

> Can I somehow create my own OBJECTPROPERTY function that is not
> sensitive to the current database context?
I don't think that is possible, taking into account the limitations of what
you can do inside a
function (no dynamic SQL etc), and the fact that a function is database spec
ific, not global.

> Can I use some other method to determine if an object is a "system
> object" that doesn't depend on the current database context?
You can check against some undocumented status column in the sysobjects tabl
e. Do some searching etc
and you will surely find out how to do it. But be aware that this code will
*not* port to 2005 as
the system tables has been reworked and undocumented stuff are not ported to
the compatibility
views. In 2005, you have much better ways of doing this though the new catal
og views.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<drink.the.koolaid@.gmail.com> wrote in message
news:1140199085.871112.237720@.g14g2000cwa.googlegroups.com...
> Is there any way to change the "current database context" from within a
> procedure? I think I've tried "USE Northwind GO" without
> success...
> Can I somehow create my own OBJECTPROPERTY function that is not
> sensitive to the current database context?
> Can I use some other method to determine if an object is a "system
> object" that doesn't depend on the current database context?
> Thanks for your help.
>|||I haven't tried it but you can probably use dynamic sql (sp_executesql to be
exact) and an output parameter to get what you want. You can't put a GO but
I think you can do something like this:
USE YourOtherDB
SET @.X = OBJECTPROPERTY()
wrapped in dynamic sql where @.x is the putput param.
http://www.support.microsoft.com/?id=262499 Using OutPut Params &
sp_executeSql
Andrew J. Kelly SQL MVP
<drink.the.koolaid@.gmail.com> wrote in message
news:1140199085.871112.237720@.g14g2000cwa.googlegroups.com...
> Is there any way to change the "current database context" from within a
> procedure? I think I've tried "USE Northwind GO" without
> success...
> Can I somehow create my own OBJECTPROPERTY function that is not
> sensitive to the current database context?
> Can I use some other method to determine if an object is a "system
> object" that doesn't depend on the current database context?
> Thanks for your help.
>|||I couldn't make that work via dynamic sql via EXECUTE(N'Use Northwind')
I'm also having trouble locating an informative post about
sysobjects.status... :(|||> I'm also having trouble locating an informative post about
> sysobjects.status... :(
Exactly what is it that you need to know? The type column in sysobjects is v
ery informative, for
example. And it id documented.
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
<drink.the.koolaid@.gmail.com> wrote in message
news:1140274997.951001.77840@.g43g2000cwa.googlegroups.com...
>I couldn't make that work via dynamic sql via EXECUTE(N'Use Northwind')
> I'm also having trouble locating an informative post about
> sysobjects.status... :(
>|||You have to put the USE and the code you want executed in that db scope all
in the same dynamic sql batch.
DECLARE @.X NVARCHAR(500)
SET @.X = 'USE NORTHWIND
SELECT convert(varchar,[name]) as [ObjectName], [id], OBJECTPROPERTY([id],
N''IsMSShipped'') as [IsMSShipped]
FROM sysobjects
WHERE name=''Customers'''
EXEC(@.x)
Andrew J. Kelly SQL MVP
<drink.the.koolaid@.gmail.com> wrote in message
news:1140274997.951001.77840@.g43g2000cwa.googlegroups.com...
>I couldn't make that work via dynamic sql via EXECUTE(N'Use Northwind')
> I'm also having trouble locating an informative post about
> sysobjects.status... :(
>|||Thank you! That work's great.