Friday, March 30, 2012

Grouping Question

I have data from a dataset like this:

Dte Activity Agent Hours

-- - -

5/1/2007 activity1 agent1 11.0

5/1/2007 activity1 agent2 5.0

How would I group this data in a Table to display like this:

5/1/2007 activity1 agent1 11.0

agent2 5.0

What i've tried so far:

1) Using previous() to blank out Dte and Activity columns if previous is same as current. Does not work becuase agent2 shows many lines below agent1 depending on the size of activity(this field could be very long)

2) Grouping by Dte and Activity would not concat agent field and/ or hours field into one string.

3) Don't want to group concat in database if i don't have to. This makes suming values difficult on the reporting side.

Any ideas?

Thx

clarification:

1st grouping is date
2nd grouping is activity number

So why not just have two groupings?

(how do you tables in these forums?)

assume below is a grid 4 cols by 3 rows, representing a table in RS
where the top rop is "grouping one"
second row is "grouping two"
third row is detail
col1, row1: =fields!DateValue
col2,row2: = fields!ActivityValue
col3,row3: = fields!OtherData1.Value
col4,row3: = fields!OtherData2.Value
...etcsql

No comments:

Post a Comment