How to save the input values from a multivalue parameter report

[rogerzebra]

Hi

I'm struggling with SSRS again after not been using it for over 2-years. Anyone knows how to save the input values from a multivalue parameter to the DB? I appreciate that you taking the time.

Thanks in advance.

 

[ousoonerjoe]

I would recommend using a stored procedure for your data source. When the values are passed, the procedure executes a the INSERT to save the values just before processing the SELECT for the report. That is what we do for a simplistic auditing trail.

--------------------------------------------------
“Crash programs fail because they are based on the theory that, with nine women pregnant, you can get a baby a month.” --Wernher von Braun
--------------------------------------------------