Share via

Visual Studio - cancel report that is trying to preview

Dom 941 Reputation points
2024-01-03T19:43:41.91+00:00

I have some rdl reports (SSRS) that have Default values set for parameters. If I attempt to "preview" the report, it automatically runs even though I want to change the parameters before I actually run it. Some of these reports could take 30-60 minutes to run. Is there a way to "kill" the report so that I can change the parameters before submitting it?

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.
3,063 questions
Accepted answer
  1. Anonymous
    2024-01-05T02:20:21.53+00:00

    Hi @Dom

    I found a similar thread for you that mentioned that the solution is to add a parameter that doesn't allow null values to prevent the report from running at the beginning. For more details you can refer to the discussion in this thread: https://stackoverflow.com/questions/277714/sql-server-reporting-services-how-to-stop-a-report-firing-when-opened.

    I did a simple test. Added a parameter "stop". When previewing, the report will not render.

    User's image

    If the answer is helpful, please click Accept Answer and Up-Vote for the same. If you have any questions, please feel free to let me know.

    Best regards,

    Aniya

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

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.