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

Articles with tag reporting services (ssrs) Rss

Search for any content tagged reporting services (ssrs)

<< Newer    Items 61 to 80 of 283    Older >>
 

Extra, Extras - Level 7 in the Stairway to Reporting Services

This article highlights each of the additional items needed to create a clean but beautiful report. Using the simple items of headers and footers, textboxes, and other layout options will increase the readability and manageability of your reports.  Read more...
By Jessica M. Moss 2011/12/02 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 9,227 reads

Administrating SQL Server Reporting Services – Planning, Documenting and Troubleshooting

DBAs are often short on guidance on how to go about such tasks as planning, documenting and troubleshooting those aspects that are specific to the SSRS service. Feodor Georgiev gives some tips, custom SSMS reports, and useful TSQL queries.  Read more...
By Additional Articles 2011/11/30 | Source: SimpleTalk | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 2,282 reads

Building a Scale Out SSRS 2008 R2 Farm using Windows NLB Part 4

Delivering reports is becoming more critical due to the increasing demand for business intelligence solutions. And while there are a lot of guides that walk us through building a highly available database engine, you’ll rarely see one for SQL Server Reporting Services. How do I go about building a scale-out SQL Server 2008 R2 Reporting Services running on Windows Server 2008 R2?   Read more...
By Additional Articles 2011/11/18 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 1,546 reads

Adding Custom Code to the Reporting Services 2008 R2

There are numerous circumstances when we wish to add a custom function to a SSRS report in order to cater for needs of the customer which exceeds the capability of the built-in functions in SSRS. In these scenarios we will have to write our own functions. In this article you will see how to add custom code to SSRS.  Read more...
Rating: (not yet rated)  Rate this |   Briefcase | 2,662 reads

10 Bad Things About Reporting Services 2008 R2

SSRS 2008 R2 introduced lots of exciting new features, reviewed in a sister article to this one. Here we consider what Microsoft didn't do well in this version of Reporting Services.  Read more...
By Andy Owl 2011/09/06 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 15,288 reads

10 Good Things About Reporting Services 2008 R2

The 10 things Microsoft got right about SQL Server Reporting Services 2008 R2 (a sister article shows 10 things which aren't quite so good)  Read more...
By Andy Owl 2011/09/05 | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 12,792 reads

Displaying Multiple Series on an SSRS Chart using Chart Area

A report might contain multiple data series on a chart, which can have considerably varying scales but common category groups. In such cases where this a big difference in scales, the data series with the lower scale can become obscured. In this tip we will take a look at how to solve this problem using Chart Areas.   Read more...
By Additional Articles 2011/08/30 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 16,920 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,438 reads

Designing a Dashboard - Level 6 in the Stairway to Reporting Services

This article walks through a sample dashboard, highlighting sparklines, databars, and indicators.  Read more...
By Jessica M. Moss 2013/03/15 (first published: 2011/08/04) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 28,489 reads

Extract Objects from SSRS Reports

A discrete list of database objects is extracted from SSRS using SQL, SSIS, and RegExtractor in order to identify reports that might break when a schema upgrade is performed.  Read more...
Rating: |  Discuss |   Briefcase | 3,870 reads

Highlighting repeating groups in SSRS 2008 R2 charts

In a typical bar chart, the height of the bars represents the value of the data along the X axis and the Y axis represents the category of the data point. All these values can be classified in logical groups depending upon the logic used for analysis. One general requirement that arises in the case of repeating groups, is to highlight these groups without representing it on the X or Y scale. In this tip we will look at how to address this requirement.   Read more...
By Additional Articles 2011/06/27 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 1,920 reads

Reporting Services: Adding extra columns / rows to a matrix

The functionality of additional columns / rows in a cross table ("matrix") in Reporting Services is limited to totals / subtotals. By using a stored function a solution is described.  Read more...
By Martin Cremer 2011/06/24 (first published: 2008/07/24) | Source: SQLServerCentral.com | Category: reporting services (ssrs)
Rating: |  Discuss |   Briefcase | 24,744 reads

SSRS 2008 R2 KPIs with bullet graphs

Key Performance Indicators are typically displayed in a scorecard with stop light indicators, which are either red, amber or green light icons. The limitation for these kind of indicators is that you can see the actual and target values in two different fields as well as see the status of the KPI in red, amber or green color. If the user wants to figure out the thresholds associated with the KPI, these values are generally not visible. Further, representing the threshold values in the scorecard itself defeats the purpose of the scorecard. The scorecard should display the KPI's status in the most summarized form and use a minimal amount of space on the dashboard. In this tip we would look at how to address this issue.   Read more...
By Additional Articles 2011/06/22 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,038 reads

Creating a Reporting Services Histogram Chart for Statistical Distribution Analysis

Typically transactional data is quite detailed and analyzing an entire dataset on a graph is not feasible. Generally such data is analyzed using some form of aggregation or frequency distribution. One of the specialized charts generally used in Reporting Services for statistical distribution is Histogram Charts. In this tip we look at how Histogram Charts can be used for statistical distribution analysis and how to create and configure this type of chart in SSRS.   Read more...
By Additional Articles 2011/06/13 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating:  Rate this |   Briefcase | 3,217 reads

Charting the Unknown – Level 5 in the Stairway to Reporting Services

This article will explain different types of visualizations, including charts and maps, and when you would use each type.  Read more...
By Jessica M. Moss 2011/06/07 | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 12,478 reads

How to handle empty values in a line chart in SSRS

When continuous data is displayed on a chart, such as a line chart, data is displayed very smoothly. But when non-continuous data is displayed on such a chart, the chart behavior is different. The continuous data is displayed correctly, but the non-continuous data is ignored on the chart. In such cases, handling of empty points in the dataset is required to make the data continuous and displayed correctly on the chart. In this tip we will look at how to implement a solution for this problem.   Read more...
By Additional Articles 2011/05/13 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 3,444 reads

How to Setup Report Parameters to Default Based On User Credentials

This article explains how to setup Reporting Services (SSRS) parameters default values using user credentials.   Read more...
Rating: |  Discuss |   Briefcase | 7,030 reads

Creating templates for use in BIDS (SQL Spackle)

Learn how to create and use templates in BIDS in this short SQL Spackle article.  Read more...
By Wayne Sheffield 2013/12/30 (first published: 2011/04/21) | Source: SQLServerCentral.com | Category: sql spackle
Rating: |  Discuss |   Briefcase | 10,444 reads

Tablix Tutorial – Level 4 in the Stairway to Reporting Services

This article shows how to group information, adjust for dynamic column and row groups, and generally use the tablix in Reporting Services.  Read more...
By Jessica M. Moss 2013/02/20 (first published: 2011/04/13) | Source: SQLServerCentral.com | Category: stairway series
Rating: |  Discuss |   Briefcase | 25,784 reads

SSRS Reports Performance Debugging and Analysis

SSRS provides a very user friendly way to author and deploy reports. These reports can be accessed from different platforms where the reports are deployed - reports manager, SharePoint, stand-alone / distributed applications or programmatically using SSRS SOAP endpoints. Unfortunately, SSRS / BIDS does not provide any high-end debugging tools such as SQL Profiler for analyzing the performance of SSRS reports. In this tip we will look at different ways of debugging and analyzing SSRS reports performance using execution logs and freeware tools.  Read more...
By Additional Articles 2011/03/28 | Source: MSSQLTips.com | Category: reporting services (ssrs)
Rating: (not yet rated)  Rate this |   Briefcase | 4,527 reads
<< Newer    Items 61 to 80 of 283    Older >>