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

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Is Conditional Subscription possible in SSRS 2005?

Posted By:      Posted Date: August 24, 2010    Points: 0   Category :ASP.Net

Hi Guys,

Is there a way to set up a subscription that will send e-mails based on the contents of a report? For example, I want to schedule a daily subscription that will only send an e-mail if the report contains data, otherwise it will do nothing for that day. i.e If the report has more than one row, it should send the mail otherwise it should not send the mail.....

Is it possible in SSRS 2005 or is there any other way to do it???


View Complete Post

More Related Resource Links

Multivalued parameter & Data driven subscription for SSRS 2005

I need to create data driven subscription for our reports. Most our reports have multi valued parameters (7-12 parameters with at least 4-5 with multiple values)and need to be send to a users between the range of 25-200. So standard subscription is really not a choice.I have gone through most of the threads before. Question 1:Does any one have a solution for the SSRS 2005 regarding passing mutiple values for a parameter for the Data subscription table. If yes, could you please share the information. Question 2:I found some solutions using the SOAP API. Can any one explain that in detail- how we can do it ?Reference:http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/8ab615b4-1373-4258-bf49-c2843cfea8e9/http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=516735&SiteID=1 Question 3:Here is the other solution I found in one of the postsApparently passing in values like {A, B, C} only works when you configure the parameter values not to come from a dataset so that SSRS doesnt check for ValidValues.Reference: http://social.msdn.microsoft.com/forums/en-US/sqlreportingservices/thread/b2c50aea-2032-4025-a155-306c00fcb856/Any commends about this solution?Thanks

SQL 2005 - SSRS - timeout on Subscription Creation

SSRS failing when we are trying to create the subscription with a "timeout" failure.  The report runs when run normally, and we have created subscriptions of this report on other computers.  We have adjusted the timeout value to a very long time.  The error message returned is:   The operation has timed out (System.Web.Services)   ------------------------------ Program Location:      at System.Web.Services.Protocols.WebClientProtocol.GetWebResponse(WebRequest request)    at System.Web.Services.Protocols.HttpWebClientProtocol.GetWebResponse(WebRequest request)    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetWebResponse(WebRequest request)    at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)    at Microsoft.SqlServer.ReportingServices2005.ReportingService2005.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials)    at Microsoft.SqlServer.ReportingServices2005.RSConnection.GetReportParameters(String Report, String HistoryID, Boolean ForRendering, ParameterValue[] Values, DataSourceCredentials[] Credentials)    at Microsoft.SqlServer.Management.UI.RSClient.RSClientConnection.GetReportParameters(String report, String

SSRS 2005 conditional count in chart

Hi, I have a column chart in which I want to display the % of Invoiced Sales in 24 hours and % of Not Invoiced Sales in 24 hours. The data should be categorized by date, so for each date I can see the % of invoiced and not invoiced sales within 24 hours. My dataset contains: sales id, sales status (only invoiced are permitted and I took care of that in my query), date and I have the nbDays which is bound to a function that determinate if the sale is invoiced in 24h. So if the nbDays < 3 it's in 24h otherwise it's not. I want my chart to display for each date two column: 1- for invoiced in 24, 2- not invoiced in 24 h. So, I drag the date fields to Category fields area and sales id twice to Data fields area. The idea is to use one for invoiced in 24h and the other is for the other case.   So, I want to know how can I write a conditional expression to get this requirement done and make the data fields sales id displays data according to my condition: I tried this but it didn't work: =count(iif(fields!nbDays.value <3, 1,0))  and also the: =iif(fields!nbDays.value <3, count(fileds!salesid.value),0)   any suggestions will be welcomed and appreciated...

SSRS 2005 Standard - Subscription to email distribution list?



    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?



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?

SSRS 2005 - Failure sending mail in e-mail subscription



I added a new TimedSubscription to a report.  However when the report ran, it hit an error.  The Status text was as follows.

Failure sending mail: The permissions granted to user 'domain\user1' are insufficient for performing this operation.

(assuming domain\user1 was my account)

I have the Content Manager role to the report and its folder.  I could run the report interactively with no issues.  This particular report does not require any parameters.

The odd thing was this only happened when I selected "Include Report".  If I selected only "Include Link" it would be fine.

To troubleshoot, I changed my role to System Administrator in Report Manager and re-tried.  The same result was observed.  However after I added my user account, domain\user1, to the local Administrators group, the problem went away!

What rights (in SSRS, local server, folder, etc) does a user need to have in order for the e-mail subscription with file inclusion to work?

The systems involved are as follows.

Windows Server 2003 (SP2)
Microsoft SQL Server Standard Edition, 9.00.4053.00



Best regards,


Reporting Services account for a data-driven subscription - SSRS 2005



I need to create a data-driven subscription that delivers a report to a shared folder. The Reporting Server service execution account is the LOCAL SYSTEM and so the subscription finishes with error. If the execution account is my Window login, the report are saved correctly in the shared folder. Is it possible to specify LOCAL SYSTEM as the execution account for the Reporting Server service in order to implement a subscription or not? Can this execution account to be different respect to the user name to specify in the data-driven subscription?

Many thanks for your suggest.

SSRS 2005 Dynamic-Conditional Filtering



I need to give my report viewers the option to filter if they like. the filtering criteria is also to be selected by the user. The report is about all products sold at all branches by all employees. therefore I have the 2 following user selected parameters:

  1. "Filter by" values: Show all- Branch- Employee - ProductId
  2. "FilterValue" values: To have the dynamic values, this parameter is getting the valid values from the following query:
select distinct 

case @filterby 

when 'Branch' then Sales.branchID

when 'Product' then Sales.ProductID

when 'Employee' then Sales.EMPID

when 'all' then 'all'

end as 'filtervalue'

from sales

order by filtervalue
then I set the table filtering properties to:
=IIF(Parameters!filterby.Value like "all", Parameters!filtervalue.Value, fields(Parameters!filterby.Value).Value)=Parameters!filtervalue.Value

I had to use the IIF statment to implement the conditional filtering. (e.g. I do not want the report filtered by anything if the user selects "all"  for parameter "Filterby" )...now my report works for any filtering criteria selected other than "All". I get the error: Failed to evaluate the filterExpression when I select "all".

This is driving me nuts!

Help please!

SSRS 2005 "Mixed" Authentication Mode


I have a web application where users can authenticate using either SiteMinder or Windows domain accounts.  This is actually configured as two separate virtual directories within IIS 6.  Both applications need to use the same instance of SSRS.  Is it possible to configure the SSRS web application so that if a user is authenticated by SiteMinder it impersonates a Windows account, but if they are already Windows-authenticated that account is used instead?

Report printing problem(ssrs 2005)

HI   i have a SSRS 2005 report with width as 32 inches i have a requirement to print the report in a3 landscape  but when i print the report it comes in 3 page width   is there any way to auto scale the report into a3 size without affecting the view in the report viewer   Thanks varun kumar

ssrs 2005 default value generates report

Hi, If all parameters have default value the report generates as soon as i load the report. Is it possible to only run the report when clicking on the view report button even if all parameters have default values? Thanks

Question regarding IIF statement and Grouping in SSRS 2005

Hi Guys, I am using SSRS 2005. I am facing small prob in using IIF statement to hide a column. I am having a Grouping in my table. (Emp_Group and the values are 'Yes' and 'No') Now, I want to hide a column of the table if Grouping is Yes and I want to show the table if Grouping is No. (When exported to excel it will appear in two different sheets). Any suggestions please............

SSRS 2005 external images won't display - images on DIFFERENT file server

Hi, Been having trouble getting external images to display in reports rendered on SSRS 2005. Images are displayed as a red X. However, my scenario is different from some of the examples I have read about. - The images are stored on a file server that is DIFFERENT from the box on which the Report Service is running. For various business reasons I cannot copy the images locally to the Report Service box. I am using "file://fileserver/path/to/image.jpg" to retrieve the images. - Since the file server does not have IIS installed, I cannot access the images using the URL method (http:// access). I need to use the file:// method. Currently I am prototyping this setup on my test box, which is running XP Pro and IIS 5.1. The Report Service is installed on this same box. I am currently testing this through the Report Manager web site (http://servername/Reports). The images are displayed using the Image control, which I added to the report using the visual report designer in Visual Studio 2005. It is set up with source=External and with "file://fileserver/path/to/image.jpg" path values. File names are retrieved from our database and file paths are built dynamically using a data processing extension I have written. My best guess as to why this is happening is that the ASPNET service account on my test box does not have access to the particular share on the file serve

Shared dataset in SSRS 2008 R2 running on SSAS 2005

I am trying to create a report in SSRS 2008 R2 using SSAS 2005 as a datasource. My dataset has a date parameter. When I create an embedded dataset in my report everything works fine, but when I create a shared dataset with the exact same mdx query, I get the following error: An error occurred during local report processing. The definition of the report 'xxxx' is invalid. The Value expression for the report parameter 'DateCalendarHierarchy' contains an error: [BC30034] Bracketed identifier is missing closing ']'. Does anybody have any ideas? Is this a bug? Thanks, Louis

SSRS 2005 SP3 - Instr function with Global Variable fails in Subscriptions

Hi I have a very simple expression in a text box in my report:  INSTR(Globals!ReportServerUrl,"Report").  This expression should return the integer value of where the string "Report" appears in the Global variable for the ReportServerUrl.  Simple enough.  This works fine for generating the report directly through report manager, and in my case returns a value of 20. However when run as a subscription and emailed to myself the value returned is 0. This suggests that the search string does not appear in the Global variable. In the reportserver config file the URLroot tag contains the correct server address - http://myserver/reportserver. Does anyone know why i should be experiencing this issue with my subscriptions?  Your help would be much appreciated! Thanks Guy  Guy

How should I configure Asp.NET on IIS 6, Sql Server 2005 and SSRS 2005 across 2 Windows Server 2003

I was running a MIS reporting solution on a single server running MS Windows 2003 Server and Sql Server 2005. The solution was built using ASP.NET 2.0 on IIS 6.0, Sql Server DB & SSRS. I now have purchased a 2nd server running MS Windows 2003 Server and Sql Server 2005. What is the best configuration to split the following application components across the 2 physical servers? ASP.NET web application SQL Server 2005 Datawarehouse SSRS Web Applications (Reports & ReportServer) SSRS Databases (ReportServer & ReportServerTempDB) The hardware configuration of the 2 servers are as follows Server 1 MS Windows Server 2003 Enterprise Edition SP2 Intel(R) Xeon(R) CPU 5150 @2.66GHz 16 GB RAM Sql Server 2005 SP3 Standard Edition Smart Array P400 in Slot 1 (SAS Array A with Spare / SAS Array B with Spare) Drive C: 68.33 GB | Drive D: 273.40 GB Server 2 MS Windows Server 2003 Standard Edition SP2 Intel(R) Xeon(R) CPU X5570 @2.93GHz 4 GB RAM Sql Server 2005 SP3 Standard Edition IBM ServeRAID-MR10i SAS/SATA Controller Drive C: 135GB | Drive D: 556 GB | Drive E: 271 GB Any suggestions would be of great help

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...
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