tags:

views:

549

answers:

1
Q: 

Unable to create data driven subscription for ssrs report

I have a SSRS report which displays daily status report for the team members. The dataset of the report depends on User!UserID as a parameter which is passed to the SQL Query to fetch the data. I want to create a data driven subscription on this report so that every user gets his/her daily status report each morning. But when I click on the "New Data-Driven Subscription" I get a message "Data-driven subscriptions cannot be created because the credentials used to run the report are not stored, the report is using user-defined parameter values, or if a linked report, the link is no longer valid."

One of the solutions to the above issue is provided at http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/94ad2583-4591-4d28-add3-629b9565c27d. The post says "Make sure your report does not contain expressions depending on user like User!UserID".

If I remove User!UserID from the expression how can I fetch the data on individual user basis. Please suggest.

A: 

Work around is provided here http://www.fits-consulting.de/blog/PermaLink,guid,12db87cf-9d2f-4a2f-9f1b-a6cc1f692ea7.aspx.

Many thanks to Markus Fischer.

stackoverflowuser  2010-02-16 22:06:21

related questions

*= in Sybase SQL
sql missing rows when grouped by DAY, MONTH, YEAR
Adapt Replace all strings in all tables to work with text
Can you call a webservice from TSQL code?
How to tell the data types after executing a stored procedure?
C# - SQLClient - Simplest INSERT
SQL Server: Get data for only the past year
Get last item in a table - SQL
Is there a way to make a TSQL variable constant?
Create a database from another database?
SQL Server PIVOT examples?
What are some references, lessons and or best practices for SQL optimization training.
What's a good way to check if two datetimes are on the same calendar day in TSQL?
Trigger without a transaction?
How do I do an Upsert Into Table?
What is the easiest way using T-SQL / MS-SQL to append a string to existing table cells?
How do I avoid using cursors in Sybase (T-SQL)?
Best .NET Solution for Frequently Changed Database
T-Sql date format for seconds since last epoch / formatting for sqlite input
HOWTO - Compare a date string to datetime in SQL Server?
Differences Between MySql and MS SQL
Best method for varchar date validation in Sybase (T-SQL)?
interrogating table lock schemes in T-SQL
Testing for inequality in T-SQL
T-Sql Remove Decimal Point From Money Data Type