MSSQL – Reporting Services – Automate Reports

  Kiến thức lập trình

We are using MSSQL 2019 Standard with Reporting Services.

We have suite of reports and would like to schedule these reports and send them to customers via email. We can use subscriptions but the date parameters need to be dynamic. For example using the same report; Customer A, may want last months data, Customer B may want last years data, Customer C may only want last weeks data, Customer D may want a specific amount of previous day (e.g. -28 days) etc.

I believe this can be done in Data Driven subscriptions but this in only available in Enterprise, which we do not have.

Is anyone aware of any software that can do this without having to purchase an Enterprise licence? Or are there any workarounds, that are easy to manage going forwards.

I did a quick Google and found a company named remiWare has anyone used this software?

Thanks

LEAVE A COMMENT