"Alex" <samalex@gmail.com> wrote in message
news:%23T%23L5RT2HHA.6128@TK2MSFTNGP02.phx.gbl...
> Hi Everyone,
>
> Under VS 2003 I need to create a drilldown showing multiple entries, but
> when i create a Group By using a Table it only shows the first item.
>
> For example, here's my data:
> MemberID Payment Date Payment Amount
> 112233 2005-02-02 $45
> 112233 2005-01-02 $54
> 112233 2006-02-12 $10
> 114432 2003-04-03 $45
> ... and so forth.
>
> Well I want the report to show this:
> MemberID Total Paid
> +112233 $109
> +114432 $45
>
> And if someone clicks on the Plus next to 112233 the report will look like
> this:
> -112233 $109
> 2005-02-02 $45
> 2005-01-02 $54
> 2006-02-12 $10
> +114432 $45
>
> How can I do this?
>
> Thanks --
>
> Alex
>
>