We help IT Professionals succeed at work.
Get Started

SQl Server 2005 SSRS Subscription

Last Modified: 2012-07-15
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
Watch Question
sr. Developer
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE