Reporting Services
3.9K views | +0 today
Follow
Reporting Services
My collected tips on SSRS
Curated by Irawan Soetomo
Your new post is loading...
Your new post is loading...
Scooped by Irawan Soetomo
Scoop.it!

Display Dynamic Image

Display Dynamic Image | Reporting Services | Scoop.it

If you are storing images in file system and keeping the file location in MS SQL Server database tables, you might want to display database images by reading them from sql tables and showing them on web pages.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Custom Code Assemblies

Custom Code Assemblies | Reporting Services | Scoop.it

In a previous tip, I described the process of adding code directly to an individual SSRS report. As noted in the tip, using embedded code provides for some code reuse while at the same time giving report developers, local report level customized coding. Similarly, we can actually take the coding to a second level by creating custom code assemblies that are referenced by a SSRS report via a class\ function embedded in a dll. Of course, using this method extends our code reuse from beyond a single report to across a group of reports. We can then make changes in one location which will then be applied to all reports which reference the assembly code. Furthermore, we can add multiple functions within a single class file, and of course, the coding can take place in Visual Studio and allow for easier use of version control applications. Finally, the coding can be completed in any DotNet language; for this tip, though, we will use Visual Basic. As with any process, there are some disadvantages which include a rather complicated process of creating, deploying, and referencing the code assembly, and many find troubleshooting the assembly to be rather complicated. Finally, report data sets are not allowed to be passed to custom assemblies.

Irawan Soetomo's insight:
more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Configure a Report Server on a Network Load Balancing Cluster

Reporting Services does not provide functionality for load balancing a scale-out deployment or for defining a single point of access through a shared URL. You must implement a separate software or hardware NLB cluster solution to support a Reporting Services scale-out deployment.

 

You can install Reporting Services on nodes that are already part of an NLB cluster, or you can configure a scale-out deployment first and then install cluster software.

Irawan Soetomo's insight:

http://blogs.msdn.com/b/brushstrokes/archive/2013/04/29/configure-a-report-server-on-a-load-balancing-deployment.aspx

 

https://www.mssqltips.com/sqlservertip/2545/highly-available-scaleout-sql-server-2008-r2-reporting-services-farm/

 

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Formatting Numbers

Formatting Numbers | Reporting Services | Scoop.it

You should also be aware that the formatting functionality is not specific for SSRS only.  If you’ve got some development experience you’ll probably recognize some syntax.  SSRS is actually just a layer on top of the .NET framework, as far as formatting is concerned.  So in many cases you’ll find interesting info online by searching in the .NET documentation.  I’ll be referring to several .NET-related pages in the text below.

Irawan Soetomo's insight:
more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Using Different Formats Within a Single Textbox

Using Different Formats Within a Single Textbox | Reporting Services | Scoop.it

Reporting Services 2008 introduced enhanced rich text functionality to permit mixed formatting, or even mixed tooltips & actions, within a single textbox.  There’s several ways mixed formatting can be accomplished.  Placeholder Properties can be used with the GUI formatting options, or with a subset of HTML tags.  The GUI formatting options work best with simple expressions, whereas the HTML options provide a lot of flexibility for complex expressions.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Enhancements on 2008 R2

If you thought Microsoft SQL Server 2008 Reporting Services introduced a lot of great new features to the reporting platform, just wait until you discover what's new in Reporting Services in SQL Server 2008 R2.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Align X Axis to Y=0 on Two Y Axes

Align X Axis to Y=0 on Two Y Axes | Reporting Services | Scoop.it

The trick is knowing what must line up. It all boils down to 7th grade algebra, but try finding a 7th grader when you need one. In order for the X axis to split both Y axes at the same point, the relative amounts above and below must be the same.

Irawan Soetomo's insight:

https://social.technet.microsoft.com/Forums/windowsserver/en-US/d2d133ff-1472-463c-ab7a-5a02f6141ee3/getting-dual-axis-on-a-graph-in-ssrs-to-align-at-0

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Charts with Dynamic Height or Width based on Categories/Data

Charts with Dynamic Height or Width based on Categories/Data | Reporting Services | Scoop.it

You may have been in this situation before - you designed a chart based on a particular dataset and everything looks great.  However, later the data volume increases, or new categories dynamically show up in your data source, and there is not enough horizontal/vertical space in the chart to show all the data or categories.  Unless, of course, you applied an approach to dynamically increase the height/width of the chart.   

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Interactive Sorting a Matrix

Interactive Sorting a Matrix | Reporting Services | Scoop.it

Sorting a matrix report can be done interactively. To perform interactive sorting, your report will need a cell to click on to perform the action. In the image below you can see a basic matrix report with State as the row group, with year and quarter as the column groups. You want to be able to interactively sort the report on all of these groups.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

How To Convert RDL files to RDLC files

How To Convert RDL files to RDLC files | Reporting Services | Scoop.it

.Net use RDLC files for reporting and SQL Server (Reporting Services) use RDL files for reports files. In this Article we will take a look at RDL and RDLC files and also a way to convert RDL files to RDLC files.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

User does not have required permissions. Verify that sufficient permissions have been granted and Windows User Account Control (UAC) restrictions have been addressed

UAC is causing the error, from

http://support.microsoft.com/kb/934164.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Repeating Column Headers on Every Page Doesn’t Work! …Or Does It?

Repeating Column Headers on Every Page Doesn’t Work! …Or Does It? | Reporting Services | Scoop.it

This entry is to expand on my previous blog about Repeating Column Headings which discusses the use of Advanced Tablix Member Properties to repeat column headings on each page.  If you haven’t used the “RepeatOnNewPage” property too much, it can seem like sometimes it works & sometimes it doesn’t.  It can definitely be a bit frustrating.  

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Rendering images from a database

Rendering images from a database | Reporting Services | Scoop.it

I have a requirement to put images on SSRS reports and allow the business users to change the images every so often. I want to implement this in such a way that I don't have to modify a report when the image is changed. How can I do that?

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Stripping HTML tags from SSRS text fields

Stripping HTML tags from SSRS text fields | Reporting Services | Scoop.it

One of the common requirements is to strip HTML from text values displayed in reports and apply standard formatting to the text. HTML have many encoded characters which end users don’t want to see.

Irawan Soetomo's insight:

http://stackoverflow.com/questions/29869/regex-to-match-all-html-tags-except-p-and-p

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Report Execution Statistics and Analysis

Report Execution Statistics and Analysis | Reporting Services | Scoop.it

Understanding and analyzing your SSRS report execution statistics is critical if you are serious about optimizing your SSRS reports, over the years working with SSRS I have found and developed a few procedures that are helpful in analyzing problematic report (in terms of execution time).

Irawan Soetomo's insight:

http://www.keepitsimpleandfast.com/2011/07/more-tips-to-improve-performance-of.html

 

Troubleshooting Reports: Report Performance, https://technet.microsoft.com/en-us/library/bb522806%28v=sql.105%29.aspx.
more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

401 Unauthorized access Error

You remote onto the new server, deploy all of your reports, open up IE on your server and check the reports; they run and life is good. You give the all clear to your users and suddenly your inbox is flooded with "My Reports do not work, I am getting a weird error" Testing it out for yourself on your computer, you suddenly see the dreaded "401 - Unauthorized Access Error". You go and check the data sources, you are using Windows Authentication, everything looks good. All of the user/group permissions on the reporting server are also correct. You remote onto the server, the reports run and once again they work. You then ask the Lord Google for an answer and see a ton of Kerberos discussions and different links. !@##$#@ you say to yourself. What did I do??? You have stumbled onto the Double-Hop Authentication Problem that so many of us have hit before in ASP.NET land or even SSRS.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Sherry's BI Corner

Sherry's BI Corner | Reporting Services | Scoop.it

I blogged around my daily experience as a Data Warehouse and Business Intelligence developer. Most of my posts are about how to use the tools, i.e. the Microsoft SQL Server Business Intelligence stacks with more productivity and efficiency, of cause, also about the two major data query languages, SQL and MDX. I enjoy working as a DWH and BI developer for the creativity I found in all I do. I mostly praise the tools and the query languages we use, but occasionally my posts complain about the the inefficiency and even bugs in the tools.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Dynamic Sorting Using Parameters

Dynamic Sorting Using Parameters | Reporting Services | Scoop.it

The other day, someone requested that a report in SSRS be sorted differently by default. While that might make sense if everyone wants it that way, more than likely you might have people that want a report sorted differently by default. How to do it?

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

AdventureWorks 2008 SR4

This release is dedicated to the sample databases that ship for Microsoft SQL Server 2008. See Database Prerequisites for steps to take before installing the databases. See Installing Databases for step by step installation instructions. This release contains a simpler, more reliable installer which should make installation easier and more robust.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Custom Programming

Custom Programming | Reporting Services | Scoop.it

One of the most compelling capabilities in SQL Server Reporting Services (SSRS) is the ability to extend report features with custom code and programming extensions. Here are step-by-step instructions on how to write a custom assembly with Visual Studio and use it to build a dynamic report dataset.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Walkthrough: Integrating your SQL Server Reporting Services report into Windows 7 Sidebar Gadget

Walkthrough: Integrating your SQL Server Reporting Services report into Windows 7 Sidebar Gadget | Reporting Services | Scoop.it

By default, after installing Window7 operation, there are many powerful and handy little tools in Sidebar Gadget, you can also download some customized Sidebar Gadget, such as: MSDN forum helper. Currently, we have some stock reports to show the real-time status of stock market, we also want to integrate SQL Reporting Services - stock report into window7’s Sidebar Gadget rather than open the IE all the time.

more...
No comment yet.
Scooped by Irawan Soetomo
Scoop.it!

Displaying Fixed Number of Rows per Page

Displaying Fixed Number of Rows per Page | Reporting Services | Scoop.it

First, add a Row Group which is a Parent of the existing top level group.  In the Group By expression, enter =CEILING(RowNumber(Nothing)/50) where 50 is the number of records to be displayed per page.  Be sure to leave the group header & footer boxes unchecked.  Since this group’s only purpose will be to force page breaks, we won’t be taking up any real estate on the report.

more...
No comment yet.