**************************************************************************** Location : Local or Network Folders Host : FINDITEZ-T460P Path : C:\Users\ken\Documents\Test Cases\SSRS\Record Selection.rdl **************************************************************************** Report Information Description Report Title: Record Selection Report Author: © 2002 Crystal Decisions, Inc. Converted By: Crystal Migration Services, support@crystalmigrater.com Data Sources DataSource1 Name DataSource1 Connection String Data Source=CRMIGRATION\SQLExpress;Initial Catalog=Xtreme2005DB;User ID=;Password=;Integrated Security=True; Data Provider SQL 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] FROM Xtreme2005DB.dbo.Customer Customer WHERE Customer.Country IN (@Country) And Customer.[Last Year's Sales] < 100000 ORDER BY Customer.Country Parameters @Country =Parameters!Country.Value 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 Parameters Country Name Country Data Type String Prompt Choose Country to report on MultiValue true Default Value Dataset Reference Valid Value Dataset Reference Values Argentina Aruba Australia Austria Bahamas Bangladesh Barbados Belgium Bermuda Bolivia Brazil British Virgin Islands Canada Chile China Colombia Costa Rica Czech Republic Denmark Dominican Republic Ecuador Egypt England Finland France Germany Greece Hungary India Indonesia Ireland Israel Italy Jamaica Japan Kenya Luxembourg Malaysia Mexico Mongolia Nepal Netherlands New Zealand Nicaragua Northern Ireland Norway Pakistan Panama Peru Philippines Poland Portugal Romania Russia Saint Lucia Saudi Arabia Scotland Singapore South Africa Spain Sweden Switzerland Thailand Turkey Ukraine United Arab Emirates USA Venezuela Vietnam Wales Zimbabwe Embedded Images Picture_A71C16DB5FC6FA97CA22693727225E5E Name Picture_A71C16DB5FC6FA97CA22693727225E5E Type jpeg Picture_9B686CFB00AA497757CA65E94EDA1223 Name Picture_9B686CFB00AA497757CA65E94EDA1223 Type jpeg Page Header Report Items Text4 Name Text4 Type Text Box Text2 Name Text2 Type Text Box Content Customer Name Text3 Name Text3 Type Text Box Content Region 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 create a record selection based on sales < 100000 and the Country chosen via the parameter prompt Body Report Items Text1 Name Text1 Type Text Box Content Record Selection 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 Text4_1 Name Text4_1 Type Text Box Text2_1 Name Text2_1 Type Text Box Content Customer Name Text3_1 Name Text3_1 Type Text Box Content Region 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 create a record selection based on sales < 100000 and the Country chosen via the parameter prompt 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 RectArea5 Name RectArea5 Type Rectangle SummaryField9 Name SummaryField9 Type Text Box Content =Sum (Fields!Last_Year_s_Sales.Value) SummaryField7 Name SummaryField7 Type Text Box Content =Sum (Fields!Last_Year_s_Sales.Value, "DataSet1") Text11 Name Text11 Type Text Box Content Grand 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 Text8 Name Text8 Type Text Box Content Crystal Care Support Site Actions Go to URL http://support.crystaldecisions.com Text9 Name Text9 Type Text Box Content © Copyright 2002 Crystal Decisions, Inc. All Rights Reserved. Text10 Name Text10 Type Text Box Content Feedback on Samples by E-mail Actions Go to URL mailto:crfeedback@crystaldecisions.com