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


Post New Web Links

Display Parameters in Scheduled Subscription Email

Posted By:      Posted Date: December 04, 2010    Points: 0   Category :SharePoint
 
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.


View Complete Post


More Related Resource Links

Subscription with Drop Down Parameters - Does not display

  

I'm having an issue similar to this:

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/6e11ec25-e205-469e-8c35-b73b4478bcf0

 

Several parameters on the report, all work in normal report gen in VS and online. But when trying to create a subscription, 2 of 7 parameters do not display their drop down options. I have checked, and ALL of them have id's and values, no empties. If I look at the source of the HTML generated, I don't even see it trying to create the list of possible values.

 

 


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

  
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  

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  

Is it possible to display the friendly name or email address of LiveID User Using Claims Authenticat

  
We have finally gotten LiveID authentication to work.  However when we specify a user to add to a sharepoint group, we need to do it via the unique id that live uses.   The user does login using their usual email address and password, but on the sharepoint side they see the PUID@live.com as the logged in user, and when we want to specify the user to have access to the a particular site or library, we have to do it by the same PUID@live.com.  This display makes it difficult to manager users on the sharepoint side.   Is there something I missed on setting up of the authentication provider, or is there something I can do to get sharepoint to retrieve the other information so that we can view the user through the email or full name that live provides?   Steve Paplanus

How to pass multi-value parameters to DDS (data driven subscription)?

  
Using RS2005, how should multivalue parameters be stored in a database field so that a data driven subscription can properly read and use them?  I have so far had no luck using syntax of: 1)  parm1, parm2 2)  parm1,parm2 Do single qutoes need to explicitly wrap the values?  Can you please provide an example and a SQL INSERT statement using parm1 and parm2 to demonstrate what to store in the database field?  Thanks!!

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


Incoming email, when trying to view a eml file it only display the save and cancel buttons

  

I have a list which accepts incoming emails.  The original email is saved to this list as a eml file.  Why is it when I click on this file it asks me to save the file to my computer without the option to open?  I would like outlook express to open this email instead of downloading it.  I can download it and then double click the eml file which outlook express then opens.

 


Scheduled subscription runs continously

  

We have SSRS 2005 enteprise edition and ran into an issue with a timed subscription running continously. At the same time we had a data load that backed up replication also. SSRS server is also a subscriber. The issue gets resolved as soon as IIS is reset on the SSRS server. Any and all help is appreciated.

Thanks


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

Calling different report parameters in a data-driven subscription

  

is it possible to change specific report parameters in a data-driven subscription on a per subscriber basis?

For instance I have a report with 3 parameters, when scheduling Joe I would like to select value A for parameter 1, User harry should have value B for parameter 2

I'm using sql server 2005 enterprise, when reading the MS data-driven subscription example I can only enter users and export format


Business Intelligence professional
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