SSRS Drill Down in Reports + Sorting of Names

The following video has the details of the drill down and sorting that are done in SSRS 2005, which little change in UI at the SSRS 2008

http://www.youtube.com/watch?v=_-IbUi0rN9A

For more information on the tutorial of this video, can be found at

http://www.learnitfirst.com/


To sort the names alone in the alphabetical wise
(To sort only the names according to the aphabetical order we have to use =ucase(Left(=field.value,1)) at usersort property of the parent group and also at the general, sort place)
--------------------------------------------------------------------
For matrix type of report use the query

Select
Month_Name,
Month,
Year,
(Order_Id) as Order_Count
from
Orders_F
Join
Date_D on Orders_F.ordered_date_key=Date_D.date_Key
where ordered_date between @Start_Date and @End_Date
Group By Month_Name,Year,Month

in such a way that the report preview

Year	Total		January		February	March			April	May	June
2010	31422				2230	2764			3297	3091	3303
2011	21922		2535		2161	2918			2880	2920	3043

----------------------------------------------------------------------------------