Category Archives: SSRS Tips

SSRS – SQL Server Reporting Services Report Manager Tips and Tricks

In the last post, we saw SQL Server Reporting Services Tips and Tricks to Improve the End-User Experience. In this post, we will see few tips and tricks on SSRS Report Manager.

Report Manager is a pretty decent interface and offers the necessary functionality for managing reports. In this post, let’s take a look at few very less known uses/features of SSRS Report Manager. In this post, we will take a look at the following tips and tricks:

  • Customizing Report Manager Header/Title
  • Uploading Custom File Types to Report Manager
  • Enable My Reports Feature

To continue reading, catch the full article here: SQL Server Reporting Services Report Manager Tips and Tricks.

Related Articles:

Advertisements

SQL Server Reporting Services Tips and Tricks to Improve the End-User Experience

In the last post, we saw SQL Server Reporting Services (SSRS) Expressions Tips and Tricks. In this post, we will see few tips to improve the end-user experience with SSRS.

SSRS is a great reporting tool and for us to be able to deliver/address most or all of the end-user needs/requirements, we need to have a good understanding of the tool and its capabilities. In this post, we will take a look at the following tips and tricks:

  • Display Total Number of Pages while Navigating
  • Display Everything in a Single Page
  • Display Report Parameter Selection
  • Display No Rows Error Message
  • Page Settings for Optimal Printing

To continue reading, catch the full article here: SQL Server Reporting Services Tips and Tricks to Improve the End User Experience.

SQL Server Reporting Services Expressions Tips and Tricks

Expressions are a very powerful feature of SQL Server Reporting Services (SSRS). They enable us to handle various things dynamically at run-time. In this post, we will take a look at the following Tips and Tricks on SSRS Expressions:

  • Adding Comments in Expressions
  • Displaying Columns Dynamically
  • Referring to Textbox Contents
  • Referring to Contents within Textboxes
  • Adding a Line Break in Expressions
  • Using Visual Basic (VB) Functions

To continue reading, catch the full article here: SQL Server Reporting Services Expressions Tips and Tricks.