all groups > sql server reporting services > april 2007 >
You're in the

sql server reporting services

group:

ReportViewer intercept export


ReportViewer intercept export Duke (AN247)
4/20/2007 7:44:00 AM
sql server reporting services: I have a ReportViewer on a web page which is set up to allow export to PDF,
Excel etc. I would like to be able to intercept the export event and if the
output will be large then schedule the report for processing and delivery to
the files system either at night or perhaps during the day via a dedicated
non web facing server.

I want to avoid several users trying to generate a 200 page PDF at the same
time. I'm happy to use GetTotalPages() as a guide to whether it is a large
report, I don't need actual number of pages that will be rendered.

Sounds straight forward, except the ReportViewer doesn't have an event for
the Export button.
Q1. Any ideas?

I could set ShowExportControls to false and create my own export button but
it wouldn't be on the ReportViewer toolbar. My page is asynchronous so I'd
also have to cater for a click-happy user selecting my export button before
the report had finished rendering. So,
Q2. on postback is it possible to detect if the ReportViewer is still
rendering the previous report ?
Q3. alternatively are there any client side events raised when rendering has
finished. Then my export button could be hidden to start with and made
visible once the report had rendered.

Thanks,
Andrew
RE: ReportViewer intercept export weilu NO[at]SPAM online.microsoft.com
4/23/2007 3:16:20 AM
Hello Andrew,

The ReportViewer Control did not provide such event to fire when Export or
rendering finished.

My suggestion is that you may try to use your own ReportViewer Control to
render the Report into HTML code and show on the page.

Then, you could add the Export Button by your self and you could get more
intercept for the control.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
RE: ReportViewer intercept export weilu NO[at]SPAM online.microsoft.com
4/25/2007 12:00:00 AM
Hi ,

How is everything going? Please feel free to let me know if you need any
assistance.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
AddThis Social Bookmark Button