Processing SSRS based on record level user inputs (check box)

• Johnny B

  SSCrazy

  Points: 2965

  More actions

  November 13, 2018 at 10:02 am

  #376422

  Short version:
  I'd like to add a new check box parameter as a column in my SSRS report. I'll populate it based on indicators and then allow the user to accept or 'un-check'  at the record level. Imagine 10-15 records out of 135. This can all be on one page. Next the user can 'click' a text box and start an action. Essentiall click a button. I want SSRS so call a stored procedure for each row with the check box. I realize SSRS is a presentation layer and I'm looking for application functionality.

  I found this article and wonder from a few years ago an wonder if there is any updated work or development.

  SSRS processing records based on user inputs

  SQL 2012 Standard VPS Windows 2012 Server Standard

• sgmunson

  SSC Guru

  Points: 110640

  More actions

  November 19, 2018 at 2:05 pm

  #2014030

  Nope.  Sorry.   Can't be done.   See this image for the possible actions an SSRS report can actually make happen:
  

  Steve (aka sgmunson) 🙂 🙂 🙂
  Rent Servers for Income (picks and shovels strategy)