Direct Reports

It's not obvious, but SQL Server 2005 Report Builder allows you to use expressions in textboxes on the report surface. You don't get an expression editor, but if you begin a textbox value with '=', it will be evaluated at report processing time. For example...

We have gotten some negative feedback from customers about the RS/AS integration in SQL 2005. This is frequently communicated as a "flattened rowset versus cellset" issue. While RS does consume data from sources in a rowset format, flattened rowsets from...

We have uploaded a new Report Definition (RDL) specification to the SQL Server web site. The RDLNov05.PDF file contains the SSRS 2005 version. It's the same tags that are documented in SQL 2005 Books Online , just in a single document.

It's been a couple of weeks since my last entry. Lately, we have been working on plans for SQL Server "Katmai" as well as taking some much needed down time. Last weekend, the entire SQL team went up to Whistler, BC for some winter fun. It was especially...