31-Aug-06 09:10 AM

Hi



I'm not sure if this is possible, but hoping that someone out there can



give some guidance.



I'm using a reporting services ReportViewer object to view reports via



an ASP.NET application. I've just upgraded to SP2 to make use of the



print functionality.



However a requirement i have is that a particular report can be printed



only once. Is there a way that i can tap into the Print Report button



event so that i can detect if the print button has been clicked?



Or alternatively is there a way i can invoke the print method from



within ASP.NET aplication?



Or maybe there is some other way to do this.....all suggestions



welcome!!!!!!!



Many many thanks in advance



Cheers!!!!

31-Aug-06 12:03 PM

There is no way to do this that I know of. And what counts as once? What if



they open up IE again and view the report again? How would you know that it



is the first or second time?



--



Bruce Loehle-Conger



MVP SQL Server Reporting Services

31-Aug-06 10:19 AM

Bruce



They should be able to view it as many times as they want, therefore



coming out of IE and back in again would be fine. Essentially once



someone had clicked on the print button it would go back to the DB to



say that the report has been printed, thus locking it for anyone else.



If this sounds bizarre, its due a requirement from an external company



that only one print out should exist. There is a 'duplicate' function



which gives the user access to print the same report again, however the



word 'duplicate' would be splashed over to signify it is not the



original



So are you saying there's no way for me to detect the print function



has been invoked?



Thanks

SQL Server - It is a client side active X control.

31-Aug-06 12:32 PM

It is a client side active X control. If you were to detect it, it would



have to be via script and I just don't know. From RS perspective it is just



another rendering request for the report. What about exporting to PDF?



Unless you turn off exporting to PDF (which cannot be done by report, only



for the complete server) then all the user has to do is export to PDF and



print (which is what my users used to do before they adding printing).



--



Bruce Loehle-Conger



MVP SQL Server Reporting Services