Avatar of Larry Brister
Larry Brister
Flag for United States of America

asked on 

SQl Server 2005 SSRS Subscription

This is making me crazy

I have a SSRS report that the datasource is
exec myStoredProc 0

My actual sql 2005 stored procedure starts with

alter stored procedure myStoredBroc (@all int = 1)

In my logic...
The passed in 0 gets some one set of data otherwise the default kicks in

I have one subcription that runs the Report defaults = 0

I'm trying to set up a SECOND subscription that runs it with the stored procedure default value
exec myStoredProc 1

Can't get this *&^*#%*$(^&$(*%) thing to work!

And of course I accept no responsibility for being an inexperienced moron in SSRS
Microsoft SQL ServerSSRSMicrosoft SQL Server 2005

Avatar of undefined
Last Comment
Larry Brister

8/22/2022 - Mon