| Groups | Blog | Home |
sql server reporting services : Problem with HTML slightly garbled sending email as web archive
sending a subscription via email in web archive format. The report displays fine in the Report Manager. However, went emailed some whitespace is seemingly randomly added to the HTML page. Depending on where that whitespace is, this might not be a problem. But if the whitespace is inserted in some places within an HTML tag, then the tag isn't rendered properly. Example: a space is added following the "<" in "</DIV>", thus giving "< /DIV>". Since this is invalid HTML, it displays as text in the report. Example: a cell in a table is defined as right-aligned and in a specific font. All 25 rows in the table (x 3 columns = 75 cells) all display correctly: <P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT face="Eras Medium ITC" color=black size=2><SPAN style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Eras Medium ITC'"> *EXCEPT* one cell, where the following HTML is used: <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN style="FONT-SIZE: 12pt">
This might be an issue with the local SMTP. Are you using the pickup
directory to send email? -- -Daniel This posting is provided "AS IS" with no warranties, and confers no rights. [quoted text, click to view] "Columbia Kai" <Columbia Kai@discussions.microsoft.com> wrote in message news:A0190874-9273-4F1C-9BD1-CF0CEB79616D@microsoft.com... > I'm experiencing a problem with HTML code being slightly messed up when > sending a subscription via email in web archive format. > > The report displays fine in the Report Manager. However, went emailed > some > whitespace is seemingly randomly added to the HTML page. Depending on > where > that whitespace is, this might not be a problem. But if the whitespace is > inserted in some places within an HTML tag, then the tag isn't rendered > properly. > > Example: a space is added following the "<" in "</DIV>", thus giving "< > /DIV>". Since this is invalid HTML, it displays as text in the report. > > Example: a cell in a table is defined as right-aligned and in a specific > font. All 25 rows in the table (x 3 columns = 75 cells) all display > correctly: > <P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT > face="Eras Medium ITC" color=black size=2><SPAN > style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Eras > Medium ITC'"> > *EXCEPT* one cell, where the following HTML is used: > <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN > style="FONT-SIZE: 12pt"> > Why did RS render this cell differently?
Thanks for your reply, Daniel.
I've tried this with two SMTP mail servers, both with the same result. I changed the definition via the RSReportServer.config file. Neither SMTP server is on my local machine. One resides on a Win2003 box and is a MS mail server; the other resides on a Win2000 Server box and is a product called Merak Mail Server. Ultimately they send via the Columbia University mail server, which is sendmail, I believe. (I'm not a systems guy so sorry if my answers aren't dead-on what you asked for.) Please also see my comments on another post title "Web archive subrsciption gets messed up" (note misspelling of 'subscription'). I ran into an identical problem like this when sending email from an Oracle PL/SQL program. The resolution is to intersprese CRLF into the msg at least every 990 bytes. Thanks Daniel. This is the one problem that's keeping me from implementing RS and beginning to retire Crystal Enterprise. [quoted text, click to view] "Daniel Reib [MSFT]" wrote:
> This might be an issue with the local SMTP. Are you using the pickup > directory to send email? > > -- > -Daniel > This posting is provided "AS IS" with no warranties, and confers no rights. > > > "Columbia Kai" <Columbia Kai@discussions.microsoft.com> wrote in message > news:A0190874-9273-4F1C-9BD1-CF0CEB79616D@microsoft.com... > > I'm experiencing a problem with HTML code being slightly messed up when > > sending a subscription via email in web archive format. > > > > The report displays fine in the Report Manager. However, went emailed > > some > > whitespace is seemingly randomly added to the HTML page. Depending on > > where > > that whitespace is, this might not be a problem. But if the whitespace is > > inserted in some places within an HTML tag, then the tag isn't rendered > > properly. > > > > Example: a space is added following the "<" in "</DIV>", thus giving "< > > /DIV>". Since this is invalid HTML, it displays as text in the report. > > > > Example: a cell in a table is defined as right-aligned and in a specific > > font. All 25 rows in the table (x 3 columns = 75 cells) all display > > correctly: > > <P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT > > face="Eras Medium ITC" color=black size=2><SPAN > > style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: 'Eras > > Medium ITC'"> > > *EXCEPT* one cell, where the following HTML is used: > > <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN > > style="FONT-SIZE: 12pt"> > > Why did RS render this cell differently? > >
I haven't done this yet but what was suggested to me (I too am having
problems and am using an external smtp server too) was to use Windows 2003 smtp service and have it forward/route (not sure the term) to the external smtp server. The Windows 2003 smtp server is configured to be looking at a directory and forwarding things on from there. Then you have your report saved to the pickup directory. Note that I haven't done this so I am a little vague on how it all works. -- Bruce Loehle-Conger MVP SQL Server Reporting Services [quoted text, click to view] "Columbia Kai" <ColumbiaKai@discussions.microsoft.com> wrote in message news:8995F878-CB68-4766-BB00-654D7580BAF1@microsoft.com... > Thanks for your reply, Daniel. > > I've tried this with two SMTP mail servers, both with the same result. I > changed the definition via the RSReportServer.config file. > > Neither SMTP server is on my local machine. > > One resides on a Win2003 box and is a MS mail server; the other resides on > a > Win2000 Server box and is a product called Merak Mail Server. Ultimately > they send via the Columbia University mail server, which is sendmail, I > believe. > > (I'm not a systems guy so sorry if my answers aren't dead-on what you > asked > for.) > > Please also see my comments on another post title "Web archive > subrsciption > gets messed up" (note misspelling of 'subscription'). I ran into an > identical problem like this when sending email from an Oracle PL/SQL > program. > The resolution is to intersprese CRLF into the msg at least every 990 > bytes. > > Thanks Daniel. This is the one problem that's keeping me from > implementing > RS and beginning to retire Crystal Enterprise. > > > > "Daniel Reib [MSFT]" wrote: > >> This might be an issue with the local SMTP. Are you using the pickup >> directory to send email? >> >> -- >> -Daniel >> This posting is provided "AS IS" with no warranties, and confers no >> rights. >> >> >> "Columbia Kai" <Columbia Kai@discussions.microsoft.com> wrote in message >> news:A0190874-9273-4F1C-9BD1-CF0CEB79616D@microsoft.com... >> > I'm experiencing a problem with HTML code being slightly messed up when >> > sending a subscription via email in web archive format. >> > >> > The report displays fine in the Report Manager. However, went emailed >> > some >> > whitespace is seemingly randomly added to the HTML page. Depending on >> > where >> > that whitespace is, this might not be a problem. But if the whitespace >> > is >> > inserted in some places within an HTML tag, then the tag isn't rendered >> > properly. >> > >> > Example: a space is added following the "<" in "</DIV>", thus giving "< >> > /DIV>". Since this is invalid HTML, it displays as text in the report. >> > >> > Example: a cell in a table is defined as right-aligned and in a >> > specific >> > font. All 25 rows in the table (x 3 columns = 75 cells) all display >> > correctly: >> > <P class=MsoNormal style="TEXT-ALIGN: right" align=right><FONT >> > face="Eras Medium ITC" color=black size=2><SPAN >> > style="FONT-SIZE: 10pt; COLOR: black; FONT-FAMILY: >> > 'Eras >> > Medium ITC'"> >> > *EXCEPT* one cell, where the following HTML is used: >> > <P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN >> > style="FONT-SIZE: 12pt"> >> > Why did RS render this cell differently? >> >> >>
Don't see what you're looking for? Try a search.
|
June 2004
July 2004
August 2004
September 2004
October 2004
November 2004
December 2004
January 2005
February 2005
March 2005
April 2005
May 2005
June 2005
July 2005
August 2005
September 2005
October 2005
November 2005
December 2005
January 2006
February 2006
March 2006
April 2006
May 2006
June 2006
July 2006
August 2006
September 2006
October 2006
November 2006
December 2006
January 2007
February 2007
March 2007
April 2007
May 2007
June 2007
July 2007
August 2007
September 2007
October 2007
November 2007
| home · blog · groups | Questions? Comments? Contact the dn |