Print SSRS Report

Depending on the SQL and SSRS version you're using you may be able to do that as described here: https://docs.microsoft.com/en-us/sql/reporting-services/url-access-parameter-reference?redirectedfrom=MSDN&view=sql-server-ver15

or not as noted here: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/6f1d0b83-533c-447c-a5ce-df82838a4dfc/how-to-print-report-from-url?forum=sqlreportingservices

You would need to create a "helper" assembly exposed to COM. This assembly would be able to print the report programmatically. In Winforms applications SSRS report is meant to be printed from the reportviewer control, but there's a number of third-party components that allow direct printing, plus Microsoft's own walkthrough how to implement it (the walkthrough is about local report, but most likely it can be a remote one as well - subject to some experimentation; or you could just grab SSRS file and use it as local report). You VBA code would have to call this assembly by CreateObject, and assembly would print the report.

Hi Prabhu,

The report, is it based on the yesterday's business data or it has to run in real-time mode and print via VBA?
If yesterday's business data then one simple method is to create a subscription with the destination of Windows File Share.  Of course it has several options that might suit your needs.

Just a thought.