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