Post reply

Prevent SSRS From Firing A Stored Procedure

  • October 6, 2015 at 10:49 am

    #305276

    Good Morning Guys,

    Is There a way for me to not fire my Stored Procedure in SSRS from the Get-Go? currently my Report is defaulted as No Filter so When the Report Runs, the Stored procedure behaves as if there is No Where Statement on the Stored Procedure. Any Advice from you guys is very much appreciated

    Best Regards,

    Noel

  • October 6, 2015 at 11:08 am

    #1831811

    since it sounds like you don't wantto remove permissions, but to prevent it from running with all default parameters?

    can you modify the stored proc itself?

    that's the low hanging fruit, i think, easiest to modify with no other changes.

    you could have it test for no parameters + a signiture related to reportserver: hostname of the reportserver, or the suser_name() it uses, and have it return no rows/one row or something in that situation. maybe an additional default parameter, it really depends....

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 6, 2015 at 12:41 pm

    #1831837

    Much Thanks

    I Added An additional Filter that will not return a value once the Stored Procedure Fires in SSRS and it worked

    Best Regards,

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply