I want to render HTML / RTF *as* HTML / RTF inside a SQL Reporting Services Report

Too bad. Many people have HTML and/or RTF stored in a database, a dataset, or wherever. If you display this text in a Reporting Services textbox, it gets rendered as markup versus properly formatted HTML or RTF.   Currently, Reporting Services gives you no way to render “HTML as HTML” — basically because doing so…


Updated SQL 2005 books online now available

Don’t know how I missed this..this DL has been available for a week now! http://www.microsoft.com/downloads/details.aspx?FamilyId=BE6A2C5D-00DF-4220-B133-29C1E0B6585F&displaylang=en


Where are the Reporting Services samples in 2005?

You’ve installed SSRS 2005, and you’re sure that you chose to include the sample files…yet you don’t see them on your file system…Where are they? There’s one more step you need to take care of…browse to C:\Program Files\Microsoft SQL Server\90\Tools\Samples and you’ll see SqlServerSamples.msi – run this puppy When complete, you’ll find everything you need…


The (un)official guide to SQL Reporting Services 2000 & 2005 interop

I’ve seen tons of questions around if you can use various components of SRS 2000 with SSRS 2005 (and vice-versa), so I’m attempting to document them all in once place. This will hopefully become a good FAQ on the subject…feel free to ask/add more to this list via the comments section   Q. Can you use…


Creating a template report in SQL Reporting Services 2005

In SSRS 2000, there was a specific location on the filesystem where you could drop RDL documents so that they’d show up as possbile new report choices when a developer chose to create new report. The same holds true for SSRS 2005: C:\Program Files\Microsoft Visual Studio 8\Common7\IDE\PrivateAssemblies\ProjectItems\ReportProject If you browse to this location, you’ll notice…


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 Auth except for one behavior: Basically, there is no way…


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 while longer before you actually can start putting SSRS and SQLExpress together. Mike Wachal (a SQLExpress PM) and Brad Syputa…


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 info is official and could change at any…