.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

email subscription

Posted By:      Posted Date: September 01, 2010    Points: 0   Category :Sql Server
 
Hello All Experts, I have created email subscription for one report, which is working properly. I have scheduled it on everyday,its automatically send emails to the concern email id on everyday basis. Now is there any way suppose when reports get executed and reports comes blank then its shouldnt send mail on that day. Is it possible or not? Because currently the report is coming blank then also its sending blank report to the concern email id. Please guide me. Regards, AKM  


View Complete Post


More Related Resource Links

SSRS integrated mode email subscription to AD dist group

  
I have MOSS 2007 running SQL 2008 SSRS integrated mode and have created some reports and report subscriptions. Everything is working great. Now I want to use an Active Directory Distribution Group as a recipient for a report subscription - does not work, however the "last results" show no error. Try again using Dist Group in TO: field but adding regular email in CC: field...only email in CC field receive report, again all successful. Does SSRS integrated mode support AD distribution groups? if so is there any special setup required? Thanks LmmMmmm...yummy...

email subscription problem

  
Hello All Experts, I have created email subscription for one report, which is working properly. I have scheduled it on everyday,its automatically send emails to the concern email id on everyday basis. Now is there any way suppose when reports get executed and reports comes blank then its shouldnt send mail on that day. Is it possible or not? Because currently the report is coming blank then also its sending blank report to the concern email id. Please guide me. Regards,AKM  

Subscription email using Load Balancer IP address instead of host name

  

Hi,

     How to configure reporting services instance to use load balancer IP address as part of the URL generation before sending subscription emails?

Example: We have 4 resporting service instances routed through a load balancer. When an email subscription is triggered, the reporting server generating reporting URL is using host name as part of the report server URL. Instead, we would like to use load balancer IP so that when a user click the URL received in an email, will be routed through load balancer instead of hitting directly the reporting server URL.

 Any pointers on this?

 

 


Architect

SSRS 2005 Standard - Subscription to email distribution list?

  

Hello,

    I am delivering SSRS 2005 reports via email subscription. I would like to utilize distribution lists. However, we do not have an exchange server. Is there a way to create distribution lists on the server that can then be accessed through SSRS Standard?

Thanks,

    Wayne


How can I send an email if the subscription will expire tomorrow?

  

hi,

 

I wanna send an email to whoever subscribe that report IF subscription has an end date.

How can I do it?

thanks,

Gok

 


SSRS 2008 - email subscription - 7 minute delay between two reports emailed out (normally less than

  

We have a report subscription that emails out through a 3rd / separate smtp server.

I was watching the progress on the report server subscription page (where it shows executing, x of y completed, 0 errors) and noticed a long pause between updates about half way through the subscription.

 

It sends out around 500 emails and email 475 of 500 was still on screen after a few minutes (it hadn't ticket up to 476, or 479, etc...)

 

So I quer

Pass delivery method, email address to create SSRS subscription using VS2005

  

Hi,

I have created SSRS reports and built a user UI to run these reports. Now when creating SSRS subscriptions in report Manager, is it even possible to programmatically pass the delivery method (email or file share), To email address, scheduled time and date, etc from my front-end UI to the Report Manager?

Any help will be greatly appreciated. Thanks


Error for delivering a report via email by using the data-driven subscription

  

Hi,

I have created a SSRS 2005 report to export in the Excel format as a batch execution. I have made a data-driven subscription, I have specified the from mail address (with my address) and the smtp server in the RS configuration tool, I have set the SQL Server Agent account with my domain user, but I have an error about the from address is refused from the server and the client was not authenticated. I have tried to specify the IP for the smtp server.

Any suggests to me in order to solve this issue, please? Many thanks


SSRS 2005 Email Address Disappears when Editing Subscription

  

I have users that are editing their own SSRS E-Mail Subscriptions.  When they choose "Email" from the Delivered By combo box and type in a e-mail address it disappears after they set a schedule using the "Select Schedule" button and.

Any ideas?


Creating a subscription that sends out an email for each value in a multi valued parameter

  

I have a report that has  a paramter (drop  down) which has about 1000 possible values. I need to create a subscription that generates an excel sheet for each value in that paramter and send it as an email attachment to a selected set of people based on the paramter chosen.

assume that the paramter is called bank name and has the following possible values, pnc, wachovia, boa..

when the subscription runs

it should run the report with the parameter value for bankname as "pnc" generating an excel and emailing it to user@pnc.com

then it should run the report with the parameter value for bankname as "wachovia" generating an excel and emailing it to user@wachovia.com

then it should run the report with the parameter value for bankname as "boa" generating an excel and emailing it to user@boa.com

and so on

What is the best way to accomplish this

 

Thanks for any help in advance

 


smathew

SSRS2008 Report email subscription not working

  
Using our local smtp server i am trying to do a report subscription to mail the report to certain mail ids. In report manager getting the status as 'Mail sent to <>' But originally no mail were sent. what might the problem be?
--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Report subscription to external email ids

  

hi all!!
The report mail subscription is working only for internal mail delivery but not for any external mail ids.

we dont have exchange server in our company, do any one know have to do config in order to deliver the reports to external mail ids??

 

Thanks!


--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

Display Parameters in Scheduled Subscription Email

  
I have a scheduled report that runs in sharepoint. It is then email to me after it completes. I have a couple of subscription of the same report that run with different parameters. Is there a way to include the parameters in the email that is sent to me. The email that is sent is including my report as a .csn attachment. Thank you.

Cannot get subscription email when including report, but can get it when just sending link

  

When I set up an email subscription for a report, I can get the email notification if I only include a link to the report, but get the generic "Failure sending mail: The report server has encountered a configuration error. See the report server log files for more information." error message when I attempt to include the actual report in the email; either as "Web Archive," or PDF."  When I consult the ReportServer log file, I do not see any sort of exception that would indicate the true source of the error.

 

I have set the file security on the RSTempFiles folder to allow the IIS_WPG group to modify the folder, but when I looked into the RS config files, it looked as though SSRS wasn't configured to use temporary storage.

 

Any suggestions?

 

-Matthew


Reporting Services Integrated mode 2008 R2 Subscription Email Error

  

I have setup report subscriptions delivered via email,  on Sharepoint and they tend to fail sending email randomly. It works most of the time, once or twice a week few subscriptions fail. Here is the detailed error message:

library!WindowsService_28!a74!05/18/2011-06:45:12:: w WARN: Microsoft.ReportingServices.Diagnostics.Utilities.ServerConfigurationErrorException: The report server has encountered a configuration error. Logon failed for the unattended execution account. ---> Microsoft.ReportingServices.Diagnostics.Utilities.LogonFailedException: Log on failed. Ensure the user name and password are correct. ---> System.ComponentModel.Win32Exception: The security database on the server does not have a computer account for this workstation trust relationship

library!WindowsService_28!550!05/18/2011-06:45:12:: i INFO: Schedule 7d92afd5-f5ac-4d65-adc8-d87a3aa4bef4 executed at 05/18/2011 06:45:12.

schedule!WindowsService_28!550!05/18/2011-06:45:12:: Creating Time based subscription notification for subscription: 7f035fad-44a1-4cd6-9d41-5465540c879d

PrintPocketCE Print Pocket Excel, Pocket Word and email files

  
Version 3.560 (May 15, 2009):
bullet

Important bug fix: a slight difference in how some devices create fonts was causing a few devices to have significantly longer print times for large print jobs.
bullet

Adjusted PocketJet printer paper feed commands
bullet

Other minor fixes and enhancements.

Version 3.559 (Mar 5, 2009):
bullet

Added support for Martel MCP78xx printers

Version 3.558 (Aug 20, 2008):
bullet

Added support for Martel MCP78xx printers

Version 3.557 (June 27, 2008):
bullet

Fixed error in Canon printer support
bullet

Fixed COM0 port selection

Version 3.556 (June 15, 2008):
bullet

Added support for Brother MW-260
bullet

Added support for Sato MB400

Version 3.555 (Aug 8, 2007):
bullet

Added support for Pentax RuggedJet 3 and RuggedJet 4 printers
bullet

Changed Epson TM-P60 support to maximum page width of 1200 dots

Version 3.551 (Aug 1, 2006):
bullet

Added Peripheral Nomad printer support

Version 3.550 (Mar 23, 2006):
bullet

Added Panasonic JT-H200PR printer support
bullet

Added Pocket Spectrum printer support
bullet

Fixed problem with WM5.0 "inverted image" problem

Send Email from SQL Server Express Using a CLR Stored Procedure

  
Problem
One of the nice things about SQL Server is the ability to send email using T-SQL. The downside is that this functionality does not exist in SQL Server Express. In this tip I will show you how to build a basic CLR stored procedure to send email messages from SQL Server Express, although this same technique could be used for any version of SQL Server.

Solution
If you have not yet built a CLR stored procedure, please refer to this tip for what needs to be done for the initial setup.
Categories: 
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend