Link to home
Start Free TrialLog in
Avatar of ConSolIT
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?
Avatar of simon_kirk
simon_kirk
Flag of United Kingdom of Great Britain and Northern Ireland image

Should be able to.  Use the genric query designer in your dataset and use something like

select * from yourtable
exec yourprocedure
where @updateparameter = 1

Create a parameter in the report that specifies the update.
Avatar of ConSolIT
ConSolIT

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..)?
ASKER CERTIFIED SOLUTION
Avatar of simon_kirk
simon_kirk
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial