Share via

SSRS subreport

mark goldin 706 Reputation points
2023-09-18T09:13:50.2266667+00:00

I have a report with a subreport. I want to run subreport based on a report parameter. If the parameter is false I dont want to run report at all. I can hide the subreport based on that parameter but the subreport still pulls data that is time consuming.

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.

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2023-09-19T01:21:42.2333333+00:00

    Hi @mark goldin

    Maybe you could try changing the query for the report. Please refer to this link: https://stackoverflow.com/questions/42702419/how-to-control-ssrs-subreport-based-on-report-parameter-value.

    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

    Was this answer helpful?

    0 comments

Your answer

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