ConSolIT
asked on
Reporting Services - run update query after report prompt
After a report is viewed, I need to prompt the user if they want to mark these records as printed. If they answer yes, I need to run an update query. Is there a way to do this in Reporting Serivces?
ASKER
Sorry, I got busy on other projects and could not get back to this one.
I want to make sure I am understanding this method.
They will need to run the report once with the parameter set to false. Once the report prints succesfully (data looks valid, no need to edit data and regenerate, no paperjams, etc) they need to run the report again with the parameter set to true?
Is there any way of having a message box pop up after the first run instead of having them run a second time (of course the problem with message box is that it would be modal and not let them select a menu option to print...hmmmmm..)?
I want to make sure I am understanding this method.
They will need to run the report once with the parameter set to false. Once the report prints succesfully (data looks valid, no need to edit data and regenerate, no paperjams, etc) they need to run the report again with the parameter set to true?
Is there any way of having a message box pop up after the first run instead of having them run a second time (of course the problem with message box is that it would be modal and not let them select a menu option to print...hmmmmm..)?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
select * from yourtable
exec yourprocedure
where @updateparameter = 1
Create a parameter in the report that specifies the update.