Browse by Tags
All Tags »
RS 2008 »
RDL (RSS)
At the traditional annual “BI Power Hour” sessions, several teams that contribute to the Microsoft Business Intelligence platform show off their technology in a fun way. It is about demonstrating, in perhaps unusual ways, of how business intelligence
Read More...
In a previous post I showed how to quickly find reports that use custom report items (CRIs). The same idea can be applied to subreports as well. As an administrator of a report server, you may access the catalog database directly. Keep in mind that any
Read More...
I wanted to give some props to MVP Grant Paisley who has setup a site called Report Surfer , where you can directly view, share, and download sample Reporting Services reports. I met Grant a few months back when he visited Redmond. He was very interested
Read More...
As an administrator of a report server, you may occasionally ask yourself the question of what kind of reports are published in terms of their particular feature usage. For example: · Usage of Custom Report Items (CRIs) You plan to upgrade from RS 2005
Read More...
Custom Report Item in Reporting Services 2005 This server extensibility feature introduced in Reporting Services 2005 (RS 2005) provides the ability to develop custom report items for embedding in reports. Examples of resources available that provide
Read More...
Our documentation team made the latest RDL specification available on the Reporting Services site: http://www.microsoft.com/sqlserver/2008/en/us/reporting.aspx The 2008 RDL specification is available as XPS and as PDF document. Older versions of the RDL
Read More...
One of the new chart features in Reporting Services 2008 is the ability to add chart series calculated from another series. This is accomplished by right-clicking an existing series (data point value) and selecting "Add Calculated Series ..." from the
Read More...
You may have been in this situation before - you designed a chart based on a particular dataset and everything looks great. However, later the data volume increases, or new categories dynamically show up in your data source, and there is not enough horizontal/vertical
Read More...
One of the small new features in Reporting Services 2008 that has not been widely publicized, is the ability to directly reference dataset fields and dataset aggregations from expressions in the page header and page footer. You can accomplish this by simply dragging a dataset field directly into the page header/footer area of the report, or by manually writing expressions.
Read More...
In a previous posting, I discussed dataset execution order in Reporting Services. In this posting, I will provide a few tips for situations where you or your report users are wondering what is the actual query executed by Reporting Services. While you
Read More...
One of the questions that I answer somewhat frequently, is about recursive groupings in Reporting Services and how to utilize parent-child hierarchies from an Analysis Services cube. The attachment of this posting contains a small report example I put
Read More...
The Reporting Services demo during the " BI Power Hour " session at the Microsoft Business Intelligence Conference was a lot of fun and well received. My colleague Carolyn Chau did great on stage presenting the demo we had put together. In my chalk talk
Read More...
A Reporting Services report can contain multiple dataset definitions. By default, datasets are executed in parallel . Now, in some situations you may not want this parallel query execution behavior - for example: Your data source system cannot handle
Read More...
Introduction SQL Server 2008 Reporting Services (SSRS 2008) features an on-demand report processing engine . This on-demand architecture has a number of key advantages over the processing engine design that existed in previous major releases. The most
Read More...
