SQLTeam.com | Weblogs | Forums

SQL front office / reporting


#1

I have sql server 2014. I want to create a proper MIS reporting where user can connect as web base on local LAN and access the reports. I am currently using microsoft access for this and grateful if you can advise any free / cheap software to use.

Basically user will connect to this software in browser on local lan and they will access their reports. The software will have direct link with sql as back office.

Thanking you in advance.

TheKop


#2

This will help you get started on what you are looking for:

Once you setup and configure SSRS properly, you can use either Report Builder or Microsoft SQL Server Data Tools - Business Intelligence for Visual Studio to create the reports and then publish.