SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


report automation and design


report automation and design

Author
Message
helal.mobasher 13209
helal.mobasher 13209
SSC Veteran
SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)SSC Veteran (292 reputation)

Group: General Forum Members
Points: 292 Visits: 219
have few monthly/weekly reports that I would like to automate them as much as possible. Please be specific in your recommendations/suggestions. Here is the environment and tools I have access to and current process: Environment and Tools: limited control over integration of these tools

MS SQL2008 R2
SQL Server Management Studio 2008 R2
Excel 2010 and 2013
Access 2010
MS BIDS 2008 R2
SharePoint 2013

Current Process:

Extract Data from SQL Server via SQL Script on a weekly/Monthly basis. Some of the monthly reports include more than 500K records. Raw data need to be included in all reports.

Copy Data to Excel

Create multiple Pivot Tables

Create other Tables with SumiFs formula

Create Charts

Publish final reports on SharePoint

Notify customers to grab their reports from SharePoint

Thank you,

Helal
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search