Groups | Blog | Home
all groups > sql server reporting services > august 2005 >

sql server reporting services : Subscription disallowed if more than one parameter


jcomba
8/17/2005 11:48:49 AM
I'm running SR SP2 Standard Edition on Win 2003 with the DB local. It
appears that I can only create subscriptions on reports that use no more than
one parameter. At this piont all of my reports use the same shared data
source with credentials stored in the server. All reports with 1 or 0
parameters allow subscriptions, and those with 2 or more do not. Is this
related to mixing query-driven params with hard-coded ones, or is it related
to using defaults with params? This is not indicated as a limitation on the
jcomba
8/29/2005 1:53:23 PM
Anyone? I'm still curious about anyone else's experience or confirmation of
the below - this is not a behaviour that I've seen documented anywhere.

[quoted text, click to view]
Bruce L-C [MVP]
8/29/2005 4:21:38 PM
I have subscriptions for reports with up to 6 or 7 parameters. Most of them
have defaults. Some I leave to default and others I pick a specific value.
Don't know what to say about what your are seeing. I am using Standard
Edition SP2


--
Bruce Loehle-Conger
MVP SQL Server Reporting Services

[quoted text, click to view]

AddThis Social Bookmark Button