u/pootietangus

Based on feedback here, I added one-click SSRS report creation to my SSMS extension

Last week I posted an SSMS extension that turns a query into a refreshable Excel workbook. A lot of the respondents were SSRS users, so I added a button that automates RDL creation and deployment for single-query reports.

You just right-click, choose your SSRS folder and shared data source, and then the extension generates and deploys a basic tabular report.

Still free/open source, currently SSMS 22:

https://github.com/flank-project/ssms-extension

u/pootietangus — 13 days ago

▲ 60 r/SQLServer

I built an open-source SSMS extension that turns a query into a refreshable Excel workbook

Send the workbook to an end user, and they can hit Data > Refresh All to rerun the query using their own database credentials.

Currently supports SSMS 22 and Desktop Excel.

It's free/open source. Install instructions and source are here:

https://github.com/flank-project/ssms-extension

u/pootietangus — 21 days ago