Reports Library

Recursive Sum for a Group in a Matrix in SSRS This report demonstrates how you can create a recursive sum in a matrix in a way that best illustrates the sum rolling up the rows for each column. Report Pack: Custom; Source Database: Adventure Works; Tags: Matrix, Recursive, Sum, Scope, Parent Child;

Filtering a Parameter with a Long List of Values in SSRS This report demonstrates how you can use a parameter with a field that contains a long list of values, in a way that’s friendlier to read for your user. Report Pack: Custom; Source Database: Adventure Works; Tags: Filter, Parameter;

Real Analysis Services Drilldown This report demonstrates a new, and in my opinion better, approach to implementing drilldown in reports with SSAS data sources. Full details can be found on my blog at: http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!4194.entry Report Pack: Adventure Works 2005; Source Database: Adventure Works; Tags: Drill Down, Analysis Services;

Recursive Hierarchy This report contains a small report example based on the Analysis Services 2005 Adventure Works DW sample cube, and demonstrates a recursive hierarchy using the employee dimension. Report Pack: Custom; Source Database: Adventure Works; Tags: recursive hierarchy, employees;

Fields in Page Header 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. Report Pack: Custom; Source Database: Northwind; Tags: Header, Table;

Custom Aggregated Median The scenario discussed is one where a report author implements a custom aggregate, illustrated by an implementation of a Median function. A common pattern for implementing a custom aggregate such as Median Report Pack: Custom; Source Database: Other; Tags: Median, Aggregate;

Trendlines (Calculated Series) 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 popup menu. This report (data are included in the report) shows a simple moving average price trend line. Report Pack: Custom; Source Database: Other; Tags: Column, Line, Chart, Hybrid, Trendline, Moving Average;

Charts with Dynamic Height or Width 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 space in the chart to show all the data or categories. Unless, of course, you applied an approach to dynamically increase the height/width of the chart. Report Pack: Custom; Source Database: Northwind; Tags: Chart, Dynamic Sizing;

• 1
• 2
• 3
• 4
• Next

---