Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Reporting Services (SSRS), Excel Rss

   Items 1 to 7 of 7   
 

SSRS Reports as a Data Source in Excel 2013

DBAs are expected to know how to administer the technologies that are available with and peripheral to SQL Server. To properly administer them, it certainly helps to understand the technology from the point of view of the user. By using an existing SSRS report as a data feed for Excel, Rodney Landrum explains how these users can now take advantage of development efforts in new ways.  Read more...
By Additional Articles 2013/10/09 | Source: SimpleTalk | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 3,535 reads

Using source data from an SSRS report in PowerPivot for Excel

In this tip we would look using an existing SSRS report to provide the data for PowerPivot in Excel.  Read more...
By Additional Articles 2013/05/24 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,740 reads

Low Profile Architecture

The goal of this article to show how to get unique transactions per client per month from the data set containing multiple transactions per client per month.   Read more...
By Igor Zaychik 2013/04/02 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 3,721 reads

QlikView for Beginners - An Introduction to QlikView

A brief introduction to getting started with QlikView.  Read more...
By Mark O'Donovan 2012/12/17 | Source: SQLServerCentral.com | Category: qlikview
Rating: |  Discuss |   Briefcase | 3,109 reads

CPU and Scheduler Performance Monitoring using SQL Server and Excel

This article will demonstrate a method of creating an Excel-based CPU/scheduler performance dashboard for SQL Server 2005+.  Read more...
By Derek Colley 2012/10/04 | Source: SQLServerCentral.com | Category: t-sql
Rating: |  Discuss |   Briefcase | 7,128 reads

How to Name Sheets in Exported Excel Workbooks with SSRS 2008 R2

A new feature of SSRS 2008 R2 is the ability to name sheets in exported Excel workbooks. This article explains how to utilize this feature.  Read more...
By Stan Kulp 2011/08/22 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 5,511 reads

FAQ: SQL Server Reporting Services

Troubleshoot SQL Server Reporting Services (SSRS) issues such as configuration, report designs and importing and exporting report data using Excel.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 3,183 reads
   Items 1 to 7 of 7   
 
Tags
t-sql (2)    
affinity (1)    
cpu (1)    
data warehouse (1)    
excel 2013 (1)    
graphs (1)    
internals (1)    
monitoring (1)    
performance tuning (1)    
powerpivot (1)    
qlikview (1)    
schedulers (1)    
ssas (1)    
sys.dm_os_ring_buffers (1)    
sys.dm_os_schedulers (1)    
sys.dm_os_sysinfo (1)