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…