Dazzle your SSRS Report with SparkLines

Hi All, “SparkLines” is a new feature introduced in SQL Server Reporting Services 2008 R2. Fast Facts about SparkLines: •    It is the simplest way to make your data/values intelligent by showing them in visual way. •    Because it’s a tiny-chart representation, makes report elegant, meaningful and non-messy. •    Report users can choose to dig …

Continue reading ‘Dazzle your SSRS Report with SparkLines’ »

MDX Query Parameterization for displaying Last 12 month’s SSRS Report

Hi All, While working with SSRS reports for displaying some financial data; many a times we have to display data for particular time-frame. Or most commonly – last 12 month’s data. I am talking about the case where you are pulling data from SSAS Cube using MDX queries. In this particular example, I need to …

Continue reading ‘MDX Query Parameterization for displaying Last 12 month’s SSRS Report’ »