Skip to main content

Latest Articles: SSRS


SQL Server 2005 Report Builder and Basic Authorization
Entry Date: Jul 2009 site: Blogs MSDN Rating:
keywords:SSRS; Security;
Article Description:
I have a customer who needs to use Basic Auth with SQL Reporting Services 2005, so I wanted to make sure they could get at Report Builder too.
Comments:

Have your clients ever complained about an error when trying to execute Report Builder? Something like:

Cannot retrieve application. Authentication error.

Why this happens? This happens when the account that the user is using to login is different from the one that he uses to enter in SSRS. It's a bit crappy but click once just use the current identity of the logged user, not the one provided in SSRS to login. Solution ? Enable anonymous access to the folder where Report Builder binaries are placed.

More info:

ClickOnce always runs as a separate process on the client computer. The process identity is the default Windows user credentials. ClickOnce does not share session data with Internet Explorer or obtain the current user security context from Internet Explorer.

ClickOnce sends requests that specify Windows integrated security in the authentication header. If a server is configured for a different authentication type, the server will fail requests from ClickOnce with an authentication error. To work around this issue, you must either configure a server for Windows integrated security or you must enable Anonymous access to eliminate the authentication check.

Click Here To Navigate to the Article

How to identify your SQL Server version and edition
Entry Date: Jun 2009 site: Microsoft Rating:
keywords:SSAS; SSIS; SSRS;
Article Description:
This article describes how to identify your current Microsoft SQL Server version number and the corresponding product or service pack level. It also describes how to identify the specific edition of SQL Server you are using.
Comments:

Determine which version or which service pack is installed on a given SQL Server instance is not something straight forward.

In this doc you will find how to check which version of SQL Server is installed just be execution a single SELECT statement.

Click Here To Navigate to the Article

Installing OfficeWriter on the Server
Entry Date: Jun 2009 site: Office Writer Rating:
keywords:SSRS;
Article Description:
To install OfficeWriter the first time, run the automatic installation. Once InstallShield has unpacked the dll files that contain OfficeWriter, you can re-install OfficeWriter manually (for example, if you are moving OfficeWriter to a different server).
Comments:

SSRS OfficeWriter it's quite a powerful plugin... only a "but"... sometimes it doesn't install straight forward, here you will find manual steps to install it (just in case the wizard install fails).

Click Here To Navigate to the Article

SSRS Report Builder - Issues From Experience?
Entry Date: Feb 2009 site: Stack Overflow Rating:
keywords:SSRS; Performance;
Article Description:
There are several tools like Report Builder: Business Objects, Oracle Discoverer to name a couple. They all have metadata layers that get you some of the way to an end-user reporting tool, however they still really need to be spoon-fed data in a suitable format in order to produce an effective solution. This means that you really need to think in terms of building some sort of data-mart as well.
Comments:

Interesting few tips about how to deploy a Database that would perform almost well in Report Builder.

Click Here To Navigate to the Article

Use Office Writer and Reporting Services to create excel spreadsheets with live links to Analysis Service Cubes
Entry Date: Dec 2008 site: Office Writer Rating:
keywords:SSAS; SSRS; Office;
Article Description:
One of the biggest complaints about SQL Server Reporting Services' out-of-the-box functionality is that when you export a report to Excel you only get static values pasted into cells in the resulting workbook _ all connections with the underlying database which you used to create the report have gone. This is a particular problem when you're working on a business intelligence project and you're chasing after that elusive 'one version of the truth.' As soon as that export happens, the data in Excel gains a life of its own. It can (and probably will) be used to create new reports or be emailed out to other users, and all the time it will be getting more and more out of sync with the original database.
Comments:

Interesting, thought it was not possible to combine SSAS with OfficeWriter, but this sample tells you how to do so.

Click Here To Navigate to the Article

Reporting Services - Add a logo to the Report Manager
Entry Date: Sep 2008 site: Weblogs ASP .net Rating:
keywords:SSRS;
Article Description:

The SQL Server Reporting Services Report Manager is functional, but it's not very customizable. The ASPX pages just reference compiled assemblies, so the only real way to modify them is via CSS.

What makes that more difficult is that the SSRS HTML is poorly constructed so that the tags you'd most want to customize don't have Id's or Classes assigned. For instance, the most obvious customization anyone would want to make is to add a corporate logo, and there's no hook for that at all. The folder image is a simple tag, nestled between two other spacer tags, packed inside an unidentified

, and all those elements are written out in code1. The problem there is that there's no way, even with some descendant selector trickery, to target that folder image.

Comments:

SQL Server Default Report Browser is great for project where you have a limited access... the thing is: clients could ask you to personalize it a bit, corporate logo, colors...

This post explains you how to put your company logo in that navigator, it's possible as well to change the color styles.

Click Here To Navigate to the Article

One to Many Reports with VS.NET 2005 (2.0) Report Designer
Entry Date: Oct 2007 site: codeproject Rating:
keywords:SSRS;
Article Description:
One of the most common types of reports is a master detail report. The following tutorial provides the most straightforward method for creating this type of a report in Visual Studio 2005. We will be using the Access NorthWind database as our data source.
Comments:

How to create a master/detail report step by step, including how to set page break when changing the master ID.

Useful if you need to e.g. create an invoice report.

Click Here To Navigate to the Article

Using SoftArtisans OfficeWriter with SQL Server Reporting Services 2005
Entry Date: Oct 2007 site: ASP Alliance Rating:
keywords:SSRS; Performance; DataSet; Excel;
Article Description:
With OfficeWriter's specialized designer, you can easily redesign existing Reporting Services Templates to enable rich functionality in SSRS reports. To do this, you need to add additional instructions to the Report's definition which lets it know how you would like it rendered when exported through the custom OfficeWriter rendering extensions. Happily, providing these instructions is terribly simple with the OfficeWriter Designer
Comments:

SSRS export to Excel functionallity has an important limitation... is terribly slow when exporting huge amount of data to Excel.

Soft Artisans offers a custom extensions for SSRS that exports to excel huge datasets like a rocket. But... you will need to redesign your reports using Office Writer designer, and you will face some issues on e.g. Excel date formatting (a know bug, pending to be solved).

One of the most strong points of this product is that you can download a trial, get good support, and check if it fits your needs or not

Click Here To Navigate to the Article

Reporting Service using soap call passing XML to Data Extension
Entry Date: Oct 2007 site: codeproject Rating:
keywords:SSRS; XML;
Article Description:
This example uses an ASP.Net filter page to construct an xml which then is used as a parameter passed into reporting service web service call to render the report. The xml parameter is intercepted by a custom data extension DLL which is registered under reporting web service. The custom data extension parses the xml decides which business component web service method to call that will get the dataset to be returned for the report processing. The business component web service acts as the data access layer (DAL) which also accepts the xml as the parameter and parsed out the filters to be added to the query that executes under SQL Server that returns a result set as dataset.
Comments:

Custom extensions is not a very well documented feature on SSRS, and a missing feature of SSRS is the Crystal Report push mode (pass a dynamic created dataset to a report).

In this article you will find how to create a custom extension that will allow you pass a dynamic created dataset / xml file and consume it in your application.

Click Here To Navigate to the Article

How to create a sample application that uses the Reporting Services SOAP APIs to render a report to a selected file format on a Web page
Entry Date: Sep 2007 site: Support Microsoft Rating:
keywords:ASP .net; SSRS; Web Services; Excel;
Article Description:

This step-by-step article describes how to create a sample Microsoft ASP.NET Web application that uses the Microsoft SQL Server 2000 Reporting Services SOAP APIs and the Microsoft SQL Server 2005 Reporting Services SOAP APIs to perform the following:

  • --> Render a report that is deployed on a report server to a supported file format, such as the .pdf file format.
  • --> Open the rendered report on a Web page without saving the file that corresponds to the rendered report on your computer.
Comments:

Very good article !! How to integrate SSRS in your web application.

Sometimes you just want to use you SSRS as a report provider without interface, e.g.: an user clicks over a button on your ASP .net application and you get back and excel spreadsheet with the report that the user selected.

This sample tells you how to do this with few lines of code, just:

  • --> Authenticate (pass credentials) and get the report stream via Reporting Web Services.
  • --> This report stream is redirected to the final user (changing the content type to e.g. excel and flushing the stream).

To take into consideration: although the sample read from the "localhost" server, you can change the URL in code, just by calling

ReportExecutionService rs = new vRSWebReference.ReportExecutionService();
(…)
rs.Url = "http://productionserver/ReportServer/ReportExecution2005.asmx";
Click Here To Navigate to the Article

Using CreateSubscription and the Reporting Service API
Entry Date: Sep 2007 site: OdeToCode Rating:
keywords:SSRS; XML; Web Services;
Article Description:
The CreateSubscription web service method requires careful setup to work correctly. In this article we will demonstrate how to create a report subscription with the web service API using the XmlSerializer.
Comments:

SSRS allows us to create subscriptions either by using the web interface, or by having a database for subscriptions (using this way you can have your own interface to associate subscriptions, without having too much headaches with complicated stuff), you will have some issues like handling multivalued parameters seems not to work fine on a subscription database.

But... if you need to have all the power of SSRS subscriptions in your hands, you will need to dive deep into the SSRS Reporting Services API (programmatically create subscriptions), this article it's an excellent sample to start with.

Click Here To Navigate to the Article

Page (1) Of 2 Next Articles >>