RDL me this - how do you write reports if all you have is SQL Server Express Advanced Services Edition?

ktegels — Tue, 26 Aug 2008 22:04:00 GMT

A few days ago via Twitter (http://www.twitter.com/, follow me as ktegels), Mr. Lowe (AKA Vendoran) asked "SQL Express with Advanced services comes with SSRS, but does it come with the ability to create/edit rdl in VS?"

The short answer to that question is "it depends." In most of the pay-for-license editions of Visual Studio you can use the Report Viewer controls to do that. For example, you can create a new C# Windows Forms project, then drag and drop a Report Viewer control on the form. After you have created the report you want, you will find an "RDLC" file in that project. RDLCs are, essentially, RDL files designed for use with the Report Viewer control. The good news is that these can be used Report Manager in most cases if you: a.) rename the file with an extension of RDL instead of RLDC before uploading and b.) reconfigure the connection string used by that report to a shared connection defined within Report Manager. However, the Expression Version of Visual Studio does not support this. True, you can look for, enable and use the Report Viewer control, but you will not be able to design a report in the Express SKU.

So what to do, what to do? Your best bet today is download and install the Report Builder 2.0 tool. Robert Bruckner, a member of the SQL Server team specializing in Express/Advanced Services edition, has a blog post (http://blogs.msdn.com/robertbruckner/archive/2008/08/25/ReportBuilder-20-RC1-Release.aspx ) about this tool and a download link. I tried this new tool today. It feels very much like the Report Designer in SSRS2008 - a good thing indeed. When you save a designed report, you get an RDL file. Based on what Mr. Bruckner says in blog, I believe this tool has been target to help solve the riddle at hand.

I am currently building a VPC with SQL Server 2008 Express Edition with Advanced Services to see if some version of this tool is included with it. If so, it looks like we have a good solution for low-cost reporting in hand.

By the way, if you are using the new AdventureWorks2008 OLTP database, you might want to check out this "issue" (http://www.codeplex.com/MSFTDBProdSamples/WorkItem/View.aspx?WorkItemId=7427) I found with "[HumanResources].[vEmployeeDepartment] .Your votes would be appreciated.

Enjoy Another Sandwich -- Kent Tegels : SSRS 2008

RDL me this - how do you write reports if all you have is SQL Server Express Advanced Services Edition?