Give Blood (Report Expressions in Report Builder)

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, you can add a time / date stamp to a report…


Fingerpops (RS and Flattened Rowsets)

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 AS provide identical functionality to cellsets. The exact same information is provided by AS to the client application – …


Snowing Sun (New RDL Specification)

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.


Antics (SQL 2005 Documentation Updates)

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 interesting because the hotel we were in…