PDF Export / Bold Text / Underline text decoration

I'm having a problem when I have a text item in a table - the text is bold
and underlined; preview/print preview looks fine; but when I export the
report to PDF, the underline extends beyond the text to the right. If the
text is normal weight, the underline is fine. Is this a known issue? (maybe
fixed w/ RS SP2' - I looked at the bug list and saw some PDF fixes, but not
for this specific problem).
ThanksSome more information on this problem:
Any font specified as bold, bolder, extra-bold, etc. with the text
decoration set to Underline ... looks fine in designer / web preview whether
in a table or by itself in a textbox - but when exported to PDF, the bold
disappears (underline stays, though - but even this is a problem - the
underline extends to the right beyond the text) - maybe if the bold was
really bold, it would be the correct width for the text.
For example:
--
Instead of
For example:
--
I suspect this is a bug w/ the PDF export. Any ideas on possible workarounds?
TIA
"JKirst" wrote:
> I'm having a problem when I have a text item in a table - the text is bold
> and underlined; preview/print preview looks fine; but when I export the
> report to PDF, the underline extends beyond the text to the right. If the
> text is normal weight, the underline is fine. Is this a known issue? (maybe
> fixed w/ RS SP2' - I looked at the bug list and saw some PDF fixes, but not
> for this specific problem).
> Thanks
>|||JKirst,
I had a similar issue with text decoration in the export to PDF, but in my
case the underline disappeared altogether. Through an incident call with MS,
they confirmed there is a bug related to the calculation of the text
decoration and do not have a scheduled fix.
I did discover a work around in my case. It appears that if you have a text
box (whether in a table or just stand alone) that has its CanGrow property
set to true, but the height defined smaller than the defined font size and
text decorations, the text decorations may not render or render improperly if
the data text box does not wrap to 2 or more lines. To fix this, simply
define your textbox's starting height to be greater than the font size with
all potential text decorations applied.
"JKirst" wrote:
> Some more information on this problem:
> Any font specified as bold, bolder, extra-bold, etc. with the text
> decoration set to Underline ... looks fine in designer / web preview whether
> in a table or by itself in a textbox - but when exported to PDF, the bold
> disappears (underline stays, though - but even this is a problem - the
> underline extends to the right beyond the text) - maybe if the bold was
> really bold, it would be the correct width for the text.
> For example:
> --
> Instead of
> For example:
> --
> I suspect this is a bug w/ the PDF export. Any ideas on possible workarounds?
> TIA
> "JKirst" wrote:
> > I'm having a problem when I have a text item in a table - the text is bold
> > and underlined; preview/print preview looks fine; but when I export the
> > report to PDF, the underline extends beyond the text to the right. If the
> > text is normal weight, the underline is fine. Is this a known issue? (maybe
> > fixed w/ RS SP2' - I looked at the bug list and saw some PDF fixes, but not
> > for this specific problem).
> >
> > Thanks
> >
> >

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.