Monday, March 19, 2012

Matrix report - need a clue

My data is like this:

QualifiedDate Total DateTimeQualified

2007-05-11 30 5/11/2007 3:12

2007-05-11 29 5/11/2007 6:28

2007-05-10 22 5/10/2007 1:54

2007-05-10 10 5/10/2007 5:55

Report needs to be like this:

2007-05-11 59

2007-05-10 32

with a drill down option to get it broken down my the datetimequalified

I've seen some examples but they are so overblown I can't figure it out

Can someone give me something simple to start with?

A simple table report should do this, I can't see the need for a Matrix as you have no column field.

In the data detail line of your table, place the three detail fields you wish to drilldown to

QualifiedDate

Total

DateTimeQualified

Then you need to group by QualifiedDate, adding the Qualified date value to the group header/footer along with a summary field in the group header/footer which will be expression =sum(Fields!Total.Value)

You can then make the whole detail row "hidden" and toggle visibility using one of your group header/footer textboxes

No comments:

Post a Comment