Archive for the ‘Reporting’ Category

Web Viewer for Report Sharp-Shooter on IPad

Marketing Dept

In spite of experience and age our developers have preserved youthful ardor when it comes to project testing. The first thing they do when they finishes any product – playing with it.

So far as they are not children, they choose advanced IT toys. That’s why when Web Viewer for Report Sharp-Shooter was finished; they wanted to try it on IPad.

Let’s see how it was:

August 10th, 2011

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

SharpShooter report with a Microsoft Chart, in 2 minutes

Andrew Kazyrevich
 
The other day Darina wrote a fascinating post about using Microsoft Charts in Report SharpShooter. For obvious reasons, this feature is only available for SharpShooter 5.3+ so it’s also an enormous incentive to upgrade ;)
 
Your humble correspondent would like to carry on exploring, and show you how to create a report with MSChart in just two minutes – using the open source PowerShell script I occasionally promote on this blog.
 
In this post, we will

  • create a report with New-Report command
  • make a few tweaks in Report Designer to display a chart
  • and show the report with Show-Report command

Not that there’s something wrong with doing the same thing from Visual Studio, but The Powershell Way is much faster. (more…)

July 24th, 2011