Is Conditional Subscription possible in SSRS 2005?

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

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?

Hi,

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

Thanks.

Best regards,

Jude.

Hi.

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.

Hi,

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

=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!

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?