Friday, March 9, 2012

How to create a drilldown with multiple entries..

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 --
AlexHi Everyone,
A follow-up. I found a wonderful tutorial which shows exactly how to do
this here:
http://www.simple-talk.com/sql/learn-sql-server/beginning-sql-server-2005-reporting-services-part-2/
FYI incase someone runs across this.
Alex
"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
>

No comments:

Post a Comment