Welcome to MSDN Blogs Sign in | Join | Help

November 2005 - Posts

Report Builder and Forms Authenticaton in SQL Server Reporting Services 2005

I've had a fair number of questions from my customers around the use of Forms Authentication in conjunction with Report Builder. The basic thing people want to know is "does it work?". As a matter of fact, it does. It functions the same way as with Windows
Posted by russch | 42 Comments

SQL Express and SQL Reporting Services 2005 – Soon, but not yet

2005 Books Online and/or microsoft.com readers know that you can use SQL Express and SSRS together (with a few caveats – hit http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx to view them). However, you're going to have to wait a little

(Almost) everything you need to know about the Report Viewer control in one place

This is the site of one of the ReportViewer PMs...lots and lots of juicy samples. http://www.gotreportviewer.com/
Posted by russch | 0 Comments

Browsing Reporting Services 2005 Reports without IE for Windows

In 2005, there is limited report browsing support for non IE 6 SP1 browsers (IE 6 SP1 with scripting enabled, that is) This info will be fully documented at some point in the future, but in the meantime here are some general nuggets (BTW, none of this

SQL Server 2005 Samples and Sample Databases Available for DL

http://www.microsoft.com/downloads/details.aspx?FamilyID=e719ecf7-9f46-4312-af89-6ad8702e4e6e&DisplayLang=en
Posted by russch | 0 Comments

Impersonating another user with the Web Form Report Viewer control and SQL Server Reporting Services 2005

I covered how to do impersonation with the Winform ReportViewer control a few weeks ago, so here's how to do it with the WebForm version. The first thing to keep in mind is that by default the WebForm ReportViewer will run under the security context of

New Reporting Add-In for Microsoft Visual Web Developer 2005 Express

This one is flying under the radar -- Thought I'd publicize it a bit: http://www.microsoft.com/downloads/details.aspx?FamilyID=D09C1D60-A13C-4479-9B91-9E8B9D835CDC&displaylang=en [Scroll to the very bottom] "The Reporting Add-In for Microsoft Visual

SQL Server 2005 Report Builder and Basic Authorization

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. WARNING: Don't EVER do this unless you are using SSL with Reporting Services! If you turn Basic Authentication

Impersonating another user with the Windows Form Report Viewer control and SQL Server Reporting Services 2005

The Winform Report Viewer control is pretty nifty, but occasionally you'll want to access a remote report server using a different identity than the user logged in at the console. It can be done, but takes a tiny bit of work. You're going to be calling

Using Forms Authentication with the Report Viewer control and SQL Server Reporting Services 2005

I've been playing around with using different forms of authentication / impersonation with the Report Viewer controls, and I thought I'd post the fruits of my efforts. Here we go: Using Forms Authentication with the Winform Report Viewer control is easy

Launching Report Builder from a Winform or Webform Application in SQL Reporting Services 2005

At times, you may need to launch Report Builder from your custom application as either the currently logged in user, or under a different, arbitrary identity. Here's how! Regardless of the technique you use, you're basically going to be hitting the URL
 
Page view tracker