March 6, 2009 at 8:24 am
I'm using RS 2000 on a W2k3
I have several reports that have an email subscription. The email includes the report in either PDF or Excel format. If the report is more than 8+ pages or so (this is an approx guess) the email subscription will fail. If I trim down the data to produce only 1 page or so the subscription works fine.
Anyone experience this or have any suggestions for a fix?
TIA!
March 6, 2009 at 8:30 am
Hi,
Failing in the sense you are not receiving mail rite? SMTP server through which you are routing your mail would have been specified with attachment size setting limit.
Check with your network administrator to check SMTP log whether your mail is received by SMTP Server.
Regards,
Sakthi
My Blog -> http://www.sqlserverdba.co.cc
March 6, 2009 at 9:29 am
That was a good suggestion. I totally forgot about email size.
The attachment when I export it from the Web is only 220KB so It's small. However when viewed in the RS Website it's 13 Pages. Regardless I increased the message options of the local SMTP server.
I checked the SMTP logs and I don't even see where the email is being sent. So I have no record of the email even being created and attempted to be sent. I have checked the RS Logs but I am not seeing any errors.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply