Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / August 2006

Tip: Looking for answers? Try searching our database.

Invoke or detect Print Report event

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
muirboy - 31 Aug 2006 17:10 GMT
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!!!!
Bruce L-C  [MVP] - 31 Aug 2006 18:03 GMT
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?

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Hi
>
[quoted text clipped - 18 lines]
>
> Cheers!!!!
muirboy - 31 Aug 2006 18:19 GMT
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

> 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 L-C  [MVP] - 31 Aug 2006 18:32 GMT
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).

Signature

Bruce Loehle-Conger
MVP SQL Server Reporting Services

> Bruce
>
[quoted text clipped - 19 lines]
>> it
>> is the first or second time?
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.