Excel

Here we will learn how to design an SSRS report that will export each region to a separate worksheet in Excel.

The following report contains four Tablix regions. Each one is a table with a single row group representing a calendar year. The Dataset contains a SELECT statements that aggregates sales amount by year and country:

In Part 2 of working with dates we use the INT, DAY and WEEKDAY functions to derive the week number within a month for a given date. The following screen shot shows the desired results, assuming a week starts on a Monday:

Wednesday 1^st June 2011 is in week 5 of the previous month (May) as the Monday of that week was ion the previous month.

Monday 6^th June is in week 1 as it is the first Monday of June.

Question 1: How do I retrieve the date of the first and last day of a date's month?

The following screen shot shows an Excel workbook containing a column (A) of dates from which we extract the first and last dates of the month of these dates:

The following question was put to me last week:

“In the following table there are month on month totals (perhaps for sales). I would like to show the red, yellow and green trend arrows against each value to show the change against the previous month’s value. Using the same logic I need to show the same coloured arrows for the same data expressed as a percentage change.”

In other words, changing this chart...