**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\SSRS\Summary Group.rdl **************************************************************************** Report Information Description Report Title: How to summarize grouped data Report Author: � 2002 Crystal Decisions, Inc. Converted By: Crystal Migration Services, support@crystalmigrater.com Data Sources DataSource1 Name DataSource1 Connection String DSN=Xtreme Sample Database 11.5; Data Provider ODBC Datasets DataSet1 Name DataSet1 Query Data Source DataSource1 CommandText SELECT Customer.Country, Customer.[Customer Name], Customer.Region, Customer.[Postal Code], Customer.[Last Year's Sales], Customer.City FROM Customer Customer ORDER BY Customer.Country Parameters Fields Country Name Country Source Country Data Type String Customer_Name Name Customer_Name Source [Customer Name] Data Type String Region Name Region Source Region Data Type String Postal_Code Name Postal_Code Source [Postal Code] Data Type String Last_Year_s_Sales Name Last_Year_s_Sales Source [Last Year's Sales] Data Type Decimal City Name City Source City Data Type String Embedded Images Picture_A71C16DB5FC6FA97CA22693727225E5E Name Picture_A71C16DB5FC6FA97CA22693727225E5E Type jpeg Picture_9B686CFB00AA497757CA65E94EDA1223 Name Picture_9B686CFB00AA497757CA65E94EDA1223 Type jpeg Page Header Report Items Text2 Name Text2 Type Text Box Content Customer Name Text3 Name Text3 Type Text Box Content Region Text4 Name Text4 Type Text Box Content City Text5 Name Text5 Type Text Box Content Postal Code Text6 Name Text6 Type Text Box Content Last Year's Sales Text7 Name Text7 Type Text Box Content How to summarize group data Body Report Items Text1 Name Text1 Type Text Box Content Summarizing Group Data Field1 Name Field1 Type Text Box Content =Format(Globals.ExecutionTime, "dd/MM/yyyy") Field2 Name Field2 Type Text Box Content =Format(Globals.ExecutionTime, "h:m:s tt") Picture4 Name Picture4 Type Image Source Type Embedded Image Name Embedded Image Name Picture_A71C16DB5FC6FA97CA22693727225E5E Text2_1 Name Text2_1 Type Text Box Content Customer Name Text3_1 Name Text3_1 Type Text Box Content Region Text4_1 Name Text4_1 Type Text Box Content City Text5_1 Name Text5_1 Type Text Box Content Postal Code Text6_1 Name Text6_1 Type Text Box Content Last Year's Sales Text7_1 Name Text7_1 Type Text Box Content How to summarize group data RectArea3 Name RectArea3 Type Rectangle Field3 Name Field3 Type Text Box Content =Fields!Country.Value RectArea4 Name RectArea4 Type Rectangle Customer_Name Name Customer_Name Type Text Box Content =Fields!Customer_Name.Value Region Name Region Type Text Box Content =Fields!Region.Value Postal_Code Name Postal_Code Type Text Box Content =Fields!Postal_Code.Value Last_Year_s_Sales Name Last_Year_s_Sales Type Text Box Content =Fields!Last_Year_s_Sales.Value City Name City Type Text Box Content =Fields!City.Value RectArea5 Name RectArea5 Type Rectangle Box1 Name Box1 Type Rectangle SummaryField9 Name SummaryField9 Type Text Box Content =Count (Fields!Customer_Name.Value) Text8 Name Text8 Type Text Box Content COUNT of Customers = Text12 Name Text12 Type Text Box Content SUM of Last Year's Sales = SummaryField11 Name SummaryField11 Type Text Box Content =Sum (Fields!Last_Year_s_Sales.Value) Text13 Name Text13 Type Text Box Content AVERAGE Last Year's Sales = SummaryField12 Name SummaryField12 Type Text Box Content =Avg (Fields!Last_Year_s_Sales.Value) Text14 Name Text14 Type Text Box Content PERCENTAGE of Last Year's Sales = SummaryField13 Name SummaryField13 Type Text Box Content =Sum (Fields!Last_Year_s_Sales.Value)/Sum (Fields!Last_Year_s_Sales.Value, "DataSet1")% Box3 Name Box3 Type Rectangle SummaryField14 Name SummaryField14 Type Text Box Content =Count (Fields!Customer_Name.Value, "DataSet1") Text15 Name Text15 Type Text Box Content COUNT of Customers = Text16 Name Text16 Type Text Box Content SUM of Last Year's Sales = SummaryField15 Name SummaryField15 Type Text Box Content =Sum (Fields!Last_Year_s_Sales.Value, "DataSet1") Text17 Name Text17 Type Text Box Content AVERAGE Last Year's Sales = SummaryField16 Name SummaryField16 Type Text Box Content =Avg (Fields!Last_Year_s_Sales.Value, "DataSet1") Text18 Name Text18 Type Text Box Content PERCENTAGE of Last Year's Sales = SummaryField17 Name SummaryField17 Type Text Box Content =Sum (Fields!Last_Year_s_Sales.Value)/Sum (Fields!Last_Year_s_Sales.Value, "DataSet1")% Text19 Name Text19 Type Text Box Content TOTAL: Data Regions Tablix1 Name Tablix1 Type Table Row Member 1 Group1 Name Group1 Expressions =Fields!Country.Value Sort Expressions =Fields!Country.Value Row Member 1 Row Member 2 Details Name Details Row Member 3 Source Dataset DataSet1 Page Footer Report Items Field10 Name Field10 Type Text Box Content =Globals!PageNumber Picture2 Name Picture2 Type Image Source Type Embedded Image Name Embedded Image Name Picture_9B686CFB00AA497757CA65E94EDA1223 Actions Go to URL http://www.crystaldecisions.com Text9 Name Text9 Type Text Box Content Crystal Care Support Site Actions Go to URL http://support.crystaldecisions.com Text10 Name Text10 Type Text Box Content © Copyright 2002 Crystal Decisions, Inc. All Rights Reserved. Text11 Name Text11 Type Text Box Content Feedback on Samples by E-mail Actions Go to URL mailto:crfeedback@crystaldecisions.com