riverlau的专栏

Tutorial: Creating a Basic Table Report (SSRS) Tutorial: Adding Parameters to a Report (SSRS) http://msdn.microsoft.com/en-us/library/bb522859.aspx Lesson 6: Adding Grouping and Totals

http://chanmingman.wordpress.com/2008/11/22/the-report-parameter-%E2%80%98sales%E2%80%99-has-a-defaultvalue-or-a-validvalue-that-depends-on-the-report-parameter-%E2%80%9Csales%E2%80%9D-forward-depende

Basic  -Add New Report  -Add DataSource -Add DataSet -Use Query Designer -Add Metric, Dimension tables -(Optional)Add Parameters -Set Available Values -Set Default Values

Use a table to display detail data or grouped data, or a combination of both. You can group data by a single field, by multiple fields, or by writing your own expression. You can create nested group

http://msdn.microsoft.com/en-us/library/ms159121.aspx http://road-blogs.blogspot.com/2010/05/better-way-of-repeating-charts-based-on.html Sample - use table & group to dynamic display chart 1

Refer to :http://www.sqlchick.com/entries/2010/9/19/expand-or-collapse-all-grouped-items-on-ssrs-report.html 1.  In the Row Groups pane, right-click the Details group and choose Group Properties.

DataSet SELECT 1 AS RowNumber, '2007' AS x, 48123 AS y, 33 AS others UNION ALL SELECT 2 AS Expr1, '2007' AS x, 52000 AS y, 44 AS Expr2 UNION ALL SELECT 3 AS Expr1, '2009' AS x,