****************************************************************************
Location : Local or Network Folders
Host     : FINDITEZ-T460P
Path     : C:\Users\ken\Documents\Test Cases\SSRS\Running Totals Group.rdl
****************************************************************************


Report Information
    Description    Report Title: How to maintain running totals for a group
                   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.[Customer Name], Orders.[Order Amount], Orders.Shipped 
                           FROM   Customer Customer INNER JOIN Orders Orders ON Customer.[Customer ID]=Orders.[Customer ID] 
                           ORDER BY Customer.[Customer Name], Orders.Shipped

            Parameters

        Fields

            Customer_Name
                Name    Customer_Name
                Source    [Customer Name]
                Data Type    String

            Order_Amount
                Name    Order_Amount
                Source    [Order Amount]
                Data Type    Decimal

            Shipped
                Name    Shipped
                Source    Shipped
                Data Type    Boolean

Embedded Images

    Picture_9B686CFB00AA497757CA65E94EDA1223
        Name    Picture_9B686CFB00AA497757CA65E94EDA1223
        Type    jpeg

Page Header

    Report Items

        Text2
            Name    Text2
            Type    Text Box
            Content    Customer Name

        Text4
            Name    Text4
            Type    Text Box
            Content    Order Amount

        Text3
            Name    Text3
            Type    Text Box
            Content    Shipped

        Text5
            Name    Text5
            Type    Text Box
            Content    RunningTotal

        Text6
            Name    Text6
            Type    Text Box
            Content    How to maintain running totals for a group

        Text10
            Name    Text10
            Type    Text Box
            Content    RunningTotal
                       (Only Shipped Values)

Body

    Report Items

        RectArea3
            Name    RectArea3
            Type    Rectangle

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

        RectArea4
            Name    RectArea4
            Type    Rectangle

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

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

        Shipped
            Name    Shipped
            Type    Text Box
            Content    =IIF(Fields!Shipped.Value , "Yes", "No")

        RT_Field5_Conditional_GroupRunningTotal
            Name    RT_Field5_Conditional_GroupRunningTotal
            Type    Text Box
            Content    =RunningValue(IIF((Fields!Shipped.Value = True), Fields!Order_Amount.Value, 0), Sum, "Group1")

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

        RectArea5
            Name    RectArea5
            Type    Rectangle

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

        RT_Field11_Conditional_GroupRunningTotal
            Name    RT_Field11_Conditional_GroupRunningTotal
            Type    Text Box
            Content    =RunningValue(IIF((Fields!Shipped.Value = True), Fields!Order_Amount.Value, 0), Sum, "Group1")

        RT_Field12_GrandRunningTotal
            Name    RT_Field12_GrandRunningTotal
            Type    Text Box
            Content    =Sum(Fields!Order_Amount.Value, "DataSet1")

        RT_Field13_GrandConditional_RunningTotal
            Name    RT_Field13_GrandConditional_RunningTotal
            Type    Text Box
            Content    =Sum(Cdbl(IIF((Fields!Shipped.Value = True), Fields!Order_Amount.Value, 0)), "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!Customer_Name.Value
                Sort Expressions    =Fields!Customer_Name.Value

            Row Member 1

            Row Member 2

                Details
                    Name    Details
                Sort Expressions    =Fields!Shipped.Value

            Row Member 3
            Source Dataset    DataSet1

Page Footer

    Report Items

        Field9
            Name    Field9
            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

        Text7
            Name    Text7
            Type    Text Box
            Content    Crystal Care Support Site

            Actions
                Go to URL    http://support.crystaldecisions.com

        Text8
            Name    Text8
            Type    Text Box
            Content    © Copyright 2002 Crystal Decisions, Inc.  All Rights Reserved.

        Text9
            Name    Text9
            Type    Text Box
            Content    Feedback on Samples by E-mail

            Actions
                Go to URL    mailto:crfeedback@crystaldecisions.com