Showing posts with label delivery. Show all posts
Showing posts with label delivery. Show all posts

Wednesday, March 21, 2012

Faxing In Sql Reporting Services

I have read a couple of references to creating "Custom Delivery Extensions", which could potentially handle faxing from a sql report. However I havent got any further than that.


Can anyone point me to a link or give me some idea as to how I might go about this.

Thanks,

Efax provides a web service for faxing documents.

http://www.efaxdeveloper.com/developer/twa/page/howWorks

So you could write a delivery extension that interfaces with this web service or you can use the email delivery extension to deliver it to a certain email address and have you app check this mailbox periodically and then fax out any reports it receives.

Please note that I am not endorsing efax or claiming its suitable for your purposes. I am merely suggesting a place to begin your investigations.

Fax Delivery Extension

Are there any Fax Delivery Extensions out there?
If not does anyone have any pointers on writing one? I am taking a look a
the sample delivery extension that ships with RS for starters but wouldn't
mind some pointers from anyone who was already gone down this road.
Thanks,
NickHello Nick,
I am planning to write fax delivery extension and saw your post on this
topic. If you have found out ay solution then can you send me sample code.
Your help will be of great help.
Thanks in advance
Rohit
"Nick P @. INDATA" wrote:
> Are there any Fax Delivery Extensions out there?
> If not does anyone have any pointers on writing one? I am taking a look a
> the sample delivery extension that ships with RS for starters but wouldn't
> mind some pointers from anyone who was already gone down this road.
> Thanks,
> Nick

Sunday, February 19, 2012

Failure of report mail delivery

Hi all!
I am running reports with RS 2000. All of htem are subscribed for e-mail
delivery.
For a large report I get the following error:
â'Failure sending mail: The message could not be sent to the SMTP server. The
transport error code was 0x800ccc6d. The server response was 552 message line
is too longâ'
What do I need ot configure in order to deliver this reports successfully.
Thank you
ElenaIt sounds like the size of the message is too large for you SMTP
server. Your mail server administrator probably has a size limit set
for an individual message.
In your email subscription, are you sending the report as an
attachment or just including it in the body of the mail?
Regards,
Shane.
You can either get your mail administrator to increase the size limit
or send
On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> Hi all!
> I am running reports with RS 2000. All of htem are subscribed for e-mail
> delivery.
> For a large report I get the following error:
> "Failure sending mail: The message could not be sent to the SMTP server. The
> transport error code was 0x800ccc6d. The server response was 552 message line
> is too long"
> What do I need ot configure in order to deliver this reports successfully.
> Thank you
> Elena|||I am sending in Web Archive format.
It is sent as a body of the mail. Actually I never considered as sending as
attachment.
Where can I adjust the settings for sending report as attachment?
Elena
"shanejokeeffe" wrote:
> It sounds like the size of the message is too large for you SMTP
> server. Your mail server administrator probably has a size limit set
> for an individual message.
> In your email subscription, are you sending the report as an
> attachment or just including it in the body of the mail?
> Regards,
> Shane.
> You can either get your mail administrator to increase the size limit
> or send
> On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > Hi all!
> > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > delivery.
> > For a large report I get the following error:
> > "Failure sending mail: The message could not be sent to the SMTP server. The
> > transport error code was 0x800ccc6d. The server response was 552 message line
> > is too long"
> > What do I need ot configure in order to deliver this reports successfully.
> > Thank you
> >
> > Elena
>
>|||In the Subscription properties page, there is a drop-down list called
"Render Format". By default this will have a value of Web Archive.
Just change it to Excel or PDF to send the report as an attachment.
Regards,
Shane.
On Apr 17, 1:00 pm, Elena <E...@.discussions.microsoft.com> wrote:
> I am sending in Web Archive format.
> It is sent as a body of the mail. Actually I never considered as sending as
> attachment.
> Where can I adjust the settings for sending report as attachment?
> Elena
> "shanejokeeffe" wrote:
> > It sounds like the size of the message is too large for you SMTP
> > server. Your mail server administrator probably has a size limit set
> > for an individual message.
> > In your email subscription, are you sending the report as an
> > attachment or just including it in the body of the mail?
> > Regards,
> > Shane.
> > You can either get your mail administrator to increase the size limit
> > or send
> > On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > > Hi all!
> > > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > > delivery.
> > > For a large report I get the following error:
> > > "Failure sending mail: The message could not be sent to the SMTP server. The
> > > transport error code was 0x800ccc6d. The server response was 552 message line
> > > is too long"
> > > What do I need ot configure in order to deliver this reports successfully.
> > > Thank you
> > > Elena|||Thanks a lot. It is working.
Elena
"shanejokeeffe" wrote:
> In the Subscription properties page, there is a drop-down list called
> "Render Format". By default this will have a value of Web Archive.
> Just change it to Excel or PDF to send the report as an attachment.
> Regards,
> Shane.
> On Apr 17, 1:00 pm, Elena <E...@.discussions.microsoft.com> wrote:
> > I am sending in Web Archive format.
> > It is sent as a body of the mail. Actually I never considered as sending as
> > attachment.
> > Where can I adjust the settings for sending report as attachment?
> >
> > Elena
> >
> > "shanejokeeffe" wrote:
> > > It sounds like the size of the message is too large for you SMTP
> > > server. Your mail server administrator probably has a size limit set
> > > for an individual message.
> >
> > > In your email subscription, are you sending the report as an
> > > attachment or just including it in the body of the mail?
> >
> > > Regards,
> >
> > > Shane.
> >
> > > You can either get your mail administrator to increase the size limit
> > > or send
> > > On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > > > Hi all!
> > > > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > > > delivery.
> > > > For a large report I get the following error:
> > > > "Failure sending mail: The message could not be sent to the SMTP server. The
> > > > transport error code was 0x800ccc6d. The server response was 552 message line
> > > > is too long"
> > > > What do I need ot configure in order to deliver this reports successfully.
> > > > Thank you
> >
> > > > Elena
>
>|||Apparently, changing it to Excel does not help. Is there a bug in which the
reporting service is putting excel in the body?
Regards,
David
"shanejokeeffe" wrote:
> In the Subscription properties page, there is a drop-down list called
> "Render Format". By default this will have a value of Web Archive.
> Just change it to Excel or PDF to send the report as an attachment.
> Regards,
> Shane.
> On Apr 17, 1:00 pm, Elena <E...@.discussions.microsoft.com> wrote:
> > I am sending in Web Archive format.
> > It is sent as a body of the mail. Actually I never considered as sending as
> > attachment.
> > Where can I adjust the settings for sending report as attachment?
> >
> > Elena
> >
> > "shanejokeeffe" wrote:
> > > It sounds like the size of the message is too large for you SMTP
> > > server. Your mail server administrator probably has a size limit set
> > > for an individual message.
> >
> > > In your email subscription, are you sending the report as an
> > > attachment or just including it in the body of the mail?
> >
> > > Regards,
> >
> > > Shane.
> >
> > > You can either get your mail administrator to increase the size limit
> > > or send
> > > On Apr 17, 11:08 am, Elena <E...@.discussions.microsoft.com> wrote:
> > > > Hi all!
> > > > I am running reports with RS 2000. All of htem are subscribed for e-mail
> > > > delivery.
> > > > For a large report I get the following error:
> > > > "Failure sending mail: The message could not be sent to the SMTP server. The
> > > > transport error code was 0x800ccc6d. The server response was 552 message line
> > > > is too long"
> > > > What do I need ot configure in order to deliver this reports successfully.
> > > > Thank you
> >
> > > > Elena
>
>