SSRS Reporting Repeat one table after another table

Rahul Jain 1 Reputation point
2021-09-09T07:31:41.64+00:00

Hello,
I created two tablix , in first table i insert some Set Parameter which are static and in second table i continually log data at certain amount of time so every trigger gives a new row for current tags values. its same reporting format as in PHARMA related projects.
As per my new requirement in my project costumer needs set Parameter(Table1) to repeat again at certain amount of time say in every hour, so its like when i start reporting Set parameter will print and Table2 will start data logging, then after some time repeat Set Parameter(Table1) and again start Table2 datalogging, it is like table1 then table2 then again table1 table2, repeat as long as reporting is active.
Is there any way to achieve something like this???

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,940 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. Isabellaz-1451 3,616 Reputation points
    2021-09-10T05:15:41.893+00:00

    Hi @Rahul Jain ,

    Your want is to refresh your report at a certain amount of time. Am I right? If so, you can set the AutoRefresh property of the report to achieve this effect.
    The property means the report will refresh at a time you set.

    You may refer to this thread: auto-refresh.htm

    130878-select-report.png 130879-autorefresh.png

    Best Regards,
    Isabella


    If the answer is helpful, please click "Accept Answer" and upvote it.

    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.