****************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\SSRS\Record Sorting new3.rdl
****************************************************************************


Report Information
    Description    Report Title: Sorting and Section Coloring
                   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.[Last Year's Sales], Customer.Region, Customer.[Customer Name] 
                           FROM   Customer Customer  
                           WHERE ((Customer.Country = 'Belgium') OR (Customer.Country = 'Germany') OR (Customer.Country = 'France') OR (Customer.Country = 'England') OR (Customer.Country = 'Canada') OR (Customer.Country = 'Mexico') OR (Customer.Country = 'USA'))
                            
                           ORDER BY Customer.Country, Customer.Region, Customer.[Last Year's Sales] DESC

            Parameters

        Fields

            Country
                Name    Country
                Source    Country
                Data Type    String

            Last_Year_s_Sales
                Name    Last_Year_s_Sales
                Source    [Last Year's Sales]
                Data Type    Decimal

            Region
                Name    Region
                Source    Region
                Data Type    String

            Customer_Name
                Name    Customer_Name
                Source    [Customer Name]
                Data Type    String

Embedded Images

    Picture_90F76FB8D5A625EA394F942110BD3471
        Name    Picture_90F76FB8D5A625EA394F942110BD3471
        Type    jpeg

    Picture_6A6A5C3C493C1CF3356B8163696F60DF
        Name    Picture_6A6A5C3C493C1CF3356B8163696F60DF
        Type    jpeg

    Picture_FB28B4C2D5109A53B569DFD87F011CBA
        Name    Picture_FB28B4C2D5109A53B569DFD87F011CBA
        Type    jpeg

Page Header

    Report Items

        RO_Header_Fade1
            Name    RO_Header_Fade1
            Type    Image
            Source Type    Embedded Image Name
            Embedded Image Name    Picture_90F76FB8D5A625EA394F942110BD3471

        Text1
            Name    Text1
            Type    Text Box
            Content    Features: Record Selection Formula, Grouping, Sorting, Running Total, Highlighting, Hyperlink, Percentage Summary...

        Text4
            Name    Text4
            Type    Text Box
            Content    Country

        Text6
            Name    Text6
            Type    Text Box
            Content    Customer Name

        Text5
            Name    Text5
            Type    Text Box
            Content    Region

        Text3
            Name    Text3
            Type    Text Box
            Content    Last Year's Sales

        Text2
            Name    Text2
            Type    Text Box
            Content    Running Total

        Text8
            Name    Text8
            Type    Text Box
            Content    Crystal Migration Services - the # 1 to Convert Crystal Reports to SSRS

            Actions
                Go to URL    http://www.crystalmigration.com/

        Text9
            Name    Text9
            Type    Text Box
            Content    Pecentage

        PrintDate1
            Name    PrintDate1
            Type    Text Box
            Content    =Format(Globals.ExecutionTime, "dd-MMM-yyyy")

        PageNofM1
            Name    PageNofM1
            Type    Text Box
            Content    ="Page " & Globals.PageNumber & " of " & Globals.TotalPages

Body

    Report Items

        RectGroupHeaderArea1
            Name    RectGroupHeaderArea1
            Type    Rectangle

        GroupNameCountry1
            Name    GroupNameCountry1
            Type    Text Box
            Content    =Fields!Country.Value

        SummarySumofLastx0020Yearx0027sx0020Sales1
            Name    SummarySumofLastx0020Yearx0027sx0020Sales1
            Type    Text Box
            Content    =Sum (Fields!Last_Year_s_Sales.Value)

        Text10
            Name    Text10
            Type    Text Box
            Content    Summary of =Fields!Country.Value

        RectDetailArea1
            Name    RectDetailArea1
            Type    Rectangle

        DetailSection1FillBox
            Name    DetailSection1FillBox
            Type    Rectangle

        Last_Year_s_Sales
            Name    Last_Year_s_Sales
            Type    Text Box
            Content    =Fields!Last_Year_s_Sales.Value

        Region
            Name    Region
            Type    Text Box
            Content    =Fields!Region.Value

        Customer_Name
            Name    Customer_Name
            Type    Text Box
            Content    =Fields!Customer_Name.Value

        RT_RTotal01_RTotal0
            Name    RT_RTotal01_RTotal0
            Type    Text Box
            Content    =RunningValue(Fields!Last_Year_s_Sales.Value, Sum, "Group1")

        Pecentage1_Pecentage
            Name    Pecentage1_Pecentage
            Type    Text Box
            Content    =(Format ((Fields!Last_Year_s_Sales.Value / (Sum(Cdbl(Fields!Last_Year_s_Sales.Value), "Group1"))) * 100, "#,##0.00")) + "%"

        RectGroupFooterArea1
            Name    RectGroupFooterArea1
            Type    Rectangle

    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
                Sort Expressions    =Fields!Region.Value
                                    =Fields!Last_Year_s_Sales.Value

            Row Member 3
            Source Dataset    DataSet1

Page Footer

    Report Items

        RO_Footer_Fade1
            Name    RO_Footer_Fade1
            Type    Image
            Source Type    Embedded Image Name
            Embedded Image Name    Picture_6A6A5C3C493C1CF3356B8163696F60DF

        RO_Tech_Support_link
            Name    RO_Tech_Support_link
            Type    Text Box
            Content    Crystal Migration Services Samples

            Actions
                Go to URL    http://www.crystalmigration.com/Samples.aspx

        RO_e_mail_Feedback
            Name    RO_e_mail_Feedback
            Type    Text Box
            Content    Contact us by Email

            Actions
                Go to URL    mailto:support@crystalmigration.com

        RO_Copyright_Information
            Name    RO_Copyright_Information
            Type    Text Box
            Content    Crystal Migration Services provides leading-edge conversion services that get the job done in seconds, and with a level of accuracy that other companies just don't have.
                       Don't wait, and don't spend more. Contact us today! 

        Picture1
            Name    Picture1
            Type    Image
            Source Type    Embedded Image Name
            Embedded Image Name    Picture_FB28B4C2D5109A53B569DFD87F011CBA

            Actions
                Go to URL    http://www.crystalmigrater.com