Posts Tagged ‘Reporting Services in Silvelright’

How to Organize Cache on the Server Side of the Silverlight Viewer for Reporting Services.

Vitaliy Korney

Cache is an important part of the reactive application. Let’s imagine that we don’t have any cache on the server side. In that case every request for every page of your report will cause document rendering. Some documents can be rather huge and it’s not efficient to call document rendering. In the ideal situation we should call document rendering once. On the other side we shouldn’t think about cache like about durable storage on the server side.

We have several implementations of cache on the server side. You may use them in your applications. Their names are SessionCache and AspNetCache. SessionCache as you can guess is based on session as well as AspNetCache based on the AspNet Cache.

(more…)

August 5th, 2011

How to leverage snapshots feature in the Silverlight Viewer for SSRS

Vitaliy Korney

Today I’m going to explain how to leverage snapshots feature of Reporting Services in Silverlight Viewer for Reporting Services (version 2.9).

Usually, we have report definition file (rdl) with the specified data source. When we need to display our report, we use the Render method and it causes huge amount of actions on the server side. Reporting Services create query to the data base, then process data and report definition of the report and then we get our report. If you don’t want this routine to happen each time, but to store the rendered report on the server side you may use snapshots. One more use-case when you need snapshots is when you have volatile datasource and you need to store different versions of your report and to get access to them afterwards.

(more…)

July 27th, 2011

Custom Export Filters to Silverlight Viewer for Reporting Services

Vitaliy Korney

How to add up to 20+ Custom Export Filters to Silverlight Viewer for Microsoft SQL Reporting Services 2008 in 3 Simple Steps using Aspose Rendering Extensions.

Introduction

The purpose of this article is to demonstrate how a developer can create a Silverlight application with the ability to display SQL Server Reporting Services reports and export them to 20+ different formats, providing additional features and experience to application users.

To help us solve the task, we use Silverlight Viewer for Reporting Services by Perpetuum Software, a software component allowing display SSRS reports in a Silverlight application and SSRS Rendering Extensions by Aspose, a set of rendering extensions allowing export SSRS reports to various formats, including DOC, DOCX, RTF, Excel 2003/2007, PPT, PPTX, FLV, SWF, etc.

(more…)

July 14th, 2011

How to Display SQL Server Reporting Service Reports in Silverlight (Part 3)

Sergey Piskov

Here are the first 2 parts of this article:

How to Display SQL Server Reporting Service Reports in Silverlight

How to Display SQL Server Reporting Service Reports in Silverlight (Part 2)


Custom Rendering Extension

The main shtick of our approach is that we implement custom XAML rendering extension and set it on the SSRS side. This allows us to provide a user with reports in native Silverlight look. Thus, the report’s look & feel is much better in comparison with HTML document.

Let’s learn how to implement custom rendering extension.
(more…)

June 24th, 2011