Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
MorrisK
Yak Posting Veteran
83 Posts |
 Posted - 2006-11-10 : 17:23:09
|
| I want to create a subscription for a report but I'm getting the error below.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.The report doesn't have a linked report so is it credentials or user-defined parameters giving the problem?I do have user-defined parameter values and I have a query based default. I'm using a shared data source.Any ideas where to look?Thanks,Kevin |
|
|
MorrisK
Yak Posting Veteran
83 Posts |
Posted - 2006-11-10 : 17:30:39
|
| I'm learning a lot today. I found postings in other places that say "if the report uses the User!UserID property in the report then it can not be subscribed to"I removed that and it looks like I'm good to go.Kevin |
 |
|
|
|
|
|
Subscriptions cannot be created error