• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 515
  • Last Modified:

Is it possible to create a custom button in SSRS to launch a stored proc.

Is it possible to create a custom button in SSRS to launch a stored proc.
0
Mr_Shaw
Asked:
Mr_Shaw
  • 3
  • 3
3 Solutions
 
HumpdyCommented:
not possible I'm afraid.
0
 
HumpdyCommented:
you can have a text box, change it's appearance, and link to another report which is based on a stored procedure, but I am assuming you want to call a stored proc which will be updating or inserting
0
 
Mr_ShawAuthor Commented:
No. The stored proc which I want to run execute an SSIS package.... it's a long story !!
0
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
HumpdyCommented:
http://www.vsteamsystemcentral.com/cs/blogs/applied_team_system/archive/2006/05/20/77.aspx

it may not help you though depending on what the ssis package does.
0
 
Mr_ShawAuthor Commented:
This person has used connected to the SSIS package through SSRS.

http://www.bigresource.com/Tracker/Track-ms_sql-ICBVyj4e/

I am not sure how to write connection strings?
0
 
Mr_ShawAuthor Commented:
thanks
0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now