Building Output with Trend Lines

This week's installment of I-Data Weekly focuses on Building Output with Trend Lines. We'll use SQL Server 2005 Reporting Services for our example, and will cover the following: Defining the end result of how we want the chart to look (a bar chart that shows monthly sales, and then 2 trend lines to show sales from last year, along with a monthly sales goal), Laying some groundwork by constructing some necessary MDX calculations to support the chart , Building the base MDX query for the chart , Designing the chart in SQL Server Reporting Services Customizing the chart to show monthly sales from last year, along with sales goal, as trend lines