Grouping issue

I have a matrix that displays data for tags per day on each page. The matrix
has a grouped column that does the grouping by day (this column is returned
from a stored procedure) and page breaks at the end of the day.
This is what I need - before I page break, I need to also display the
statistics per day like avg, min and max values for that day for all the
tags.
Date Tag1 Tag2 Tag3 Tag4
======================================== 10/01/2003 00:00 2 4 6 7
10/01/2003 01:00 2 4 6 7
10/01/2003 02:00 2 4 6 7
======> this is the matrix (grouped by day and page breaks after each day)
10/01/2003 03:00 2 4 6 7
......
10/01/2003 21:00 2 4 6 7
10/01/2003 22:00 2 4 6 7
10/01/2003 23:00 2 4 6 7
========================================= Daily Statistics
--
Sum: 48 96 144 168
======> The Daily Statistics part I am not able to do. Since the matrix has
a page break per
Average: 2 4 6
7 day, I am not able to get the statistics also
on the same page for that day.
Min: 2 4 6
7
Max: 2 4 6
7
==========================================
Any help will be highly appreciated. Thanks.I have a matrix that displays data for tags per day on each page. The
matrix
has a grouped column that does the grouping by day (this column is returned
from a stored procedure) and page breaks at the end of the day.
This is what I need - before I page break, I need to also display the
statistics per day like avg, min and max values for that day for all the
tags.
Date Tag1 Tag2 Tag3 Tag4
======================================== 10/01/2003 00:00 2 4 6 7
10/01/2003 01:00 2 4 6 7
10/01/2003 02:00 2 4 6 7
======> this is the matrix (grouped by day and page breaks after each day)
10/01/2003 03:00 2 4 6 7
......
10/01/2003 21:00 2 4 6 7
10/01/2003 22:00 2 4 6 7
10/01/2003 23:00 2 4 6 7
========================================= Daily Statistics
--
Sum: 48 96 144
168 ======> The Daily Statistics part I am not able to do. Since the matrix
has
a page break per
Average: 2 4 6
7 day, I am not able to get the statistics also
on the same page for that day.
Min: 2 4 6
7
Max: 2 4 6
7
==========================================
Any help will be highly appreciated. Thanks.|||Hello,
I do not have an answer but there is some idea, that could be used.
Could you e-mail me more info about your data and matrix, so I can prepare
working sample?
--
This posting is provided "AS IS" with no warranties, and confers no rights.
"KMP" <KMP@.msn.com> wrote in message
news:OaQofbcFFHA.2180@.TK2MSFTNGP10.phx.gbl...
> I have a matrix that displays data for tags per day on each page. The
> matrix
> has a grouped column that does the grouping by day (this column is
> returned
> from a stored procedure) and page breaks at the end of the day.
> This is what I need - before I page break, I need to also display the
> statistics per day like avg, min and max values for that day for all the
> tags.
> Date Tag1 Tag2 Tag3 Tag4
> ========================================> 10/01/2003 00:00 2 4 6 7
> 10/01/2003 01:00 2 4 6 7
> 10/01/2003 02:00 2 4 6 7
> ======> this is the matrix (grouped by day and page breaks after each day)
> 10/01/2003 03:00 2 4 6 7
> ......
> 10/01/2003 21:00 2 4 6 7
> 10/01/2003 22:00 2 4 6 7
> 10/01/2003 23:00 2 4 6 7
> =========================================> Daily Statistics
> --
> Sum: 48 96 144
> 168 ======> The Daily Statistics part I am not able to do. Since the
> matrix
> has
> a page break per
> Average: 2 4 6
> 7 day, I am not able to get the statistics also
> on the same page for that day.
> Min: 2 4 6
> 7
> Max: 2 4 6
> 7
> ==========================================> Any help will be highly appreciated. Thanks.
>
>|||I have been able to figure it out. Thank you very much.
"Lev Semenets [MSFT]" <levs@.microsoft.com> wrote in message
news:OJYwI8gFFHA.3504@.TK2MSFTNGP12.phx.gbl...
> Hello,
> I do not have an answer but there is some idea, that could be used.
> Could you e-mail me more info about your data and matrix, so I can prepare
> working sample?
> --
> This posting is provided "AS IS" with no warranties, and confers no
rights.
>
> "KMP" <KMP@.msn.com> wrote in message
> news:OaQofbcFFHA.2180@.TK2MSFTNGP10.phx.gbl...
> > I have a matrix that displays data for tags per day on each page. The
> > matrix
> > has a grouped column that does the grouping by day (this column is
> > returned
> > from a stored procedure) and page breaks at the end of the day.
> >
> > This is what I need - before I page break, I need to also display the
> > statistics per day like avg, min and max values for that day for all the
> > tags.
> >
> > Date Tag1 Tag2 Tag3 Tag4
> > ========================================> > 10/01/2003 00:00 2 4 6 7
> > 10/01/2003 01:00 2 4 6 7
> > 10/01/2003 02:00 2 4 6 7
> > ======> this is the matrix (grouped by day and page breaks after each
day)
> > 10/01/2003 03:00 2 4 6 7
> > ......
> > 10/01/2003 21:00 2 4 6 7
> > 10/01/2003 22:00 2 4 6 7
> > 10/01/2003 23:00 2 4 6 7
> > =========================================> > Daily Statistics
> > --
> > Sum: 48 96 144
> > 168 ======> The Daily Statistics part I am not able to do. Since the
> > matrix
> > has
> >
> > a page break per
> > Average: 2 4 6
> > 7 day, I am not able to get the statistics
also
> >
> > on the same page for that day.
> > Min: 2 4 6
> > 7
> > Max: 2 4 6
> > 7
> > ==========================================> >
> > Any help will be highly appreciated. Thanks.
> >
> >
> >
> >
>