On some of our RS machines the Verdana font doesn't render correctly in PDF
format, there is no spacing between the letters (all at the same location).
Other fonts like Arial render correctly. Is this a known issue? sp1 has been
installed (I know there were some issues with this before service pack 1).
--
Callidus
Software DesignerEnsure Verdana is on the server box as well as the development
computers.
Then, on the server, use the Fonts control panel to open all Verdana
font files. Then reboot the server.
This helped us with similar problem - hope it works for you!|||Thanks for your reply. This doesn't solve our problems however. Any other
suggestions?
Was it the first time you rebooted the server after installings sp1?
"Parker" wrote:
> Ensure Verdana is on the server box as well as the development
> computers.
> Then, on the server, use the Fonts control panel to open all Verdana
> font files. Then reboot the server.
> This helped us with similar problem - hope it works for you!
>|||Yes - the server had been up for a fairly long time, as I recall.
Sounds like your problem may lie elsewhere - other things to try would
be ensuring you are using Acrobat Reader 7, or simply not using the
problematic font (kludgy, I know...)|||We use Arial Narrow and ever since we went to a W2K3 box everything exports
correctly, except for PDF which substitutes Helvetica or something with weird
spacing. Did you ever get it fixed?
"Callidus" wrote:
> Thanks for your reply. This doesn't solve our problems however. Any other
> suggestions?
> Was it the first time you rebooted the server after installings sp1?
> "Parker" wrote:
> > Ensure Verdana is on the server box as well as the development
> > computers.
> >
> > Then, on the server, use the Fonts control panel to open all Verdana
> > font files. Then reboot the server.
> >
> > This helped us with similar problem - hope it works for you!
> >
> >
Showing posts with label font. Show all posts
Showing posts with label font. Show all posts
Wednesday, March 28, 2012
PDF Language/Font Problem
Anyone come across this one:
I have a report that has to print out its figures in Euros or Dollars - I
pass in the locale code as a parameter (DE-DE or EN-US) respectively and
change the language of the report to one of those values via an expression.
The report runs, looks fine on any PC over the web. US countries have their
figures preceded by a $, European countries figures are preceded by a Euro
symbol. When I come to export the results to PDF, again its fine on my PC,
but the same report exported on seemingly arbitrary PC's elsewhere in the
building have the numerical figures garbled into some unrecognisable font.
Any ideas?
MickIf anyone is interested, this was an Adobe issue - v5 doesn't support the
Euro symbol (upgrading to V6 solved the problem)
"Mick Horne" <mick.horne@.conchango.com> wrote in message
news:%23cgQs2eXEHA.952@.TK2MSFTNGP10.phx.gbl...
> Anyone come across this one:
> I have a report that has to print out its figures in Euros or Dollars - I
> pass in the locale code as a parameter (DE-DE or EN-US) respectively and
> change the language of the report to one of those values via an
expression.
> The report runs, looks fine on any PC over the web. US countries have
their
> figures preceded by a $, European countries figures are preceded by a Euro
> symbol. When I come to export the results to PDF, again its fine on my
PC,
> but the same report exported on seemingly arbitrary PC's elsewhere in the
> building have the numerical figures garbled into some unrecognisable font.
> Any ideas?
> Mick
>
I have a report that has to print out its figures in Euros or Dollars - I
pass in the locale code as a parameter (DE-DE or EN-US) respectively and
change the language of the report to one of those values via an expression.
The report runs, looks fine on any PC over the web. US countries have their
figures preceded by a $, European countries figures are preceded by a Euro
symbol. When I come to export the results to PDF, again its fine on my PC,
but the same report exported on seemingly arbitrary PC's elsewhere in the
building have the numerical figures garbled into some unrecognisable font.
Any ideas?
MickIf anyone is interested, this was an Adobe issue - v5 doesn't support the
Euro symbol (upgrading to V6 solved the problem)
"Mick Horne" <mick.horne@.conchango.com> wrote in message
news:%23cgQs2eXEHA.952@.TK2MSFTNGP10.phx.gbl...
> Anyone come across this one:
> I have a report that has to print out its figures in Euros or Dollars - I
> pass in the locale code as a parameter (DE-DE or EN-US) respectively and
> change the language of the report to one of those values via an
expression.
> The report runs, looks fine on any PC over the web. US countries have
their
> figures preceded by a $, European countries figures are preceded by a Euro
> symbol. When I come to export the results to PDF, again its fine on my
PC,
> but the same report exported on seemingly arbitrary PC's elsewhere in the
> building have the numerical figures garbled into some unrecognisable font.
> Any ideas?
> Mick
>
Friday, March 23, 2012
PDF and Excel Issues
I have two issues when exporting a report to Excel or pdf.
1. When exporting to pdf, the underline font attribute is lost. Is
this a version issue or is there something I can do to circumvent this
(other than place a border on the text box which will look bad)?
2. When exporting to pdf and Excel, I am getting a lot of white space
at the start of the report (in pdf) or between list items (in excel).
The pdf white space is almost an entire page.
I am using Reporting Services SP1.I am not seeing the first issue. I can successfully export textboxes with
underline set.
On the second one, do you have CanGrow on textboxes with extra content in
them (spaces, returns)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lara" <wwilliam@.umn.edu> wrote in message
news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
>I have two issues when exporting a report to Excel or pdf.
> 1. When exporting to pdf, the underline font attribute is lost. Is
> this a version issue or is there something I can do to circumvent this
> (other than place a border on the text box which will look bad)?
> 2. When exporting to pdf and Excel, I am getting a lot of white space
> at the start of the report (in pdf) or between list items (in excel).
> The pdf white space is almost an entire page.
> I am using Reporting Services SP1.|||Perhaps the first issue is a font issue on the client? I am going to
research this tomorrow. The underline was not in a text box, rather
in a table group header.
I do have some text boxes with cangrow, but they are pretty limited in
size. When I looked at the PDF, it was not really empty space, rather
it was not writing some of the report items. I have a table in a list
box for employee data. The report required a parameter which would
then render the report for that company. Some of the employee tables
were not writing to PDF - it would skip the first 6-7 employees and
pick up from there. I was actually able to address this with
rewriting some of the report. The list was grouping on a number of
items, some of which could be null. I addressed the null in the
stored procedure so that it was replaced with an actual value, and
that seemed to work. Those nasty nulls can sneak up on you! It
should be noted that this was consistant for specific parameters which
caused larger reports. The small one to two page reports didn't seem
to have an issue, with or without nulls.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> I am not seeing the first issue. I can successfully export textboxes with
> underline set.
> On the second one, do you have CanGrow on textboxes with extra content in
> them (spaces, returns)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Lara" <wwilliam@.umn.edu> wrote in message
> news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> >I have two issues when exporting a report to Excel or pdf.
> >
> > 1. When exporting to pdf, the underline font attribute is lost. Is
> > this a version issue or is there something I can do to circumvent this
> > (other than place a border on the text box which will look bad)?
> >
> > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > at the start of the report (in pdf) or between list items (in excel).
> > The pdf white space is almost an entire page.
> >
> > I am using Reporting Services SP1.|||OK, I misspoke when I related my solution to the missing data. I had
been trying a couple of things, and the null grouping wasn't the
solution. Actually, here is the skinny.
I have a table of employee data. I had a list which grouped the
employee id inside a group for location which was inside a group for
company. All of these list groups were necessary to provide the
different pieces of information to the user. A text box with the
employee name was placed in the employee list group and also a table
provided the detail employee information necessary. When this is
rendered to the Report Manager, all is visible as expected. When I
render to PDF, the first several employees are missing with the larger
reports.
To work around this issue, I instead placed a table header with the
employee name on the table and removed the Employee id list. This
table was then placed in the location group. All data is now
rendered as expected in PDF. This is not as the users hoped, as the
text box allowed me to move the employee name where they wanted on the
report and I am a bit more limited with the table grouping.
If you would like any further information, please feel free to contact
me at lara(dot)rubbelke(at)born(dot)com.
Thanks!
wwilliam@.umn.edu (Lara) wrote in message news:<ca6a3f4a.0406291706.5162366a@.posting.google.com>...
> Perhaps the first issue is a font issue on the client? I am going to
> research this tomorrow. The underline was not in a text box, rather
> in a table group header.
> I do have some text boxes with cangrow, but they are pretty limited in
> size. When I looked at the PDF, it was not really empty space, rather
> it was not writing some of the report items. I have a table in a list
> box for employee data. The report required a parameter which would
> then render the report for that company. Some of the employee tables
> were not writing to PDF - it would skip the first 6-7 employees and
> pick up from there. I was actually able to address this with
> rewriting some of the report. The list was grouping on a number of
> items, some of which could be null. I addressed the null in the
> stored procedure so that it was replaced with an actual value, and
> that seemed to work. Those nasty nulls can sneak up on you! It
> should be noted that this was consistant for specific parameters which
> caused larger reports. The small one to two page reports didn't seem
> to have an issue, with or without nulls.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> > I am not seeing the first issue. I can successfully export textboxes with
> > underline set.
> >
> > On the second one, do you have CanGrow on textboxes with extra content in
> > them (spaces, returns)?
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Lara" <wwilliam@.umn.edu> wrote in message
> > news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> > >I have two issues when exporting a report to Excel or pdf.
> > >
> > > 1. When exporting to pdf, the underline font attribute is lost. Is
> > > this a version issue or is there something I can do to circumvent this
> > > (other than place a border on the text box which will look bad)?
> > >
> > > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > > at the start of the report (in pdf) or between list items (in excel).
> > > The pdf white space is almost an entire page.
> > >
> > > I am using Reporting Services SP1.
1. When exporting to pdf, the underline font attribute is lost. Is
this a version issue or is there something I can do to circumvent this
(other than place a border on the text box which will look bad)?
2. When exporting to pdf and Excel, I am getting a lot of white space
at the start of the report (in pdf) or between list items (in excel).
The pdf white space is almost an entire page.
I am using Reporting Services SP1.I am not seeing the first issue. I can successfully export textboxes with
underline set.
On the second one, do you have CanGrow on textboxes with extra content in
them (spaces, returns)?
--
Brian Welcker
Group Program Manager
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"Lara" <wwilliam@.umn.edu> wrote in message
news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
>I have two issues when exporting a report to Excel or pdf.
> 1. When exporting to pdf, the underline font attribute is lost. Is
> this a version issue or is there something I can do to circumvent this
> (other than place a border on the text box which will look bad)?
> 2. When exporting to pdf and Excel, I am getting a lot of white space
> at the start of the report (in pdf) or between list items (in excel).
> The pdf white space is almost an entire page.
> I am using Reporting Services SP1.|||Perhaps the first issue is a font issue on the client? I am going to
research this tomorrow. The underline was not in a text box, rather
in a table group header.
I do have some text boxes with cangrow, but they are pretty limited in
size. When I looked at the PDF, it was not really empty space, rather
it was not writing some of the report items. I have a table in a list
box for employee data. The report required a parameter which would
then render the report for that company. Some of the employee tables
were not writing to PDF - it would skip the first 6-7 employees and
pick up from there. I was actually able to address this with
rewriting some of the report. The list was grouping on a number of
items, some of which could be null. I addressed the null in the
stored procedure so that it was replaced with an actual value, and
that seemed to work. Those nasty nulls can sneak up on you! It
should be noted that this was consistant for specific parameters which
caused larger reports. The small one to two page reports didn't seem
to have an issue, with or without nulls.
"Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> I am not seeing the first issue. I can successfully export textboxes with
> underline set.
> On the second one, do you have CanGrow on textboxes with extra content in
> them (spaces, returns)?
> --
> Brian Welcker
> Group Program Manager
> SQL Server Reporting Services
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Lara" <wwilliam@.umn.edu> wrote in message
> news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> >I have two issues when exporting a report to Excel or pdf.
> >
> > 1. When exporting to pdf, the underline font attribute is lost. Is
> > this a version issue or is there something I can do to circumvent this
> > (other than place a border on the text box which will look bad)?
> >
> > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > at the start of the report (in pdf) or between list items (in excel).
> > The pdf white space is almost an entire page.
> >
> > I am using Reporting Services SP1.|||OK, I misspoke when I related my solution to the missing data. I had
been trying a couple of things, and the null grouping wasn't the
solution. Actually, here is the skinny.
I have a table of employee data. I had a list which grouped the
employee id inside a group for location which was inside a group for
company. All of these list groups were necessary to provide the
different pieces of information to the user. A text box with the
employee name was placed in the employee list group and also a table
provided the detail employee information necessary. When this is
rendered to the Report Manager, all is visible as expected. When I
render to PDF, the first several employees are missing with the larger
reports.
To work around this issue, I instead placed a table header with the
employee name on the table and removed the Employee id list. This
table was then placed in the location group. All data is now
rendered as expected in PDF. This is not as the users hoped, as the
text box allowed me to move the employee name where they wanted on the
report and I am a bit more limited with the table grouping.
If you would like any further information, please feel free to contact
me at lara(dot)rubbelke(at)born(dot)com.
Thanks!
wwilliam@.umn.edu (Lara) wrote in message news:<ca6a3f4a.0406291706.5162366a@.posting.google.com>...
> Perhaps the first issue is a font issue on the client? I am going to
> research this tomorrow. The underline was not in a text box, rather
> in a table group header.
> I do have some text boxes with cangrow, but they are pretty limited in
> size. When I looked at the PDF, it was not really empty space, rather
> it was not writing some of the report items. I have a table in a list
> box for employee data. The report required a parameter which would
> then render the report for that company. Some of the employee tables
> were not writing to PDF - it would skip the first 6-7 employees and
> pick up from there. I was actually able to address this with
> rewriting some of the report. The list was grouping on a number of
> items, some of which could be null. I addressed the null in the
> stored procedure so that it was replaced with an actual value, and
> that seemed to work. Those nasty nulls can sneak up on you! It
> should be noted that this was consistant for specific parameters which
> caused larger reports. The small one to two page reports didn't seem
> to have an issue, with or without nulls.
> "Brian Welcker [MSFT]" <bwelcker@.online.microsoft.com> wrote in message news:<e1sO#FaXEHA.1128@.TK2MSFTNGP10.phx.gbl>...
> > I am not seeing the first issue. I can successfully export textboxes with
> > underline set.
> >
> > On the second one, do you have CanGrow on textboxes with extra content in
> > them (spaces, returns)?
> >
> > --
> > Brian Welcker
> > Group Program Manager
> > SQL Server Reporting Services
> >
> > This posting is provided "AS IS" with no warranties, and confers no rights.
> >
> > "Lara" <wwilliam@.umn.edu> wrote in message
> > news:ca6a3f4a.0406281323.62a2e87c@.posting.google.com...
> > >I have two issues when exporting a report to Excel or pdf.
> > >
> > > 1. When exporting to pdf, the underline font attribute is lost. Is
> > > this a version issue or is there something I can do to circumvent this
> > > (other than place a border on the text box which will look bad)?
> > >
> > > 2. When exporting to pdf and Excel, I am getting a lot of white space
> > > at the start of the report (in pdf) or between list items (in excel).
> > > The pdf white space is almost an entire page.
> > >
> > > I am using Reporting Services SP1.
Subscribe to:
Posts (Atom)