asked on

Best ways to report data from SQL server databases to users

Looking for best ways to report data from SQL Server Databases to users. We have tried SSIS packages that outputs data to excel files etc.
Report Server-- tedious with so many fields

ASKER CERTIFIED SOLUTION

David Todd

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

Danilo Andrade

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Nana Hemaa

ASKER

--If you found SSIS/SSRS tedious, have you given Power BI a try?
https://powerbi.microsoft.com/en-us/

---Thanks I have seen the tool but not really used it. I will give it a try

Nana Hemaa

ASKER

Thanks David

--Can you create an excel form that extracts data into a blank sheet in the current workbook? This should be familiar to your users and gives
-----the results in the format they want.

We are currently doing this via SSIS packages

David Todd

Hi,

You indicated there was an issue with the current delivery method. I'm suggesting an alternative. It's a bit of a pest to code the first time around as you have to format some columns differently depending on SQL data type, but once you've got that collection built up it is fairly simple if the source is a SQL stored procedure.

This way your users get what they need when they need it, rather than getting a whole bunch of emails - and then having to extract the excel spreadsheet attachments ...

HTH
David

Nana Hemaa

ASKER

I am going to try Power BI