Hello.
I have about 15 tables in my report that should be updated automatically once a month except for one that should be updated hourly or even more often. This table contains so-called comments, which should be refreshed on a regular interval. At the moment I have two solutions:
1. updating automatically the entire report daily, which I don't want to do
2. updating manually, just one table and publishing the report manually every day
Both solutions do not solve the problem in any way. in the long term.
I tried to solve this issue using the method from the following video
https://www.youtube.com/watch?v=OYYnoMa-93g
using this program - Microsoft SQL Server Management Studio. It is works fine, but I do not know if it is possible to set up this program in such a way that I configure it once and that it performs the update by itself, for example, every hour, because at the moment it is so that as long as the program is on and I perform the update manually, it also affects the report. On the other hand, if the program is turned off, I stop updating the table in the report.
Regards Piotr.
