Showing posts with label excel. Show all posts
Showing posts with label excel. Show all posts

Thursday, March 29, 2012

embedding html

Just curious if anyone has any hints to embed HTML directly into a report. I
am doing reports that will be exported to excel when run as a subscription
and using an index (which jump to bookmarks) and page breaks to get each
report onto new tabs.
My current report, done with a different tool, has 2 "Help" tabs that are
formatted text that describe how to interpret the report. I need to
replicate this in reporting services. One problem is that textbox in RS is
way too limited in its functionality.
I could probably link out to an HTML page, but I want the new help tabs to
export to excel along with the report.
Any ideas?I can't think of a way until HTML is supported in text boxes.
--
Wayne Snyder, MCDBA, SQL Server MVP
Mariner, Charlotte, NC
www.mariner-usa.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"asnewbie+rs=argh" <asnewbiersargh@.discussions.microsoft.com> wrote in
message news:DDC6A10A-32BE-43BE-9296-F2B64769DEAA@.microsoft.com...
> Just curious if anyone has any hints to embed HTML directly into a report.
> I
> am doing reports that will be exported to excel when run as a subscription
> and using an index (which jump to bookmarks) and page breaks to get each
> report onto new tabs.
> My current report, done with a different tool, has 2 "Help" tabs that are
> formatted text that describe how to interpret the report. I need to
> replicate this in reporting services. One problem is that textbox in RS
> is
> way too limited in its functionality.
> I could probably link out to an HTML page, but I want the new help tabs to
> export to excel along with the report.
> Any ideas?

Embedded PDF and Excel Files

I want to upload PDF and Excel files to the Report Server database. I
would like to display them in a custom web application. When working
with the ReportViewer control, I can easily show reports. I can't
figure out the process on how to show a PDF to a user. In particular,
if the user selects a PDF ( I can check the MIMETYPE), then, how do I
get the file from Report Server so I can stream it to the user?On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> I want to upload PDF and Excel files to the Report Server database. I
> would like to display them in a custom web application. When working
> with the ReportViewer control, I can easily show reports. I can't
> figure out the process on how to show a PDF to a user. In particular,
> if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> get the file from Report Server so I can stream it to the user?
If you create a report that has the same format and output as the PDF
and Excel files, you could call the report and automatically render it
to PDF or Excel with a download prompt via URL. Here are a couple
examples.
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=PDF
-or-
http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Render&Param1=SomeValue&rs:Format=Excel
Here's the URL format:
http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Render&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
Hope this helps.
Regards,
Enrique Martinez
Sr. Software Consultant|||On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> > I want to upload PDF and Excel files to the Report Server database. I
> > would like to display them in a custom web application. When working
> > with the ReportViewer control, I can easily show reports. I can't
> > figure out the process on how to show a PDF to a user. In particular,
> > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > get the file from Report Server so I can stream it to the user?
> If you create a report that has the same format and output as the PDF
> and Excel files, you could call the report and automatically render it
> to PDF or Excel with a download prompt via URL. Here are a couple
> examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=
=3DRend...
> -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=3DRe=
nd...
> Here's the URL format:
> http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=3DR=
ende=ADr&<ParameterName>=3D<ParameterValue>&rs:Format=3D<PDF/CSV/XML/Excel/=MHTML>
> Hope this helps.
> Regards,
> Enrique Martinez
> Sr. Software Consultant
These are generic PDF files, not based on a report so they cannot be
rendered. We are using Reporting Services to provide security not
only to reports, but also some ancillary PDF and Excel files.|||Where does an uploaded pdf get stored'
Our uploaded pdf changes every week and rather than reupload everytime I was
hoping we could just save changes to the location it was uploaded to.
Many Thanks
"google@.landy.net" wrote:
> On Oct 10, 8:36 pm, EMartinez <emartinez...@.gmail.com> wrote:
> > On Oct 10, 3:21 pm, "goo...@.landy.net" <goo...@.landy.net> wrote:
> >
> > > I want to upload PDF and Excel files to the Report Server database. I
> > > would like to display them in a custom web application. When working
> > > with the ReportViewer control, I can easily show reports. I can't
> > > figure out the process on how to show a PDF to a user. In particular,
> > > if the user selects a PDF ( I can check the MIMETYPE), then, how do I
> > > get the file from Report Server so I can stream it to the user?
> >
> > If you create a report that has the same format and output as the PDF
> > and Excel files, you could call the report and automatically render it
> > to PDF or Excel with a download prompt via URL. Here are a couple
> > examples.http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> > -or-http://ServerX/reportserver?/SomeDirectory/ReportName&rs:Command=Rend...
> >
> > Here's the URL format:
> > http://<ServerName>/reportserver?/<Directory>/<ReportName>&rs:Command=Rende-r&<ParameterName>=<ParameterValue>&rs:Format=<PDF/CSV/XML/Excel/MHTML>
> > Hope this helps.
> >
> > Regards,
> >
> > Enrique Martinez
> > Sr. Software Consultant
> These are generic PDF files, not based on a report so they cannot be
> rendered. We are using Reporting Services to provide security not
> only to reports, but also some ancillary PDF and Excel files.
>

Tuesday, March 27, 2012

Embed excel object in report

Is it possible to embed an excel worksheet in a report? I have a workbook which contains some data and this data needs to be part of the report. What are my options and can this be done by creating a custom report item.

Thanks for your advice.

dipi


You cannot directly embed an excel object into a report. You can however use ODBC to retrieve the data from the workbook as an RS dataset and then create a table from the data.

Ian

Monday, March 26, 2012

Emailing Report

I need to export a view into excel and mail to my manager daily morning. Is there a way i can automate this process. I know how to convert view to excel but i need a better solution to automate this process with emailing to my mgr. Please suggest a better approach of doing this.

Thanks,

The send mail task accepts the use of file attachments.

You are using SSIS, right?|||Or you might want to consider Reporting Services for this.|||

Thats true but how; Firstly i need to convert view to excel and then send excel sheet as attachment in email. Could you pls. explain how i could do this. I am a newbie.

Thanks

|||

If you are going to use SSIS, create a new package, add a data flow task with an OLEDB source that retrieves the view. Add an Excel destination to the data flow to capture the results. Back in the control flow, add a Send Mail task to send the email.

If you want to do it in Reporting Services, post your question in the RS forum (http://forums.microsoft.com/MSDN/ShowForum.aspx?ForumID=82&SiteID=1) and I'll answer it there. Smile

emailing excel and pdf not working

I can email Web Archive reports successfully. However, I cannot send reports
in Excel or PDF.
I have Acrobat Pro 6 installed.
I DO NOT have Excel 2003 installed, but I can if necessary.
Did I missing a configuration step or something?Afte a few weeks of troubleshooting I got it to work. It was totally
unrelated to RS.
"Matt Temple" <mtemple@.dslextreme.com> wrote in message
news:10djruhppn13j04@.corp.supernews.com...
> I can email Web Archive reports successfully. However, I cannot send
reports
> in Excel or PDF.
> I have Acrobat Pro 6 installed.
> I DO NOT have Excel 2003 installed, but I can if necessary.
> Did I missing a configuration step or something?
>

Emailing an Excel file

Hi ,

Is it possible for us to send an excel file generated in the package to the users using Sendmail task or anyother task using SSIS?

Any help is greatly appreciated.

Thanks,

SVGP.

Yes. You will need to set the Attachment property for the task. Now, I am not sure if you are creating a new instance of the Excel file for each package run; if you are then you will need to create a variable or two to provide the full path of the file and then set the Attachment Property using an expression that references the variable.

For instance, I use a Flat File destination and open it getting created by the package I use a File System Task to copy the file to another location, renaming with an extension of the current date. For each run therefore the file name is going to be different and so I created a variable that dynamically captures the new file name each day. The Send Mail task then attaches the correct file each day.

Hope this helps!

|||

Hi swan_sgp,

Yes. This is Possible.

1) Use a global variable (gvExcelFile) to fetch your so created fully qualified excel file path with extension name.

2) You must manually configure an attachment (creates a new connection manager), as Desibull already informed.

3) Assign gvExcelFile to Connection String property in expression builder for the connection manager meant for attachment.

4) Set the DelayValidation Property of the Send Mail to True.

Thanks

Subhash Subramanyam

|||

Hi Subash,

I need to create a new excel file daily and then need to mail it.

The problem iam facing is that ,when i schedule a job the task that dumps data into excel(Dataflow task ) gives a validation error.Everytime i need to manually link the sheets of the excel to the corresponding tables.

Any idea why this is happening?So iam unable to schedule as a job...

Thanks,

Vani

|||

You might take a look at this for some ideas:

http://rafael-salas.blogspot.com/2006/12/import-header-line-tables-into-dynamic_22.html

Emailing an Excel file

Hi ,

Is it possible for us to send an excel file generated in the package to the users using Sendmail task or anyother task using SSIS?

Any help is greatly appreciated.

Thanks,

SVGP.

Yes. You will need to set the Attachment property for the task. Now, I am not sure if you are creating a new instance of the Excel file for each package run; if you are then you will need to create a variable or two to provide the full path of the file and then set the Attachment Property using an expression that references the variable.

For instance, I use a Flat File destination and open it getting created by the package I use a File System Task to copy the file to another location, renaming with an extension of the current date. For each run therefore the file name is going to be different and so I created a variable that dynamically captures the new file name each day. The Send Mail task then attaches the correct file each day.

Hope this helps!

|||

Hi swan_sgp,

Yes. This is Possible.

1) Use a global variable (gvExcelFile) to fetch your so created fully qualified excel file path with extension name.

2) You must manually configure an attachment (creates a new connection manager), as Desibull already informed.

3) Assign gvExcelFile to Connection String property in expression builder for the connection manager meant for attachment.

4) Set the DelayValidation Property of the Send Mail to True.

Thanks

Subhash Subramanyam

|||

Hi Subash,

I need to create a new excel file daily and then need to mail it.

The problem iam facing is that ,when i schedule a job the task that dumps data into excel(Dataflow task ) gives a validation error.Everytime i need to manually link the sheets of the excel to the corresponding tables.

Any idea why this is happening?So iam unable to schedule as a job...

Thanks,

Vani

|||

You might take a look at this for some ideas:

http://rafael-salas.blogspot.com/2006/12/import-header-line-tables-into-dynamic_22.html

emailing an attachment from DTS

I have a DTS package that runs 4x a day and generates an excel spreadsheet, renames that spreadsheet with a datetime stamp and then places it into a folder on our network. I have been asked to email that spreadsheet to someone everytime the package runs.

My question is what would be the best way to handle this and how do I ensure that whatever process I define grabs the correct file? The folder that the Excel file is being placed into has multiple files in it. Is there a way to tell SQL Server which file to grab and email?

Any thoughts or suggestions would be greatly appreciated! Thanks!

Frank

You can use Gert's xp:

http://sqldev.net/xp/xpsmtp.htmsql

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Email with attachments.

I have just setup a new Reporting Service Server. I loaded a page then I created a subscription which will email and excel document of the report out.

Each time the subscription runs I am getting this error below:

Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information.

When I take out the attachment on the email and just have it send the link the email runs fine with no errors. Is there some type of setup that needs to be done with the server side to have it send attachments?

Please let me know. Thanks

Ken, any luck with this problem?

I'm having the same issue - can email fine when only sending a link in the report subscription, but send fails when attempting to include an attachment. Just getting the following logon failure in the report server logs:

Logon Failure:

Reason: An error occurred during logon

User Name:

Domain:

Logon Type: 3

Logon Process: Authz

Authentication Package: Kerberos

Workstation Name: NZRPTAUC01

Status code: 0x8009030E

Substatus code: 0x0

Caller User Name: LOCAL SERVICE

Caller Domain: NT AUTHORITY

Caller Logon ID: (0x0,0x3E5)

Caller Process ID: 1740

Transited Services: -

Source Network Address: -

Source Port: -

|||

I am having same issue.. have you solved the problem?|||

Yes. The 'Log On' account that your SQL Server Reporting Services service runs under must have permissions to send email via your smtp server.

1. Open Admin Tools > Services on your report server and find the SQL Server Reporting Services service.

2. Double click the service and go to the Log On properties tab to determine the service account.

3. Set permissions on your smtp server to allow the service account to send email.

Thursday, March 22, 2012

Email Validation in reporting Sevices...

Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?
ThanksIm using Reporting Server to send that...please any hints'sql

Email Validation in reporting Sevices...

Hi.
IM trying to send a scheduled excel report to some emails but when he
runs it tells me that the emails are not valid..
Any help? i can put any email?Have you tried emailing the file to an external email account of yours?
Something like hotmail, yahoo, gmail...
Open the file at home and see if it opens correctly.
By the way, there is a newsgroup for reporting services -
microsoft.public.sqlserver.reportingsvsc. If you do not get a solution here
you might want to post to the other group (with move information).
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...
> Hi.
> IM trying to send a scheduled excel report to some emails but when he
> runs it tells me that the emails are not valid..
> Any help? i can put any email?
>|||Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution h=
ere
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Who is the "he" that you are referring to in your post?
What is the error?
Where do you see the error?
Keith Kratochvil
"Pp" <josemariabarros@.gmail.com> wrote in message
news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
Yes...i tried to send to may personal account and other hotmail
email...and he tells me the same error..
Thx Keith..you were the only one that tried to help me..i ve been in
the newsgroup of reporting server already..and they didnt helped me..
Keith Kratochvil escreveu:
> Have you tried emailing the file to an external email account of yours?
> Something like hotmail, yahoo, gmail...
> Open the file at home and see if it opens correctly.
> By the way, there is a newsgroup for reporting services -
> microsoft.public.sqlserver.reportingsvsc. If you do not get a solution
> here
> you might want to post to the other group (with move information).
> --
> Keith Kratochvil
>
> "Pp" <josemariabarros@.gmail.com> wrote in message
> news:1148911970.838344.172720@.j55g2000cwa.googlegroups.com...|||Well...sorryy..i didnt explained well..
Im working with the report server and im trying to make a
"subscription" that triggers an action. The action is send every
fridays a report in excel format of some database fields to some email
accounts.
When the subscription is triggered an error is showed in the report
server saying that the emails specified are not valid.
Keith Kratochvil escreveu:
> Who is the "he" that you are referring to in your post?
> What is the error?
> Where do you see the error?
> --
> Keith Kratochvil
>
> "P=E9p=EA" <josemariabarros@.gmail.com> wrote in message
> news:1149244203.261185.242900@.i40g2000cwc.googlegroups.com...
> Yes...i tried to send to may personal account and other hotmail
> email...and he tells me the same error..
> Thx Keith..you were the only one that tried to help me..i ve been in
> the newsgroup of reporting server already..and they didnt helped me..
> Keith Kratochvil escreveu:

Email the results of the query

Hello,

I want to email the results of the query. The query output can be email either as the HTML body of the email to be sent or as a excel attachement.

I am wondering as to what would be the best way to achive this.

a) I could have a email client module in C# or VB.NET 2.0, which would fetch the query resultset and store it in a dataset. I format it as HTML body and send the email using System.NET. For excel, can use XSLT

Please suggest if there is any other approach that would be more suitable.

Thanks.

Check here to view a similar posting from earlier today.|||

Found what I was looking for. So here goes

Solution was Configure Database Mail and then use the msdb.dbo.sp_send_dbmail stored procedure. For your reference http://builder.com.com/5100-6388-6164310.html

Email Subscription into Excel

I am running Reporting Services 2000 and I have several email subscriptions
sending out reports rendered into Excel. On two of the reports the Excel
file contains a document map. How can I disable the document map from being
created? These subscriptions have been created using the standard reporting
services interface. Any help would be appreciated.
Thanks,
JeffJeff,
You have to disable the documentmap in the report itself. To my knowledge
you can not disbable this only when exporting (if you know how, let me know
:).
Perry
"Jeff McIntire" <JeffMcIntire@.discussions.microsoft.com> wrote in message
news:E3A7BB06-A11B-402C-A29E-79DE88A73F30@.microsoft.com...
>I am running Reporting Services 2000 and I have several email subscriptions
> sending out reports rendered into Excel. On two of the reports the Excel
> file contains a document map. How can I disable the document map from
> being
> created? These subscriptions have been created using the standard
> reporting
> services interface. Any help would be appreciated.
> Thanks,
> Jeff
>sql

Wednesday, March 21, 2012

email SQL data

How can I extract data from a table to excel then email it as an attachment.I would bcp the data out in a delimited format and if it must be, import into a spreadsheet to send as an attachment...

...you could just bcp it out comma delimited and let the recipient import it into the spreadsheet to if possible...|||this needs to be automated. It is going to send out an email notifiying a user of a new entry in the database. the new data will be included in the email.|||Originally posted by tonyh
this needs to be automated. It is going to send out an email notifiying a user of a new entry in the database. the new data will be included in the email.

Use DTS to export to the excel file, and then have it email the user with the excel file attached, or put the excel doc in a shared location, make it a linked server, and update it with a sql statement.|||I suggest you can create an instance of MS EXCEL in a stored procedure using sp_OACreate.

Then transfer the data from the table to the excel object (Within the stored procedure itself)

Then inside the stored proc use xp_sendmail to send the excel file. But unfortunately xp_sendmail uses MAPI provider through either MS Exchange or MS Outlook.

Alternatively you can again use sp_OACreate to instantiate a third-party COM component (for example RKMAIL or JMAIL) and use the same for sending the excel file as an attachment to the mail.

Monday, March 19, 2012

Email format for Reporting Services

Hi, this question is related to Reporting Services on SQL Server 2000. When creating a report and setting it to send via email as an attached excel spreadsheet, the email is in the format HTML. Does anyone know if it possible to default this format to something else like Rich Text. I have a feeling that this might involve a change to the RSEmailDPConfiguration within the RSReportServer.config file but am not sure which tag needs changing or adding.

Any help/suggestions greatfully received.According to documentation:

rsreportserver.config

EmbeddedRenderFormats

Specifies the rendering format used to encapsulate a report within the body

of an e-mail message. Images within the report are subsequently embedded within

the report. Valid values are MHTML and HTML4.0.

Does not look like you'll get Rich Text in an email without some custom code.

cheers,
Andrew|||

RTF is not supported by out-of-the-box RS. Theoretically you can write your own renderer but it's a difficult task, plus then you'll need to write custom delivery provider to support it as well. Support for RTF is in the wish list for the next RS version.

|||Thanks for both of your comments. I had a feelling it might be a custom option.

Sunday, March 11, 2012

Email Attachment Corruption

I have a subscription to a report that delivers an Excel attachment. When delivered to my outlook mailbox, no problems. Same report attachment delivered to my hotmail account is corrupted. Results are the same with the CSV option.
Is this related to the problem with lotus mail servers?What is the corruption? The lotus issue is that the emails have a 0 byte
attachment.
-Lukasz
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
>I have a subscription to a report that delivers an Excel attachment. When
>delivered to my outlook mailbox, no problems. Same report attachment
>delivered to my hotmail account is corrupted. Results are the same with the
>CSV option.
> Is this related to the problem with lotus mail servers?|||The attachments are garbled -- their size doesn't appear to change.
So far this behavior occurs only when I send the report to a Hotmail account. A lycos internet account is working.
"Lukasz Pawlowski [MSFT]" wrote:
> What is the corruption? The lotus issue is that the emails have a 0 byte
> attachment.
> -Lukasz
>
> --
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
> news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
> >I have a subscription to a report that delivers an Excel attachment. When
> >delivered to my outlook mailbox, no problems. Same report attachment
> >delivered to my hotmail account is corrupted. Results are the same with the
> >CSV option.
> >
> > Is this related to the problem with lotus mail servers?
>
>|||This is probably related to the same issue. KB Article 872774 will discuss
this issue, although the KB doesn't seem to be available yet. You will need
to contact PSS to get the fix for this issue.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in message
news:B3B6E32C-6878-44D2-8AE9-9C451C727E75@.microsoft.com...
> The attachments are garbled -- their size doesn't appear to change.
> So far this behavior occurs only when I send the report to a Hotmail
account. A lycos internet account is working.
> "Lukasz Pawlowski [MSFT]" wrote:
> > What is the corruption? The lotus issue is that the emails have a 0
byte
> > attachment.
> >
> > -Lukasz
> >
> >
> > --
> > This posting is provided "AS IS" with no warranties, and confers no
rights.
> >
> >
> > "Stuart Finley" <StuartFinley@.discussions.microsoft.com> wrote in
message
> > news:71507D7C-7594-4467-B42A-715E4359B306@.microsoft.com...
> > >I have a subscription to a report that delivers an Excel attachment.
When
> > >delivered to my outlook mailbox, no problems. Same report attachment
> > >delivered to my hotmail account is corrupted. Results are the same with
the
> > >CSV option.
> > >
> > > Is this related to the problem with lotus mail servers?
> >
> >
> >

Email Attachements

Whenever I try to create an attachment with email, the attachment is created
but it is empyu in the case of Excel or I get an open error when creating a
PDF file attachment. If insted of using email, I create a file on a server
share it works fine and I see the report. Also if I include a link on the
email that works fine also and I see the report. It's only the attachments
that aren't working. We are using Lotus Notes for our email system.It's a known bug. Apply the hotfix described in M$ KB # 872774
X
"Jeff" wrote:
> Whenever I try to create an attachment with email, the attachment is created
> but it is empyu in the case of Excel or I get an open error when creating a
> PDF file attachment. If insted of using email, I create a file on a server
> share it works fine and I see the report. Also if I include a link on the
> email that works fine also and I see the report. It's only the attachments
> that aren't working. We are using Lotus Notes for our email system.|||A hotfix has been issued for this issue:
http://support.microsoft.com/default.aspx?scid=kb;[LN];872774
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jeff" <Jeff@.discussions.microsoft.com> wrote in message
news:A8509E81-7A2C-460F-B82E-F4D06B8C4A83@.microsoft.com...
> Whenever I try to create an attachment with email, the attachment is
> created
> but it is empyu in the case of Excel or I get an open error when creating
> a
> PDF file attachment. If insted of using email, I create a file on a
> server
> share it works fine and I see the report. Also if I include a link on the
> email that works fine also and I see the report. It's only the
> attachments
> that aren't working. We are using Lotus Notes for our email system.