SSRS report - kill export to Excel

mark goldin 691 Reputation points
2022-02-22T22:03:44.477+00:00

I am running report in ReportViewer - localmode. I am using the following to convert it into Excel:

var bytes = rep.Render("EXCELOPENXML", null, out _, out _, out var extension, out _, out _);

The process sometimes takes too long. Is it possible to kill the export?

Thanks

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,915 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2022-02-23T02:36:08.217+00:00

    Hi @mark goldin
    Maybe you can just quit the program,RIGHT?

    Or if you want to quit the rendering from reportserver side .you can do is to identify the process id by running sp_who2 procedure and then use KILL command to kill that process .
    Here is the link that I refer to.Hope it can help you.

    Best Regards,
    Isabella


    If the answer is the right solution, please click "Accept Answer" and upvote it. If you have extra questions about this answer, please click "Comment".
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.