SQL Server related thoughts

This is a collection of links to free articles that may help in studying for

Exam 70 448  -Microsoft SQL Server 2008, Business Intelligence Development and Maintenance

I have broken this up into 6 posts based on the major areas of skills being measured taken from the Microsoft Learning page at

http://www.microsoft.com/learning/en/us/exam.aspx?id=70-448

Fifth up is :

Implementing an SSRS Solution – which accounts for 17 % of the total skils measured

• Implement report data sources and datasets.
  This objective may include but is not limited to: 
  • Query types;
    • http://msdn.microsoft.com/en-us/library/ms156450.aspx
  • Dynamic data sources;
    • http://blogs.lessthandot.com/index.php/DataMgmt/DBProgramming/one-report-for-many-instances-dyanmicall
  • Filter location (dataset vs. query)
    • http://msdn.microsoft.com/en-us/library/ms156270.aspx
• Implement a report layout.
  This objective may include but is not limited to: 
  • http://msdn.microsoft.com/en-us/library/ms159267%28v=SQL.100%29.aspx
  • Apply conditional formatting;
  • Page configuration;
  • Headers and footers
    • http://msdn.microsoft.com/en-us/library/ms159677%28v=SQL.100%29.aspx
• Extend an SSRS solution by using code.
  This objective may include but is not limited to: 
  • Custom .NET assembly;
    • http://msdn.microsoft.com/en-us/library/ms155034%28v=SQL.100%29.aspx
  • Private code
    • http://msdn.microsoft.com/en-us/library/aa902641%28v=sql.80%29.aspx

• Create an SSRS report by using an SSAS data source.
  This objective may include but is not limited to:

• • MDX in an SSRS report;
    • http://msdn.microsoft.com/en-us/library/ms156303.aspx
  • DMX in an SSRS report
    • http://msdn.microsoft.com/en-us/library/ms155812.aspx
• Implement report parameters.
  This objective may include but is not limited to: 
  • Databound parameters;
    • http://msdn.microsoft.com/en-us/library/ms155917.aspx
  • Multi-value parameters
    • http://msdn.microsoft.com/en-us/library/aa337292.aspx
• Implement interactivity in a report.
  This objective may include but is not limited to: 
  • Drilldown;
    • http://msdn.microsoft.com/en-us/library/dd207141.aspx
  • Drillthrough;
  • Interactive sorting
    • http://msdn.microsoft.com/en-us/library/cc627509.aspx
• Implement report items.
  This objective may include but is not limited to: 
  • Matrix;
    • http://msdn.microsoft.com/en-us/library/ms157334%28v=sql.100%29.aspx
  • Table;
    • http://msdn.microsoft.com/en-us/library/ms159169%28v=SQL.100%29.aspx
  • Chart;
    • http://msdn.microsoft.com/en-us/library/ms155847%28v=SQL.100%29.aspx
  • Image;
    • http://msdn.microsoft.com/en-us/library/ms156482%28v=SQL.100%29.aspx
  • List;
  • Grouping ;
    • http://msdn.microsoft.com/en-us/library/ms155903%28v=SQL.100%29.aspx
• Embed SSRS reports in custom applications.
  This objective may include but is not limited to: 
  • Use the Windows Forms Report Viewer;
    • http://msdn.microsoft.com/en-us/library/ms345248%28v=SQL.100%29.aspx
  • Use the Web Forms Report Viewer;
  • Use the SSRS Web service
    • http://msdn.microsoft.com/en-us/library/ms152787%28v=SQL.100%29.aspx